Informatica Developer
Location:
Maryland Heights , Missouri
Posted:
September 10, 2017
Reference:
188074BR
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 or equivalent preferred

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


EOE Race/Sex/Vet/Disability
Charter is an equal opportunity employer that complies with the laws and regulations set forth in the following EEO Is the Law poster: http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf
Charter is committed to diversity, and values the ways in which we are different.

A little about us:
Spectrum is the nation’s fastest growing TV, internet and voice company. We’re committed to integrating the highest quality service with superior entertainment and communications products.

Know someone who would be interested in this job? Share it with your network.