Senior Data Migration Engineer | Cloud & Data Integrity

Whizdom; New South Wales; On-site; AUD 120,000 - 170,000; Full time

Job summary

Whizdom is seeking a Senior Data Migration Specialist / Engineer for a contract opportunity in Sydney, NSW. You will analyse source and target data, design migration approaches, and execute complex data migration initiatives within a state government transformation program.

You will collaborate with architects, developers, vendors and testers, lead data validation and reconciliation, and ensure data quality and integrity across Azure, AWS and SQL Server environments.

Qualifications

• Advanced SQL expertise with staging tables in SQL Server.
• Experience with Azure, AWS S3, and other data platforms.
• Track record delivering complex data migration projects.
• Experience with AWS-to-Azure migration programs.
• Strong understanding of relational databases and data structures.
• Experience with APIs and data transformation solutions.
• Excellent data quality, validation, and reconciliation skills.
• Understanding of data governance and security.

Responsibilities

• Analyse source and target datasets using SQL and investigate data anomalies.
• Develop and review source-to-target mapping documentation; define transformation rules.
• Support migration load development, execution, and test migrations; troubleshoot issues.
• Develop SQL-based validation and reconciliation processes; produce evidence of successful migration.
• Support testing cycles, dress rehearsals, cutover planning, and post-migration validation.

Skills

SQL

Azure

AWS S3

Data migration

Data transformation

Data governance

Stakeholder comms

SQL Server

Tools

AzCopy

Azure Data Factory

Azure Databricks

Job description

Whizdom is seeking a Senior Data Migration Specialist / Engineer for a contract opportunity in Sydney, NSW. You will analyse source and target data, design migration approaches, and execute complex data migration initiatives within a state government transformation program.

You will collaborate with architects, developers, vendors and testers, lead data validation and reconciliation, and ensure data quality and integrity across Azure, AWS and SQL Server environments.