Senior Informatica PowerCenter Migration Engineer
Core
Lead the migration of the VA Enterprise Data Warehouse (EDW) from an on-premises Oracle environment to Oracle Cloud Infrastructure (OCI), focusing on Informatica PowerCenter ETL workloads.
Role type
Senior Informatica PowerCenter Migration Engineer
Builds
Migrated ETL pipelines and validated data loads within the VA Enterprise Cloud environment
Domain
Government / Data Engineering / Cloud Migration
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Informatica PowerCenter administration, ETL migration, Oracle SQL/PL/SQL, Unix/Linux shell scripting, data reconciliation, cloud provisioning, performance tuning
Preferred skills
OCI implementation, Oracle Database 19c/RAC, Informatica Metadata Manager, Oracle GoldenGate, federal environment experience, OCI/Informatica certifications
Technologies
Informatica PowerCenter, Oracle Cloud Infrastructure (OCI), Oracle Database, Oracle GoldenGate, Unix/Linux
Responsibilities
Assess existing ETL workflows and dependencies; Configure and support Informatica components in OCI; Plan and execute migration across dev/test/UAT/production environments; Validate migrated ETL streams and data integrity; Develop automated data-reconciliation processes; Troubleshoot ETL failures and performance bottlenecks; Optimize Informatica jobs for nightly-load performance; Coordinate with database, cloud, and security teams; Support cloud setup, deployment, and rollback procedures; Maintain ETL design documentation and migration runbooks; Support defect tracking and change control.
Seniority
Senior, hands-on IC