Informatica PowerCenter

Must Have Skills

• Hands-on experience migrating Informatica workflows to IDMC.

• Strong understanding of ETL, SQL, and Unix.

• Ability to lead a team working on the migration of Informatica PowerCenter workflows to IDMC.

• Ability to identify migration issues and compatibility challenges and provide appropriate solutions.

Role Summary

We are seeking an experienced Informatica PowerCenter (PC) and Informatica Intelligent Data Management Cloud (IDMC/IICS) Developer to support the migration of enterprise data integration solutions from Informatica PowerCenter to IDMC. The ideal candidate will have strong ETL development experience, hands-on expertise in both PowerCenter and IDMC services, and experience assessing, migrating, and optimizing ETL workloads in cloud environments.

Key Responsibilities

• Analyze existing Informatica PowerCenter mappings, workflows, sessions, and reusable objects for migration to IDMC.

• Design, develop, test, and deploy ETL/ELT solutions using Informatica Cloud Data Integration (CDI) and other IDMC services.

• Perform end-to-end migration activities from PowerCenter to IDMC, including mapping and workflow assessment, conversion and redevelopment of ETL logic, parameter and configuration migration, validation and reconciliation, and performance optimization.

• Review and compare DEV, QA, and PROD environments to identify configuration, parameter, and code differences.

• Validate production configurations and dependencies to ensure accurate migration.

• Migrate and optimize complex transformations, workflows, task flows, and reusable components.

• Work with source and target systems including Oracle, SQL Server, and flat-file integrations.

• Troubleshoot migration issues and resolve data quality, performance, and connectivity challenges.

• Create migration documentation, technical specifications, and deployment procedures.

• Collaborate with architects, business analysts, and support teams throughout the migration lifecycle.

• Perform unit testing, system integration testing, and production validation.

Role Description1. CDI-PC / PowerCenter Asset Analysis

• Analyze Informatica CDI-PC / PowerCenter workflows, mappings, sessions, mapplets, worklets, parameter files, reusable components, and dependency structures.

• Assess current-state conversion readiness, identify complexity drivers, and document technical assumptions, gaps, and risks.

• Review runtime behaviors, parameterization patterns, file handling logic, source/target connectivity, and transformation-level dependencies.

• Analyze B2B service dependencies and EDI-related integration patterns, including awareness of 835/837 file format handling where applicable.

2. IDMC / IICS Design and Build

• Design and create IDMC / IICS assets corresponding to legacy sessions, mappings, workflows, and runtime configurations.

• Create and validate mapping tasks, taskflows, connections, schedules, parameters, and other IDMC assets required for end-to-end migration.

• Ensure IDMC implementation aligns with functional intent, source-to-target rules, transformation behavior, scheduling needs, and operational controls.

• Drive configuration consistency, naming standards, reusable patterns, and environment migration practices across the conversion workstream.

3. Complex Transformation Handling

• Provide technical analysis for complex Informatica transformations, including Java transformations, XML transformations, expression/router/lookup/aggregator patterns, and reusable transformation logic.

• Understand transformation behavior in IDMC compared with CDI-PC / PowerCenter, including capability differences, conversion constraints, and required redesign patterns.

• Identify transformation-specific risks, build IDMC-compatible alternatives, and guide developers on remedi