Informatica IDMC CDI Migration Lead

TechDigital Group; Los Angeles (CA); On-site; USD 120,000 - 150,000; Full time

Job summary

A leading technology services company is seeking a Migration Lead for Informatica CDI in Los Angeles. This role will involve analyzing and executing the migration of workflows to a cloud integration platform. The ideal candidate should have over 15 years of experience with Informatica, demonstrate expertise in data integration workflows, and possess strong leadership skills to guide cross-functional teams. You will ensure performance benchmarks, resolve integration issues, and support junior developers in an agile setting.

Qualifications

• 15+ years of overall experience in Informatica Cloud and on-prem services.
• 6+ years of hands-on experience in Informatica CDI-PC migration to IDMC platform.
• Strong working knowledge of PowerCenter to CDI migration.
• Solid proficiency in ETL/ELT concepts, data warehousing principles, and SQL.
• Experience with REST/SOAP APIs and application integration patterns.
• Strong problem-solving skills with the ability to debug performance issues.

Responsibilities

• Lead end-to-end design and development of data integration workflows using Informatica IDMC.
• Drive the PowerCenter to CDI migration tasks—assessment, refactoring, and optimization.
• Create and maintain technical documentation for migrations.
• Ensure AS-IS business logic is implemented during CDI-PC migration.
• Troubleshoot and resolve complex mapping and integration issues.
• Participate in Agile ceremonies and guide junior developers.

Skills

Informatica CDI-PC migration

Data warehousing principles

SQL

Cloud platforms (AWS/Azure/GCP)

ETL/ELT concepts

REST/SOAP APIs

Scripting languages (Python, Shell)

Tools

Informatica PowerCenter

Agile tools (Jira, Confluence)

Job description

Mandatory Skills: Informatica IDMC CDI

JD

The Migration Lead for Information CDI-PC to IDMC CDI Migration will be responsible for analysis, designing, and executing the migration of workflows from CDI-PC to CDI (Cloud Data Integration). This role requires hands on, strong technical expertise in CDI-PC, SAP integration, and workflow design, along with leadership skills to work with cross-functional teams. This role will be crucial in designing, developing, and maintaining cloud-based data integration solutions. The candidate expected to have done a Minimum 2 full-cycle projects of Migration from Informatica CDI/CDI-PC to IDMC CDI.

Responsibilities

• Lead end‑to‑end design and development of data integration workflows using Informatica IDMC – Cloud Data Integration (CDI), including mappings, task flows, transformations, and orchestration.
• Drive the PowerCenter to CDI migration tasks—assessment, refactoring, redevelopment, and performance optimization.
• Hands on experience of PC2Cloud conversion service and perform the assessment, conversion of PowerCenter objects.
• Create and maintain technical documentation (mapping specs, design docs, migration notes, transformation logic).
• Lead end‑to‑end design and development of data integration workflows.
• Ensure the AS‑IS business logic is implemented in IDMC environment during CDI‑PC migration.
• Validate, document data integrity, performance benchmarks, and error handling of the current CDI‑PC and migrated IDMC platform assets.
• Troubleshoot and resolve complex mapping, connectivity, and integration issues in the IDMC environment.
• Collaborate with architects, BA/SMEs, QA teams, and cloud/platform engineers to finalize design and ensure environment readiness.
• Experience in migrating and resolution of migration issues during the CI/CD deployment process.
• Participate in Agile ceremonies and provide technical direction to junior developers where required.
• Please client facing role on the CDI Migration Team

Required Skills

• 15+ years of overall experience in Informatica Cloud and on‑prem services.
• 6+ years of hands‑on experience in Informatica CDI-PC migration, development to IDMC platform.
• Strong working knowledge of PowerCenter to CDI migration (refactoring mappings, redesigning workflows, parameterization).
• Solid proficiency in ETL/ELT concepts, data‑warehousing principles, and SQL across RDBMS platforms.
• Experience with REST/SOAP APIs, JSON/XML, and application‑integration patterns.
• Familiarity with cloud platforms (AWS/Azure/GCP) for connectivity and integration.
• Strong problem‑solving skills with the ability to debug performance issues in IDMC pipelines.
• Excellent communication and collaborative abilities to work with multi‑functional teams
• Exposure to Agile tools (Jira, Confluence) and CI/CD concepts is preferred.

Mandatory Skills

• Minimum 2 full cycle project of Migration from Informatica CDI/CDI-PC to IDMC CDI
• Informatica power center, Informatica Cloud Data Integration (CDI-PC) and CDI
• ETL/ELT Concepts & Data Warehousing
• SQL & Relational Database
• Cloud Platforms (AWS, Azure, Google Cloud)
• APIs & Web Services (REST/SOAP)
• Scripting Languages (Python, Shell) - Preferred but highly valuable