ETL Test Engineer (City of Perth)

ETL Test Engineer (City of Perth)

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

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: etl test engineer (city of perth) / city of perth

Subscribe to this job alert:

Get the latest job offers by email for: etl test engineer (city of perth) / city of perth