SQL Transformation Engineer for AWS RDS Data Migration

Ovations Talent Sourcing; Johannesburg; On-site; ZAR 900,000 - 1,300,000; Full time

Job summary

Ovations Talent Sourcing is seeking a hands-on Database Engineer (SQL) for a 6–12 month contract in the consulting industry. The role will build and run the SQL transformation layer in AWS RDS for an enterprise legacy data migration project.

Responsibilities include writing and testing transformation scripts, performing data reconciliation, linking unstructured files to migrated records, and creating a reusable framework.

Qualifications

• Advanced SQL skills with experience in complex data transformations.
• Experience executing transformations inside AWS RDS and using S3 for staging.
• Experience with enterprise ETL or migration projects and data mapping.

Responsibilities

• Write, test, and execute transformation scripts in AWS RDS.
• Perform row-count checks and referential integrity validations.
• Link unstructured files to migrated records and support mapping.
• Develop a modular, reusable transformation framework.
• Document data lineage and transformation rules.
• Collaborate with system leads, IT teams, and vendors for signoffs.

Skills

Advanced SQL

Data Transformation

Data Reconciliation

Data Governance & Lineage

Stakeholder Collaboration

Tools

AWS RDS

AWS S3

Excel

Job description

Ovations Talent Sourcing is seeking a hands-on Database Engineer (SQL) for a 6–12 month contract in the consulting industry. The role will build and run the SQL transformation layer in AWS RDS for an enterprise legacy data migration project.

Responsibilities include writing and testing transformation scripts, performing data reconciliation, linking unstructured files to migrated records, and creating a reusable framework.