Senior ETL Test Engineer – Data Quality Lead

Hydrogen Group; Sydney; On-site; AUD 120,000 - 150,000; Full time

Job summary

Hydrogen Group in Sydney is seeking an experienced ETL Tester to join our technology and data team. You will ensure the accuracy, completeness, and reliability of data as it moves between source systems, data warehouses, and downstream applications.

The role emphasizes ETL/data warehouse testing in regulated environments, with responsibilities spanning test strategy, data validation, SQL scripting, and collaboration with developers, analysts, and stakeholders.

Qualifications

• 4+ years of ETL/data warehouse/data quality testing experience.
• Strong SQL skills with complex joins, aggregations, subqueries.
• Experience with ETL/ELT concepts and data warehouse architectures.

Responsibilities

• Develop and execute test strategies, plans, test cases, and test scripts for ETL and data migration projects.
• Validate data extraction, transformation, and loading processes across multiple source and target systems.
• Perform source-to-target data validation, reconciliation, completeness, and integrity testing.
• Validate complex data transformations, business rules, calculations, and data mappings.
• Conduct functional, regression, integration, system, and data quality testing.
• Write and execute complex SQL queries to validate data across databases and data warehouse environments.
• Identify, investigate, document, and track data defects through to resolution.
• Work closely with developers, data engineers, business analysts, and stakeholders to understand requirements and resolve data issues.
• Validate financial calculations, transactions, balances, reporting data, and other critical datasets where applicable.
• Support testing across data warehouses, data lakes, APIs, batch processes, and downstream reporting platforms.
• Contribute to test automation and continuous improvement of data testing practices.
• Ensure testing activities align with financial services regulatory, governance, security, and audit requirements.

Skills

SQL

ETL testing

Data warehouse testing

Data quality testing

Agile/Scrum

Tools

Informatica

Talend

SSIS

Databricks

Azure Data Factory

Job description

Hydrogen Group in Sydney is seeking an experienced ETL Tester to join our technology and data team. You will ensure the accuracy, completeness, and reliability of data as it moves between source systems, data warehouses, and downstream applications.

The role emphasizes ETL/data warehouse testing in regulated environments, with responsibilities spanning test strategy, data validation, SQL scripting, and collaboration with developers, analysts, and stakeholders.