Senior Data Migration Lead: Oracle to PostgreSQL (Chicago/NY/ATL)

Capgemini; Atlanta (GA); On-site; USD 86,000 - 127,000; Full time

Benefits offered by this job

Benefits package

Career growth opportunities

Job summary

Capgemini in the United States is seeking a senior data migration professional to lead enterprise data migration programs to PostgreSQL on AWS. You will assess source environments including VSAM, DB2 and Oracle, define source‑to‑target mappings, and design migration architecture and execution strategies.

You will build and oversee ETL processes, validate data, ensure auditability and regulatory compliance, and coordinate with AWS, infrastructure, and business teams through migration cutovers.

Qualifications

• 10+ years of enterprise data migration experience.
• Strong expertise in Oracle Database, DB2 and PostgreSQL.
• Experience migrating large-scale datasets from Mainframe and Oracle to PostgreSQL.

Responsibilities

• Assess source data environments including DB2, VSAM, and Oracle.
• Define source-to-target mapping from Mainframe and Oracle to PostgreSQL.
• Design migration architecture and execution strategy.
• Build and oversee data extraction, transformation, and load processes.
• Implement automated reconciliation and validation frameworks.
• Migrate historical and active business data into AWS RDS PostgreSQL.
• Ensure data integrity, auditability, and regulatory compliance.
• Support testing, cutover, and production deployment activities.
• Mitigate migration risks and resolve data-related issues.
• Collaborate with AWS, infrastructure, application, and business teams throughout the migration lifecycle.

Skills

VSAM

DB2

Oracle

PostgreSQL

ETL

SQL

Data migration

Data reconciliation

AWS RDS

Data governance

Data lineage

Tools

AWS DMS

AWS SCT

Amazon S3

AWS Glue

AWS Lambda

CloudWatch

Informatica

Talend

DataStage

Job description

Capgemini in the United States is seeking a senior data migration professional to lead enterprise data migration programs to PostgreSQL on AWS. You will assess source environments including VSAM, DB2 and Oracle, define source‑to‑target mappings, and design migration architecture and execution strategies.

You will build and oversee ETL processes, validate data, ensure auditability and regulatory compliance, and coordinate with AWS, infrastructure, and business teams through migration cutovers.