Informatica Developer

Job Description

We are seeking a highly motivated Informatica Developer with hands-on experience in Informatica PowerCenter, Informatica IDMC/IICS, Oracle, and UNIX. The candidate will be responsible for designing and supporting robust ETL workflows, focusing on healthcare data integrations, especially in Medicare and Medicaid environments. This is a critical role in advancing enterprise data initiatives in compliance with healthcare regulations. Responsibilities: Design, develop, and optimize ETL workflows using Informatica PowerCenter and IDMC/IICS (Cloud Data Integration, Application Integration, Mass Ingestion). Migrate on-premises ETL processes to Informatica IDMC cloud platforms. Work extensively with Oracle databases: writing PL/SQL, stored procedures, performance tuning, and data extraction/loads. Develop shell scripts in UNIX/Linux to automate data processing, file movement, error handling, and workflow orchestration. Integrate and transform healthcare datasets, including claims, eligibility, provider, member, and EHR/EMR data sources. Ensure data integrity and enforce HIPAA-compliant security standards. Collaborate with business analysts, data modelers, and QA teams to deliver accurate and timely data solutions. Monitor production ETL jobs, troubleshoot issues, and implement enhancements. Must-Have Skills: Hands-on development with Informatica PowerCenter. 4-7 years experience with Informatica IDMC/IICS (CDI, CAI). Strong experience with Oracle (SQL, PL/SQL, performance tuning). Proficiency in UNIX/Linux scripting for job automation and workflow control. Solid understanding of ETL architecture, data warehousing, and data quality frameworks. Familiarity with cloud environments (AWS, Azure, or GCP). Strong analytical and troubleshooting skills for complex data flows. Required qualifications to be successful in this role: Good-to-Have Skills: Healthcare domain expertise, especially Medicare and Medicaid (CMS reporting, claims processing, member/provider data, enrollment systems). Understanding of healthcare standards: EDI (837, 835), HL7, FHIR. Experience with PHI/PII compliance and HIPAA regulations. Informatica certifications (PowerCenter or IDMC/IICS). Familiarity with data governance tools and metadata management. Knowledge of DevOps practices and CI/CD pipelines for ETL deployment. Should be ready to work in the Role which involves shifts Skills: Informatica Python