Data Test Analyst/ETL Test Analyst

Role-Data Tester Type-Contact roleLocation –Australia-Sydney
Key ResponsibilitiesPerform 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 & ExperienceStrong 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.Strong understanding of Data Warehousing concepts including:Star/Snowflake schemasFact and Dimension tablesData modelling conceptsData quality and validation techniquesExperience testing ETL/ELT pipelines and data integration processes.Experience working with at least one cloud data platform, such as:Azure Synapse Analytics / Azure Data FactorySnowflakeAWS Redshift / GlueGoogle BigQueryExperience 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.
Regards,Reshu SethRecruitment ConsultantRenaissance InfoSystemM: +61 478 487 026E: reshu@reninfo.com.auW: http://www.reninfo.com.au