Informatica PowerCenter Migration Architect

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.

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, or 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, and 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.

Skills

Informatica, Power Center, Data Migration, Informatica Architect, Snowflake DB, ETL, VSAM, Migration Tools, Data Engineering