16 Nov
|
ALOIS UK
|
City of Perth
16 Nov
ALOIS UK
City of Perth
Experience: 5 -7 Years
Location: Sydney
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.
- Robust 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
________________________________________
Preferred Experience
- Telecommunications domain experience.
- Experience in large-scale data transformation or migration programs.
- Experience validating customer, billing, CRM, product, network, or marketing data domains.
- Exposure to ETL Testing Automation Frameworks.
- Working knowledge of Agile delivery methodology.
- Experience supporting cloud modernization programs.
📌 ETL Test Engineer (City of Perth)
🏢 ALOIS UK
📍 City of Perth