Informatica PowerCenter Migration Architect / Lead

This is a remote position.

Role Purpose

We are looking for a hands-on Informatica PowerCenter migration specialist who has led or executed modernization programs involving migration of existing PowerCenter workloads to modern cloud/data integration platforms.

This role will assess an existing PowerCenter/PowerExchange estate, identify recurring workload patterns, determine migration complexity, define target migration approaches, and support hands-on migration of representative workloads during POCs.

The person should be comfortable working at both architecture and implementation level. This is not a pure advisory/enterprise architect role.

Key Responsibilities

• Analyze existing Informatica PowerCenter workflows, mappings, sessions, worklets and dependencies.
  
• Review PowerCenter repository metadata and runtime configurations.
  
• Understand source/target connectivity, transformation logic, scheduling, parameterization and error handling.
  
• Assess PowerExchange usage and identify migration implications.
  
• Classify workloads into repeatable migration patterns.
  
• Identify workflows suitable for:
  
  • Snowflake-native processing
    
  • Snowflake Openflow
    
  • dbt
    
  • MuleSoft
    
  • Other approved integration patterns
    
• Determine migration complexity and remediation requirements.
  
• Identify opportunities to consolidate or rationalize existing PowerCenter jobs rather than performing one-to-one conversion.
  
• Define migration patterns, technical specifications and implementation guidelines.
  
• Select representative workloads for POCs.
  
• Perform or guide hands-on migration of selected PowerCenter workloads.
  
• Validate functional equivalence between existing Informatica processing and the proposed target solution.
  
• Identify PowerCenter-specific behaviors that must be reproduced or redesigned in the target environment.
  
• Support migration estimation, wave planning and sequencing.
  
• Work closely with Snowflake, MuleSoft and mainframe specialists.
  

Required Skills

• Strong hands-on experience with Informatica PowerCenter.
  
• Strong understanding of:
  
  • Workflows
    
  • Worklets
    
  • Sessions
    
  • Mappings
    
  • Mapplets
    
  • Parameter files
    
  • Workflow variables
    
  • Lookup transformations
    
  • Joiners
    
  • Aggregators
    
  • Routers
    
  • Expressions
    
  • Update strategies
    
  • Sequence generators
    
  • Stored procedure transformations
    
• Experience with Informatica repository metadata analysis.
  
• Experience troubleshooting PowerCenter runtime and session logs.
  
• Strong understanding of file-based and database-based ETL integration.
  
• Experience migrating PowerCenter workloads to modern cloud/data platforms.
  
• Good understanding of Snowflake and ELT-based architectures.
  
• Ability to distinguish between workloads requiring migration, redesign, consolidation or retirement.
  
• Strong understanding of batch scheduling, dependencies, restart/recovery and reconciliation.
  
• Ability to estimate migration effort based on workload complexity.
  

Strongly Preferred

• Previous migration experience from PowerCenter to Snowflake.
  
• Experience with PowerExchange.
  
• Experience with mainframe-related integration.
  
• Exposure to VSAM and EBCDIC files.
  
• Experience with dbt.
  
• Experience with Snowflake-native transformation and orchestration.
  
• Exposure to Openflow or modern managed data movement platforms.
  
• Experience building migration accelerators or automated metadata assessment utilities.
  

Experience Level

10+ years overall integration/data engineering experience, including significant hands-on PowerCenter experience.

Preference for candidates who have personally executed at least one major PowerCenter modernization/migration program.