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).
- Strong analytical and problem-solving skills with attention to data accuracy and quality.
Data Test Analyst/ETL Test Analyst employer: Renaissance InfoSystems
Renaissance InfoSystems is an exceptional employer located in the vibrant city of Sydney, offering a dynamic work culture that fosters collaboration and innovation. As a senior Data Fabric Architect, you will have access to extensive professional development opportunities, enabling you to grow your skills while working alongside talented teams on cutting-edge projects. The company's commitment to employee well-being and a supportive environment makes it a rewarding place to build a meaningful career.
