Note: We have an immediate requirement for an ETL Development Lead with strong Informatica (on-premise) experience. The ideal candidate should have 11+ years of overall IT experience and proven expertise in ETL development, data integration, and leading development teams.
This position is available across multiple locations, including Morristown, NJ; New York, NY; Purchase, NY; Charlotte, NC; Conshohocken, PA; Dallas, TX; Houston, TX; Alpharetta, GA; Chicago, IL; Colorado Springs, CO; Denver, CO; Fargo, ND; Garden City, NY; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt. Juliet, TN; and Topeka, KS.
ROLE RESPONSIBILITIES
Informatica PowerCenter Developer Certification
- Develop new ETL, complex 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.
- Coordinate development work of all Informatica ETL developers which are located offshore and onshore.
- Allocate work as needed to ensure high quality for their deliverables and support their development.
- Provide technical support for the Administration and Production support of Informatica.
- Provide level three troubleshooting, baseline, and operational support.
- Create and maintain best practices and methodologies for ETL development team.
- Identify improvements to the data warehouse environment.
- Work with the offshore team to implement these solutions.
TECHNICAL QUALIFICATIONS
- 8+ years of experience in the Lead development role for a Data Warehouse.
- 11+ years of experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
- Experience working with complex SQL for ETL development.
- Proven, hands on experience with development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
- Expertise with integration technologies and processes.
GENERAL QUALIFICATIONS
- Excellent analytical, organization, presentation, and facilitation skills; ability to multitask under tight deadlines.
- Working knowledge of Kimball, Inmon, Millbrook design methodology.
- Knowledge of testing tools and techniques.
- Experience within window environment.
- Working knowledge of EDW reconciliation solutions.
ETL Development Lead
(NO Cloud Experience, ONLY On Premise Informatica Experience)
- Bachelor''s degree in Computer Science, MIS, required