Informatica PowerCenter Migration Architect / Lead

Latentbridge; India; On-site; INR 3,000,000 - 6,000,000; Full time

Job summary

Latentbridge is seeking a hands-on Informatica PowerCenter migration specialist in India to lead modernization programs by migrating PowerCenter workloads to modern cloud/data integration platforms. You will assess the existing estate, define migration approaches, and support hands-on migration of workloads during POCs.

The role requires working at both architecture and implementation levels, not just advisory work, with close collaboration to Snowflake, MuleSoft and mainframe experts.

Qualifications

• Strong hands-on experience with Informatica PowerCenter.
• Understanding of workflows, sessions, mappings, mapplets and parameter files.
• Experience migrating PowerCenter workloads to modern cloud/data platforms.
• Experience with repository metadata analysis and troubleshooting PowerCenter runtime.

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 workloads suitable for Snowflake-native processing, Openflow, dbt, MuleSoft or other patterns.
• Determine migration complexity and remediation requirements.
• Define migration patterns, specifications and implementation guidelines.
• Select workloads for POCs and guide hands-on migration of selected PowerCenter workloads.
• Validate functional equivalence between existing Informatica processing and the target solution.

Skills

Informatica PowerCenter

PowerCenter workflows

PowerExchange

Snowflake

ELT architectures

ETL migration

Workflow scheduling

Mainframe integration

dbt

Openflow

Migration accelerators

Tools

Snowflake

PowerExchange

dbt

Openflow

Job description

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
  
• 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.