Job Description

This is a remote position.

Role Purpose

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

This role will assess an existing Power Center/Power Exchange 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 Power Center workflows, mappings, sessions, worklets and dependencies.

- Review Power Center repository metadata and runtime configurations.

- Understand source/target connectivity, transformation logic, scheduling, parameterization and error handling.

- Assess Power Exchange usage and identify migration implications.

- Classify workloads into repeatable migration patterns.

- Identify workflows suitable for:

- Snowflake-native processing

- Snowflake Openflow

- dbt

- Mule Soft

- Other approved integration patterns

- Determine migration complexity and remediation requirements.

- Identify opportunities to consolidate or rationalize existing Power Center 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 Power Center workloads.

- Validate functional equivalence between existing Informatica processing and the proposed target solution.

- Identify Power Center-specific behaviors that must be reproduced or redesigned in the target environment.

- Support migration estimation, wave planning and sequencing.

- Work closely with Snowflake, Mule Soft and mainframe specialists.

Required Skills

- Strong hands-on experience with Informatica Power Center.

- 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 Power Center runtime and session logs.

- Strong understanding of file-based and database-based ETL integration.

- Experience migrating Power Center 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.

- Robust understanding of batch scheduling, dependencies, restart/recovery and reconciliation.

- Ability to estimate migration effort based on workload complexity.

Strongly Preferred

- Previous migration experience from Power Center to Snowflake.

- Experience with Power Exchange.

- 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 Power Center experience.

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

Requirements
**Mandatory Skills:** Informatica Power Center, Power Center Workflows, Sessions, Mappings, Worklets, Mapplets, Parameter Files, Workflow Variables, Lookup, Joiner, Aggregator, Router, Expression, Update Strategy, Sequence Generator, Stored Procedure Transformation, Informatica Repository Metadata, Power Center Runtime/Session Troubleshooting, ETL/Data Integration, Power Center Migration/Modernization, Migration Assessment, Workload Complexity Assessment, Batch Scheduling, Dependencies, Restart/Recovery, Data Reconciliation, Cloud Data Integration, Snowflake/Cloud Data Platform Exposure

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