Informatica PowerCenter Migration Architect / Lead in Pune, भारत

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.