Enterprise Data Warehouse (EDW) Informatica ETL Developer

Job Title : Enterprise Data Warehouse (EDW) Informatica ETL Developer

Location : Telecommute (with occasional travel to Springfield, IL)

Type : C2C / W2

Visa Status : H1B

Job Summary :

Client is seeking a highly experienced Informatica Extract Transform Load (ETL) Developer to join our EDW team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Teradata. The ideal candidate will have a deep understanding of data integration, performance tuning, and data warehousing best practices, particularly within healthcare-related data systems.

Key Responsibilities :

• Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various sources.
• Automate data staging processes and optimize ETL job scheduling.
• Administer and support ETL environments, including development and production systems.
• Perform repository backups, recovery operations, and system maintenance.
• Develop mappings, mapplets, sessions, and workflows using various Informatica transformations.
• Monitor and troubleshoot ETL jobs across all environments.
• Write and optimize complex SQL queries and Unix Shell scripts for Teradata data marts.
• Collaborate with stakeholders to define requirements and document technical solutions.
• Participate in unit, integration, and system testing.
• Provide technical support, mentoring, and guidance to team members.

Required Qualifications :

Preferred Qualifications :