Job Details

Responsibilities:

  • Develop new ETL and enhancements and modify existing code using Informatica PowerCenter; Work independently to develop, configure, and unit test programs from specs (source to target mappings)

  • Work closely with data architects, reporting team and application team on ETL development efforts

  • Design and document ETL solutions for projects, estimate work effort and provide status of tasks

  • Provide technical support for the administration and production support of Informatica

  • Provide first and second level troubleshooting, and baseline and operational support

  • Adhere to best practices and methodologies for ETL development team

  • Present all work in design and code review sessions to senior team members

  • Prepare documents that describe, and support code developed

  • Identify improvements to the data warehouse environment; Work with the team to implement these solutions

  • Escalate issues to the right party when required

REQUIREMENTS:

  • 10+ years of hands-on experience in ETL development for a data warehouse

  • 10+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes

  • 8+ years of leadership experience, includes the management and coordination of an Informatica team

  • Experience working with complex SQL

  • Expertise with integration technologies and processes

  • Query Surge experience

  • Windows environment experience

  • Knowledge of testing tools and techniques

  • Working knowledge of Kimball design methodology

Apply Now