Informatica Development Lead

The ETL Development Lead will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for our enterprise data warehouse. Responsibilities include: 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. 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. 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. Working knowledge of Kimball, Inmon, Millbrook design methodology. Knowledge of testing tools and techniques. Responsible for installing, configuring, and managing Informatica PowerCenter on-premise platform. 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. Seniority level

Mid-Senior level Employment type

Full-time Job function

Information Technology

#J-18808-Ljbffr