Informatica PowerCenter & IDMC Developer
Core
Lead the end-to-end migration of ETL assets from Informatica PowerCenter to Informatica Intelligent Cloud Services (IDMC), including assessment, conversion, optimization, and validation.
Role type
Senior IC Informatica PowerCenter to IDMC Migration Lead
Builds
Migrated ETL workflows, mappings, taskflows, and data integration pipelines in the cloud
Domain
Data Integration / ETL / Cloud Migration
Required skills
Informatica PowerCenter, Informatica IDMC/IICS, ETL, Oracle SQL, Unix, Java, XML, Data Validation, Migration Strategy
Preferred skills
Azure Data Factory, Databricks, Azure Synapse Analytics, Python, PySpark, B2B/EDI integrations
Technologies
Azure, Databricks, Informatica, Oracle, SQL Server, Python, PySpark, Unix, XML, DevOps
Responsibilities
Analyze PowerCenter workflows to assess migration readiness and complexity. Design, develop, test, and deploy IDMC/IICS assets. Lead end-to-end migration including conversion and performance optimization. Troubleshoot data quality, performance, and connectivity issues. Create SQL validation queries and reconcile source/target data. Estimate effort, allocate work, and track progress for the migration team. Document technical specifications and deployment procedures.
Seniority
Senior, hands-on IC with leadership responsibilities