IT Application & Operations Manager

Pengiklan Anonim; Jakarta Utara; On-site; IDR 167,400,000 - 267,840,000; Full time

Job summary

Pengiklan Anonim is seeking an ETL QA tester to validate end-to-end data ingestion, transformation, and loading processes. You will verify source-to-target mappings, business rules, and data reconciliation across systems to ensure accuracy during data migrations.

You will execute SQL-based data validation across source, staging, and target layers, validate ETL jobs and schedules, and check error handling mechanisms.

Qualifications

• Experience in ETL / Data Testing.
• Proficiency in SQL with complex joins and reconciliations.
• Hands-on experience with ETL tools (Informatica, Talend, DataStage, or similar).
• Experience in Data Warehouse / Data Lake testing.
• Knowledge of data migration and reconciliation testing.
• Experience in automation frameworks for ETL testing (Python, shell scripts, or custom frameworks).

Responsibilities

• Perform ETL testing for data ingestion, transformation, and loading processes.
• Validate source-to-target mappings, business rules, and data reconciliation across systems.
• Execute data migration testing, including completeness, accuracy, and consistency checks.
• Perform SQL-based data validation across source, staging, and target layers.
• Validate ETL jobs, workflows, schedules, and error handling mechanisms.
• Design and execute ETL automation scripts for regression and sanity validation.
• Support API and integration data validation where applicable.
• Collaborate with development, data engineering, and business teams to resolve data defects.
• Prepare test cases, test execution reports, defect reports, and data validation summaries.
• Ensure adherence to QA governance, data quality standards, and audit requirements.

Skills

ETL / Data Testing

SQL

ETL tools

Data Warehouse / Data Lake testing

Data migration testing

Automation frameworks for ETL testing

Python

Shell scripting

Tools

Informatica

Talend

DataStage

Job description

Perform ETL testing for data ingestion, transformation, and loading processes.

Validate source-to-target mappings, business rules, and data reconciliation across systems.

Execute data migration testing, including completeness, accuracy, and consistency checks.

Perform SQL-based data validation across source, staging, and target layers.

Validate ETL jobs, workflows, schedules, and error handling mechanisms.

Design and execute ETL automation scripts for regression and sanity validation.

Support API and integration data validation where applicable.

Collaborate with development, data engineering, and business teams to resolve data defects.

Prepare test cases, test execution reports, defect reports, and data validation summaries.

Ensure adherence to QA governance, data quality standards, and audit requirements.

Technical Skills

• Strong experience in ETL / Data Testing
• Proficiency in SQL (complex joins, aggregations, reconciliation queries)
• Hands-on experience with ETL tools (Informatica, Talend, DataStage, or similar)
• Experience in Data Warehouse / Data Lake testing
• Knowledge of data migration and reconciliation testing
• Experience in automation frameworks for ETL testing (Python, shell scripts, or custom frameworks)