EDW Informatica ETL Developer

Location : Telecommute (with occasional travel to Springfield, IL, two to three times per year)

Job Summary :

We are seeking a highly experienced Informatica Extract, Transform, Load (ETL) Developer to join our Enterprise Data Warehouse (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, with a focus on supporting healthcare-related data systems.

Key Responsibilities :

• Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various agency sources.
• Automate data staging processes and optimize ETL job scheduling for performance and efficiency.
• 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 a wide range of Informatica transformations.
• Monitor and troubleshoot ETL jobs across development, testing, and production environments.
• Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata.
• Collaborate with stakeholders to define requirements, document technical solutions, and support project planning.
• Participate in unit, integration, and system testing.
• Provide technical support, mentoring, and guidance to team members.
• Communicate project status and deliverables to leadership and clients.
• Continuously learn and apply new technologies to enhance system performance and capabilities.

Required Qualifications :

Preferred Qualifications :