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.
Numbers & Facts
Location
Morristown, NJ
Industry
Other/Not Classified
Company Size
100 to 499 employees
Skills
Administrative Skillsunmatched
Best Practicesunmatched
Cloud Computingunmatched
Data Recoveryunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Design Documentunmatched
Develop Methodologiesunmatched
General Ledger Softwareunmatched
Guidewireunmatched
High Availabilityunmatched
Identify Issuesunmatched
Informaticaunmatched
Insuranceunmatched
Microsoft SQL Serverunmatched
Offshoringunmatched
Operational Supportunmatched
Oracle Databaseunmatched
Performance Analysisunmatched
Performance Tuning/Optimizationunmatched
Process Improvementunmatched
Production Supportunmatched
Project Estimatesunmatched
Quality Assurance Methodologyunmatched
SAPunmatched
SQL (Structured Query Language)unmatched
Software Patchesunmatched
Team Playerunmatched
Technical Supportunmatched
Test Programunmatched
Test Toolsunmatched
Unit Testunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.