- We are seeking a skilled ETL Tester(5-8 years) 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 solid 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.
- Validate transformation rules, aggregations, calculations, and business logic.
- Conduct row-level, column-level, and aggregate-level reconciliation testing.

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

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

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

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.

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.

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.

Test Management Tools

Jira Azure DevOps Test execution and defect management tools

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.

#J-18808-Ljbffr

📌 Senior ETL Developer (New South Wales)
🏢 Renaissance Infosystems Pte
📍 New South Wales