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.

Informatica PowerCenter Migration Architect / Lead

Start with your email