Job Summary

We are looking for an experienced Azure Data Test Engineer with robust expertise in Databricks, Azure Data Factory (ADF), and SQL. The ideal candidate should have hands-on experience in data migration, ETL/ELT testing, data reconciliation, and cloud-based data analytics projects. You will be responsible for validating data pipelines, ensuring data integrity, and supporting enterprise-scale Azure data platform implementations.

Key Responsibilities

- Design, develop, and execute test cases for ETL/ELT data migration projects.

- Automate ETL validation by writing complex SQL scripts using Databricks and QuerySurge.

- Perform technical and business data reconciliation between source and target systems.

- Validate Change Data Capture (CDC), event-driven processing, and data transformation logic.

- Perform data integrity, completeness, and accuracy validation across multiple data sources.

- Execute database testing involving structured, semi-structured, XML,



and flat-file data.

- Raise, track, and resolve defects throughout the testing lifecycle.

Required Skills

- Hands-on experience with Databricks

- Strong knowledge of Azure Data Factory (ADF)

- Advanced SQL scripting and query optimization

- ETL/ELT Testing

- Database Testing

- Data Migration Testing

- Data Reconciliation

- Data Integrity Validation

- Change Data Capture (CDC)

- Azure Data Platform

Required Experience

- Minimum 6+ years of experience in Data Testing or Database Testing.

- Experience validating ETL/ELT data pipelines.

- Strong experience in SQL for validating data from databases, files, and XML.

- Hands-on experience with Databricks.

- Experience working on Azure cloud-based data and analytics projects.

- Experience with Agile/Scrum methodologies.

📌 Azure Data Test Engineer (Sydney)
🏢 Ampstek
📍 Sydney