ETL Technical Lead
Posted on Feb 29, 2020 by The Royak Group Inc.
As an ETL Technical Lead the ideal candidate will become part of a team responsible for the complete life cycle and the management of Extract Transform Load (ETL) processes and database systems. Collaborating with business, development and testing teams, facilitate accurate data reporting within company standards and maintain 24/7 system availability. Investigate and analyze issues, as well as research opportunities for improvement of processes. Provide expert system and technical advice and guidance to developers. Enable the use of data quality and accuracy as a strategic enabler. Responsible for timely project deliveries Leads in writing and reviewing software functional specifications. Participate in Architecture Review boards as an approver and participant. Mentors team and provide technical and strategic leadership. Collaborates with development teams, business units to identify, define, develop and implement new data source feeds. Monitors usage of the Data Warehouse to identify potential capacity overloads and bottlenecks. Assists with tuning of ETL processes and database performance. Provides support for technical issues and ensuring system availability. Remains current on Enterprise Data Warehousing technologies, testing industry trends and best practices Ownership of projects and responsible for deliverables.
5+ years' experience with data warehouse solution designs supporting data stores such as ODS, EDW and DataMart
5+ years of experience with design of large scale ETL solutions integrating internal and external data sources
5+ years of experience creating design documents like High Level and Low Level design documents.
- 5+ years of experience with either Informatica or Ab Initio.
Troubleshooting/resolving issues related to ETL applications, ETL system performance, and data integrity.
ETL design review, code review, and quality assurance review process and deliverables.
Designing audit solutions.
Data analysis to identify data issues.