MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious
2

Sr ETL Developer

Location St Louis, United States
Posted 29-September-2021
Description
JOB SUMMARY
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.

MAJOR DUTIES AND RESPONSIBILITIES
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, SSIS, or Pentaho

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

REQUIRED QUALIFICATIONS
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, SSIS, Pentaho, or other ETL tools
Experience in developing Informatica, SSIS, Pentaho, 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

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

Related Work Experience Number of Years
Data warehouse operations and development 5+

PREFERRED QUALIFICATIONS
Skills/Abilities and Knowledge
Informatica certification
Experience in Teradata
Experience in Hadoop
Experience in developing SSIS ETL packages and SSAS OLAP cubes
Working knowledge of SSRS
Database Administrator certification or equivalent knowledge
Business Intelligence Developer certification or equivalent knowledge

Education
BS degree in Information Technology; MBA, MIS

Related Work Experience Number of Years
Data warehouse operations responsibilities 3+
Data warehouse operations and development 3+
Media business operations experience may be applicable 5+

WORKING CONDITIONS
Office environment
Travel as required

IDB343-Corporate -CCL - CORPL288631 288631BR

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url