Senior Informatica PowerCenter Migration Engineer – OCI Cloud

9th Way Insignia

Washington

On-site

USD 98,000 - 120,000

Full time

4 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k)

Paid time off

Telehealth

Holidays

FSA

HSA

Job summary

9th Way Insignia seeks a Senior Informatica PowerCenter Migration Engineer to lead migration of the VA Enterprise Data Warehouse to Oracle Cloud Infrastructure. You will assess, configure, migrate, validate, and optimize ETL workloads critical to a government data warehouse, partnering with Oracle, GoldenGate, and EDW teams to ensure secure, reliable data movement.

The role requires hands-on expertise in Informatica PowerCenter, Oracle SQL/PLSQL, and OCI, with a strong emphasis on data

Qualifications

Minimum 10 years hands-on Informatica PowerCenter ETL experience.
Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Data Engineering, Mathematics, or related technical discipline; 8 years may substitute.
Experience migrating or upgrading a large-scale ETL platform with data validation.
Strong Oracle SQL and PL/SQL skills and ability to resolve data discrepancies.
Experience with Unix/Linux scripting and production ETL scheduling.
Proven ability to work with technical and non-technical stakeholders and obtain VA suitability.

Responsibilities

Assess existing Informatica PowerCenter ETL workflows, repositories, dependencies, source-to-target mappings, schedules, parameter files, and procedures.
Configure and support Informatica PowerCenter components in the OCI cloud environment.
Plan and execute migration of Informatica ETL processes across development, test, pre-production/UAT, and production environments.
Validate migrated ETL streams to confirm source-to-target requirements are fulfilled and data is not lost during the load.
Develop and execute automated data-reconciliation processes, including counts, totals, comparisons, exceptions, and validation.
Troubleshoot ETL failures, data discrepancies, performance bottlenecks, and connectivity issues.
Tune Informatica jobs to improve nightly-load performance and meet processing requirements.
Coordinate with Oracle, GoldenGate, cloud, security, and EDW teams on dependencies and cutover readiness.
Support cloud setup, provisioning, migration readiness, deployment, rollback, and post-implementation activities.
Maintain ETL design docs, test plans, migration runbooks, restart procedures, and CM artifacts.
Support defect tracking, root-cause analysis, and change control.