Informatica PowerCenter ETL Lead

rekha.nainwal@zodiac-solutions.com

 

Informatica PowerCenter ETL Lead

Onsite- NJ, NY, NC, PA, GA, CO, KS, TX, TN, IL, ND

Long term- HCL

Alii visa will work.

 

Mandatory:: Informatica Certification is mandatory.
Note: This role is specifically for Informatica PowerCenter (On-Premise). It does not involve Informatica Cloud (IICS) or cloud-based data integration tools. 

Job Description:

 

• The ETL Development Lead will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for our enterprise data warehouse.
• 7+ years of experience in a Lead development role for a data warehouse.
• 10+ years of experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
• Experience working with complex SQL for ETL development.
• Experience in  Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications.
• Proven, hands on experience with development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
• 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.
• Prepare runbooks that describe, and support code that is developed, as well as production support.
• Identify improvements to the data warehouse environment. Work with the offshore team to implement these solutions.
• Know when to escalate issues to the right party as required.
• Working knowledge of Kimball, Inmon, Millbrook design methodology.
• Knowledge of testing tools and techniques
• Knowledge of testing tools and techniques
• Responsible for installing, configuring, and managing Informatica PowerCenter on-premise platform.
• Performs user management, monitors server performance, and handles Repository backups and recovery.
• Troubleshoots integration issues, applies patches, and ensures high availability and environment stability.
• Collaborates with developers, DBAs, and infrastructure teams to support ETL processes and optimize performance.
• Take care of ETL migrations across various environments

Regards,

 

Rekha Nainwal

Sr. Technical Recruiter

Desk: (610) 590 1511

Email: rekha.nainwal@zodiac-solutions.com