Senior Informatica PowerCenter Migration Architect

9th Way Insignia

Washington (District of Columbia)

On-site

USD 98,000 - 120,000

Full time

12 days ago

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical

Dental

Vision

401(k)

Paid time off

Job summary

9th Way Insignia seeks a Senior Informatica PowerCenter Migration Engineer to lead the VA EDW migration from on-prem Oracle to OCI. You will assess, configure, migrate, validate, and optimize ETL workloads, ensuring data fidelity and performance across multiple environments.

The ideal candidate has 10+ years in ETL with Informatica PowerCenter, strong Oracle SQL, Unix scripting, and cloud migration experience, plus superior communication with technical and non-technical stakeholders.

Qualifications

10+ years hands-on Informatica PowerCenter ETL experience and migrations.
Bachelor’s degree in a technical field or 8 additional years of relevant experience.
Proven migration/upgrading of large-scale ETL platforms with testing & data validation.
Strong Oracle SQL/PLSQL and data discrepancy resolution skills.
Unix/Linux scripting and production ETL scheduling experience.

Responsibilities

Assess existing Informatica PowerCenter ETL workflows and dependencies.
Configure and support PowerCenter components in OCI cloud environment.
Plan and execute migration across dev, test, pre-prod, and production.
Validate migrated ETL streams to ensure source-to-target fidelity and no data loss.
Develop automated data reconciliation, control totals, and exception reporting.
Troubleshoot ETL failures, performance bottlenecks, and connectivity issues.
Optimize Informatica jobs for nightly loads; coordinate with DB, OCI, security teams.
Support cloud setup, provisioning, migration readiness, and rollback procedures.
Maintain ETL design docs, test plans, runbooks, and configuration artifacts.