Informatica ETL Architect - SaaS Modernization Lead

InfoCepts; United States; On-site; USD 140,000 - 200,000; Full time

Job summary

InfoCepts is seeking an ETL Architect with deep Informatica expertise to lead an enterprise asset management modernization program for an energy client. The role focuses on redesigning Informatica pipelines, retrofitting middleware integrations, and enabling robust SaaS table replication while preserving operational reporting.

The candidate will own target-state integration architecture, define reusable patterns, and supervise the validation of inbound/outbound interfaces, ensuring continuity

Qualifications

• 10+ years of experience in data integration and at least 4+ years as an ETL/integration architect.
• Experience re-engineering Informatica workflows and data pipelines for SaaS/cloud migrations.
• Ability to design reusable mapping patterns and governance artifacts.

Responsibilities

• Own the target-state integration architecture for retrofitting Informatica pipelines and middleware integrations after the source platform moves to a vendor-managed SaaS instance.
• Lead re-engineering of Informatica workflows (source to staging, staging to target) and re-point to replicated SaaS tables.
• Design SaaS table replication using AWS DMS and validate table changes before build.
• Guide data governance, data lineage, and scheduling across enterprise jobs (JAMS).
• Stakeholder engagement with client IT leads and vendor teams.

Skills

Informatica PowerCenter

Informatica IDMC

ETL architecture

SQL

Data integration

Education

Bachelor’s degree in computer science, engineering, or related field

Tools

AWS DMS

JAMS

Control‑M

Job description

InfoCepts is seeking an ETL Architect with deep Informatica expertise to lead an enterprise asset management modernization program for an energy client. The role focuses on redesigning Informatica pipelines, retrofitting middleware integrations, and enabling robust SaaS table replication while preserving operational reporting.

The candidate will own target-state integration architecture, define reusable patterns, and supervise the validation of inbound/outbound interfaces, ensuring continuity