Summary:
As a Senior ETL Developer in the Technical Operations organization, the ideal candidate will become part of a team responsible for the complete lifecycle 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.
Essential Duties and Responsibilities
Include the following. Other duties may be assigned:
- 5+ years’ experience with data warehouse solution designs supporting data stores such as ODS, EDW, and DataMart
- 5+ years of experience with the 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.
- Experience troubleshooting and resolving issues related to ETL applications, ETL system performance, and data integrity.
- Experience with ETL design review, code review, and quality assurance review process and deliverables.
- Experience in designing audit solutions.
- Experience with data analysis to identify data issues.
- Experience in working with onsite/offshore models.
- Experience in working in Big Data (Hadoop, MapReduce, etc.) environment
- Experience with NoSQL databases like Cassandra, MongoDB, Hbase, etc.
- Experience in working Data Lake using Amazon Elastic MapReduce (EMR).
- Experience working with Hive database and Hive tables.