Sr ETL Developer

The ETL Developer will be responsible for the administration and development of ETL processes in support of analytics and reporting functions. ETL Administration includes automation, monitoring, and alerts for ETL processes. ETL development includes bringing data from various sources in support of the Enterprise Data Warehouse, or ad-hoc analytics. The developer will also be responsible for insuring data integrity, and providing detailed documentation of developed processes.

Actively and consistently support all efforts to simplify and enhance the customer experience

Responsible for the ongoing operation of the data warehouse and analytic environments to include advanced technical issues such as ETL performance tuning.

Design extensions and enhancements and ability to enhance the schema and ETL process in order to provide functionality and performance.

Manage data integrity and accuracy of the data warehouse data and analytic environments.

Develop optimized SQL to implement ETL job steps using ETL tools such as Informatica.

Monitor, diagnose and repair all data loading and processing packages to ensure data integrity of the analysis data.

Support ongoing user issues in the use of the systems.

Communicate data warehouse and enhancements to the DBA from the requested analysis enhancements.

Perform data profiling to insure efficient and accurate delivery of data.

Other duties as requested by supervisor.

Skills/Abilities and Knowledge
Ability to read, write, speak and understand English
Proficiency in SQL query development and performance
Proficiency with Unix/Linux shell scripts
Fully trained on the operation of Informatica, or other ETL tools
Experience in developing Informatica, or other ETL tools
Experience with formal data warehouse architecture
Demonstrated skills with troubleshooting and resolving technical issues
Proven ability and desire to learn and apply current technology to data analysis solutions
Experience with business information reconciliation
Experience with training staff on the use of ETL tools
Experience in designing data warehouse schema from business requirements

BS degree in Information Technology; MBA, MIS or equivalent preferred

Skills/Abilities and Knowledge
Informatica certification
Experience in Teradata
Experience in Hadoop
Database Administrator certification or equivalent knowledge
Business Intelligence Developer certification or equivalent knowledge

Office environment
Travel as required

Share this Job

Other Locations For This Job