Design, implement, support and administer the enterprise data warehouse ETL environment.
Assist in the creation, implementation and support of the corporate approved ETL technologies.
Validation of all user interface and functional specifications for the ETL environment.
Assist in creating new standards and procedures related to end user and internal interface development.
Responsible for governance of testing methods and the maintenance and support of the ETL environment.
Conduct research into new data warehouse ETL solutions and determine feasibility.
Assist in creating development standards. Troubleshoot and perform tune existing solutions.
Competent to work at the highest technical level of all phases of data warehouse systems analysis/programming activities.
Demonstrate expertise in a variety of ETL concepts, practices, and procedures.
Relies on extensive experience and judgment to plan and accomplish goals.
Performs a variety of complex tasks. A certain degree of creativity and latitude is required.
May guide various groups on data warehousing ETL activities.
Work under general directions; typically reports to a team lead or Supervisor/Manager.
Candidate Skill Set
5-6 years of experience in architecting, modeling, designing and developing ETL mappings, mapplets, workflows, sessions using Informatica PowerCenter and PowerExchange.
Must have an extensive understanding of all Informatica transformation types and reusable components.
Very good interpersonal communication and written skills, with the ability to work in any environment.
Proficiency in troubleshooting complex SQL Queries and optimize if required.
Proficiency in writing UNIX Shell scripts and troubleshoot if required.
Experience with relational, multi-dimensional and OLAP techniques and technology.
Experience working with IBM DB2
Experience with Informatica MetaData Manager