16 Nov
|
ALOIS Australia
|
Sydney
16 Nov
ALOIS Australia
Sydney
About Us:
ALOIS Australia is a leading Talent and Technology Solutions company, focused on helping businesses across the country build stronger teams, smarter processes, and sustainable growth.
We work with organisations in diverse industries to deliver integrated workforce and technology solutions, from innovative hiring strategies to end-to-end digital transformation. Our approach combines data, insight, and human expertise to help clients solve complex workforce challenges with clarity and confidence.
Through our deep industry experience and commitment to excellence, we provide scalable, high-performance solutions that deliver measurable impact. Whether it’s onshore project delivery, workforce optimisation, or specialised technology services, ALOIS Australia ensures results that truly make a difference.
From Sydney to Perth and everywhere in between, we’re driven by one purpose: to empower Australian businesses and professionals to thrive in a rapidly changing world of work. At ALOIS Australia, every challenge is an chance to innovate, and every partnership is built on trust, transparency, and long-term success.
Job Title – ETL Tester / Test Engineer
Job Location – Sydney
Experience – 5-7+ Years
Employment Type – Contract
Work Authorization: Applicants must have valid working/unlimited working rights in Australia. (Visa sponsorship or transfer is not available for this role)
Role Summary:
We are seeking a skilled ETL Tester to support a large-scale data modernization and analytics transformation initiative. The role will focus on validating data ingestion, transformation, migration, reconciliation, and reporting outputs across source and target platforms.
The ideal candidate should possess strong expertise in ETL Testing, SQL-based Data Validation, Data Warehouse Testing, Data Reconciliation, and Cloud Data Platform Testing. Experience in Telecom data domains and data migration programs will be highly advantageous.
The role involves working closely with Business Analysts, Data Engineers, Product Owners, and Business Users to ensure data accuracy, integrity, and quality throughout the migration lifecycle
Key Responsibilities:
ETL & Data Validation Testing
- Validate end-to-end ETL/ELT pipelines across source and target systems.
- Verify data extraction, transformation, and loading processes against defined business and technical requirements.
- Perform source-to-target data mapping validation.
- Validate transformation rules, aggregations, calculations, and business logic.
- Conduct row-level, column-level, and aggregate-level reconciliation testing.
Data Migration Testing
- Execute migration testing activities for Program Illuminate data products and reporting layers.
- Validate data completeness, consistency, accuracy, and integrity post migration.
- Support migration rehearsals, cutovers, and production validation activities.
- Perform historical data validation and migration reconciliation.
- Analyze and report migration defects and data quality issues.
Data Quality & Reconciliation
- Develop and execute SQL queries for data verification and reconciliation.
- Validate counts, balances, KPIs, dimensions, facts, and critical business metrics.
- Support data profiling and anomaly detection activities.
- Ensure compliance with data quality standards and governance controls.
Test Planning & Execution
- Prepare test scenarios, test cases, and test data.
- Execute System Integration Testing (SIT), Functional Testing, Regression Testing, End-to-End Testing,
and Data Migration Testing.
- Support User Acceptance Testing (UAT) activities and business validation.
- Coordinate defect triage meetings and ensure timely defect resolution.
- Produce test execution reports and sign-off documentation
Reporting & Analytics Validation
- Validate reporting datasets and business intelligence outputs.
- Verify KPI calculations and reporting accuracy.
- Conduct source-to-report reconciliation.
- Ensure reporting data aligns with business requirements and downstream consumption needs
Mandatory Skills:
Data Testing
- ETL Testing
- Data Warehouse Testing
- Data Migration Testing
- Source-to-Target Validation
- Data Reconciliation Testing
- Data Quality Validation
- Regression Testing
- SIT & UAT Support
Technical Skills
- Advanced SQL
- Database testing and validation
- Experience with Oracle, Teradata, SQL Server, PostgreSQL, Redshift, or similar platforms.
- Strong understanding of relational and dimensional data models.
- Experience analyzing large volumes of data.
Cloud & Modern Data Platforms
- Google Cloud Platform (GCP) (Preferred)
- Azure Data Factory
- ADLS Gen2
- AWS Data Services
- Redshift or Snowflake
- PySpark validation experience desirable
Test Management Tools
- Jira
- Azure DevOps
- Test execution and defect management tools
Stay Connected with us:
Learn more about ALOIS in Australia, visit our webpage ALOIS Australia
Follow us on LinkedIn and Instagram
EEO Statement:
ALOIS Australia is committed to fostering a diverse and inclusive workplace. We provide equal employment opportunities to all qualified applicants and do not discriminate on the basis of race, colour, religion, sex, age, national origin, disability, or any other characteristic protected under applicable laws. We value diversity and believe it strengthens our people, our culture, and the outcomes we deliver.
📌 ETL Tester (Sydney)
🏢 ALOIS Australia
📍 Sydney