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 a proven track record of 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
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.
Essential Skills: Informatica PowerCenter & IDMC (IICS) Developer Migration Specialist
Desirable Skills: Azure data factory| Databricks| Azure Synapse Analytics|Python| Sql |Pyspark Databricks