Informatica PowerCenter & IDMC (IICS) Developer Migration Specialist

Location: Pleasanton, CA
Duration: 6 months
Experience Required: 10+ years
Job Title: Informatica PowerCenter & IDMC (IICS) Developer – Migration Specialist
Primary Skill: Informatica PowerCenter

Must-Have Skills

• Hands-on experience migrating Informatica PowerCenter (PC) workflows to IDMC/IICS
• Strong understanding of:
  • ETL
  • SQL
  • Unix
• Ability to lead a team working on PowerCenter-to-IDMC migration
• Ability to identify:
  • Compatibility issues
  • Migration risks
  • Technical gaps
• Ability to provide solutions and remediation approaches for migration challenges

Role Summary

• Experienced Informatica PowerCenter and IDMC/IICS Developer supporting enterprise migration from PowerCenter to IDMC
• Strong ETL development experience
• Hands-on expertise with:
  • Informatica PowerCenter
  • Informatica Cloud Data Integration (CDI)
  • IDMC/IICS services
• Proven experience assessing, migrating, validating, and optimizing ETL workloads in cloud environments

Key Responsibilities

• Analyze existing Informatica PowerCenter:
  • Mappings
  • Workflows
  • Sessions
  • Reusable objects
  • Dependencies
• Design, develop, test, and deploy ETL/ELT solutions using IDMC/IICS CDI
• Perform end-to-end PowerCenter-to-IDMC migration, including:
  • Mapping and workflow assessment
  • ETL logic conversion and redevelopment
  • Parameter and configuration migration
  • Validation and reconciliation
  • Performance optimization
• Compare DEV, QA, and PROD environments
• Identify configuration, parameter, and code differences
• Validate production configurations and dependencies
• Migrate and optimize:
  • Complex transformations
  • Workflows
  • Task flows
  • Reusable components
• Work with source and target systems such as:
  • Oracle
  • SQL Server
  • Flat files
• Troubleshoot:
  • Migration issues
  • Data quality issues
  • Performance issues
  • Connectivity issues
• Create:
  • Migration documentation
  • Technical specifications
  • Deployment procedures
• Collaborate with:
  • Architects
  • Business analysts
  • Support teams
• Perform:
  • Unit testing
  • System integration testing
  • Production validation

CDI-PC / PowerCenter Asset Analysis

• Analyze:
  • CDI-PC / PowerCenter workflows
  • Mappings
  • Sessions
  • Mapplets
  • Worklets
  • Parameter files
  • Reusable components
  • Dependency structures
• Assess conversion readiness
• Identify complexity drivers
• Document:
  • Technical assumptions
  • Gaps
  • Risks
• Review:
  • Runtime behavior
  • Parameterization patterns
  • File-handling logic
  • Source/target connectivity
  • Transformation-level dependencies
• Analyze B2B service dependencies and EDI integration patterns
• Awareness of 835/837 file format handling is desirable

IDMC / IICS Design & Development

• Design and create IDMC/IICS assets corresponding to legacy:
  • Sessions
  • Mappings
  • Workflows
  • Runtime configurations
• Create and validate:
  • Mapping tasks
  • Taskflows
  • Connections
  • Schedules
  • Parameters
  • Other required IDMC assets
• Ensure IDMC implementation aligns with:
  • Functional requirements
  • Source-to-target rules
  • Transformation behavior
  • Scheduling requirements
  • Operational controls
• Drive:
  • Configuration consistency
  • Naming standards
  • Reusable patterns
  • Environment migration practices

Complex Transformation Handling

• Analyze complex Informatica transformations, including:
  • Java transformations
  • XML transformations
  • Expression
  • Router
  • Lookup
  • Aggregator
  • Reusable transformation logic
• Understand transformation behavior differences between IDMC/CDI-PC and PowerCenter
• Identify:
  • Capability differences
  • Conversion constraints
  • Redesign requirements
• Identify transformation-specific risks
• Develop IDMC-compatible alternatives
• Guide developers on remediation approaches

Validation, Testing & DVO

• Own technical validation of converted assets
• Perform/support:
  • Unit testing
  • System integration testing
  • Data reconciliation
  • Defect triage
  • Production-readiness checks
• Create/review Oracle SQL validation queries
• Compare source and target results to confirm conversion accuracy
• Familiarity with Informatica Data Validation Option (DVO)
• Support repeatable reconciliation and automated validation
• Review:
  • Logs
  • Runtime statistics
  • Failure patterns
• Troubleshoot across:
  • CDI-PC
  • IDMC
  • Databases
  • Unix
  • File-handling layers

Estimation, Planning & Delivery Leadership

• Estimate conversion and testing efforts based on:
  • Number of transformations
  • Workflow dependencies
  • Parameterization
  • Source/target count
  • B2B/EDI interactions
  • Custom logic
  • Testing scope
• Break technical work into actionable tasks
• Allocate work based on:
  • Team member skills
  • Complexity
  • Delivery priorities
• Track project progress
• Identify blockers and risks early
• Coordinate with functional teams
• Provide status updates and risk communication
• Drive process improvements
• Develop and promote reusable migration accelerators

Essential Skills

• Informatica PowerCenter
• Informatica CDI-PC
• Informatica IDMC/IICS
• Informatica Cloud Data Integration (CDI)
• ETL/ELT
• Oracle SQL
• Unix
• PowerCenter-to-IDMC migration
• ETL workflow conversion
• Complex transformation analysis
• Data validation and reconciliation
• Migration testing
• Technical leadership
• Team coordination
• Effort estimation
• Migration planning

Desirable Skills

• Azure Data Factory
• Databricks
• Azure Synapse Analytics
• Python
• SQL
• PySpark
• Databricks

Key Resume Keywords

• Informatica PowerCenter
• Informatica PC
• IDMC
• IICS
• Informatica Cloud Data Integration
• CDI
• PowerCenter Migration
• IDMC Migration
• ETL
• SQL
• Unix
• Oracle
• Data Validation Option
• DVO
• Taskflows
• Mappings
• Workflows
• Sessions
• Mapplets
• Worklets
• Java Transformations
• XML Transformations
• Azure Data Factory
• Databricks
• Azure Synapse
• Python
• PySpark