ETL Developer

Description

Job role Performs new development and maintenance of the extract, transform, and load (ETL) aspects of the data warehouse. Maintains an understanding of the inputs received from the data source providers. Performs analysis, design, development, and implementation of new ETL requirements. Recommends changes to enhance the data warehouse data cleansing and conversion processes. Supports testing and validation of the new data conversion processes. Possesses strong SDLC experience and manages appropriate levels of systems documentation as required. May act as the Informatica Administrator. Required Skills 6 years Experience with Informatica tools (Version 8.x+), Metadata Manager and Data Quality Experience with Informatica tools (Version 9.x) is desired Hands on experience as an Informatica Administrator is a plus Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment Strong experience optimizing Informatica mappings, sessions, worklets and workflows Experience working in a UNIX, Solaris 10, and Oracle 11g environment Experience writing complex SQL