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 up-to-date 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.

📌 Informatica PowerCenter Migration Architect / Lead (Pune)
🏢 Latent Bridge
📍 Pune