Senior Data Test Engineer – ETL & Data Warehousing

Synechron; Auckland; On-site; NZD 120,000 - 160,000; Full time

Job summary

Synechron is seeking an experienced Data Test Engineer in Auckland, NZ, with strong knowledge of data warehousing, ETL processes, SQL, and data validation methodologies. The role involves designing and executing tests for data pipelines, validating data integrity, and collaborating with data engineers and stakeholders across cloud platforms.

The ideal candidate will have hands-on data testing experience, expertise in SCDs and data reconciliation, and a solid background in Agile/Scrum delivery

Qualifications

• Hands-on data testing and validation experience.
• Strong ETL and data warehousing knowledge.
• Familiar with SCDs, audit columns and data reconciliation.
• SQL proficiency with complex queries and validation checks.
• Experience with batch and real-time data pipelines.
• Exposure to Databricks, Snowflake, Azure or AWS.
• Understanding of data quality, defect management and testing methodologies.
• Strong analytical and problem-solving abilities.
• Experience in Agile/Scrum delivery in banking/financial services.

Responsibilities

• Design and execute test scenarios for data pipelines, ETL processes, and data warehouses.
• Validate data accuracy, completeness, consistency, and transformation logic.
• Perform source-to-target data validation and reconciliation.
• Test SCD Types 1 and 2, audit columns, incremental loads, and historical data.
• Develop and execute SQL queries for data testing and analysis.
• Identify, document and track data defects through resolution.
• Collaborate with data engineers, developers, business analysts and stakeholders.
• Support testing across modern data platforms and cloud-based pipelines.
• Prepare test cases, results, defect reports and validation documentation.

Skills

Data testing

Data validation

ETL processes

Data warehousing concepts

SQL queries

Analytical skills

Problem-solving

Agile Scrum

Batch and real-time data pipelines

Tools

Databricks

Snowflake

Azure

AWS

Job description

Synechron is seeking an experienced Data Test Engineer in Auckland, NZ, with strong knowledge of data warehousing, ETL processes, SQL, and data validation methodologies. The role involves designing and executing tests for data pipelines, validating data integrity, and collaborating with data engineers and stakeholders across cloud platforms.

The ideal candidate will have hands-on data testing experience, expertise in SCDs and data reconciliation, and a solid background in Agile/Scrum delivery