Role-Data Tester

Type-Contact role

Location –Australia-Sydney

Key Responsibilities

- Perform end-to-end Data Warehouse testing, including ETL, data migration, data integration, and reporting validation.
- Develop and execute test plans, test cases, test scenarios, and test scripts based on business and technical requirements.
- Perform detailed SQL queries for data validation, reconciliation, and backend testing.
- Validate data transformation logic, source-to-target mappings, and data quality rules.
- Conduct testing across cloud data warehouse platforms such as Azure Synapse, Snowflake, AWS Redshift, Google BigQuery, or similar.
- Perform ETL testing to validate data extraction, transformation, and loading processes.
- Identify data discrepancies, investigate root causes, and work closely with Data Engineers and Business Analysts for resolution.
- Execute regression, integration, system, and performance testing for data solutions.
- Validate BI reports and dashboards against warehouse data.
- Participate in Agile/Scrum ceremonies including sprint planning, stand-ups, reviews, and retrospectives.




- Create and maintain test documentation, defect reports, and test execution reports.

Mandatory Skills & Experience

- Strong experience as a Data Warehouse Test Analyst / ETL Test Analyst / BI Test Analyst.
- Hands-on experience with SQL including complex queries, joins, aggregations, and data reconciliation.
- Star/Snowflake schemas
- Fact and Dimension tables
- Data modelling concepts
- Data quality and validation techniques
- Experience testing ETL/ELT pipelines and data integration processes.
- Experience working with at least one cloud data platform, such as:
- Azure Synapse Analytics / Azure Data Factory
- Snowflake
- AWS Redshift / Glue
- Google BigQuery
- Experience with test management and defect tracking tools (JIRA, Azure DevOps, HP ALM, or similar).
- Robust analytical and problem-solving skills with attention to data accuracy and quality.

Regards,

Reshu Seth

Recruitment Consultant

Renaissance InfoSystem

M: 61 478 487 ***

E: email_hidden

W: http://www.reninfo.com.au

📌 Data Test Analyst/ETL Test Analyst (Sydney)
🏢 Renaissance InfoSystems
📍 Sydney