HCL Technologies
Job Description (Posting).
SR Number:
ERS/ERS/2025/2757409
BR Number: 1616586BR Job Title:
ETL Development Lead
No. of Positions: 1 Hiring Mode: Contract -TP Location:
[ONSITE] 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; Topeka, KS Customer: GEICO Bill Rate: $70-$75/hr max. all inclusive C2C [Based on exp. & location rate may vary] 60000 ERS/ERS/2025/2757409
Skill
Last Used
Experience in Years/month
BR Number:
Hands on Exp. Yes/No
Informatica Power Center Development
Oracle/Sql server
1616586BR
Guidewire Policy Center
Guidewire Claims Center
Job Title:
ETL
Insurance Domain
ETL Development Lead 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.
SR Number:
ERS/ERS/2025/2757409
BR Number: 1616586BR Job Title:
ETL Development Lead
No. of Positions: 1 Hiring Mode: Contract -TP Location:
[ONSITE] 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; Topeka, KS Customer: GEICO Bill Rate: $70-$75/hr max. all inclusive C2C [Based on exp. & location rate may vary] 60000 ERS/ERS/2025/2757409
Skill
Last Used
Experience in Years/month
BR Number:
Hands on Exp. Yes/No
Informatica Power Center Development
Oracle/Sql server
1616586BR
Guidewire Policy Center
Guidewire Claims Center
Job Title:
ETL
Insurance Domain
ETL Development Lead 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.