Memuat...
Tata Consultancy Services

Junior ETL Testing & Automation Engineer

Staff
  • Tata Consultancy Services
  • Kota Jakarta Selatan
  • 1 minggu dari sekarang

Deskripsi Pekerjaan

Role Summary

Support ETL and data-quality testing activities by validating data movement, transformation rules and reconciliation results across source, staging and target systems. The role works under the guidance of senior QA and data engineering team members and is suitable for fresh graduates with strong SQL fundamentals and an interest in data testing automation.


Must-Have Skills

• Good understanding of relational databases, SQL fundamentals, joins, aggregations, subqueries and data comparison techniques

• Basic understanding of ETL concepts, including data extraction, transformation, loading, staging tables and source-to-target mapping

• Ability to validate data completeness, accuracy, consistency, duplicates, null values and business-rule compliance

• Basic programming or scripting knowledge in Python, Bash, PowerShell or a comparable language

• Understanding of software testing fundamentals, test cases, expected results, defect lifecycle and regression testing

• Good analytical thinking, attention to detail, documentation and communication skills


Good-to-Have Skills

• Academic, internship or project exposure to Informatica, Talend, IBM DataStage, Apache Airflow, Azure Data Factory or similar ETL/orchestration tools

• Exposure to data warehouses, data lakes, star schemas, fact tables and dimension tables

• Basic knowledge of Google Cloud Platform and BigQuery, Microsoft Azure, AWS or another cloud data platform

• Familiarity with API testing using Postman and basic JSON validation

• Exposure to pytest, pandas, Robot Framework or custom Python-based data-validation scripts

• Familiarity with Jira, Azure DevOps or a similar defect and work-tracking tool

• Awareness of Agile/Scrum delivery and CI/CD concepts


Key Responsibilities

• Review requirements, source-to-target mappings and transformation rules with senior team members

• Prepare and execute test cases for data ingestion, transformation, loading and reconciliation processes

• Use SQL to compare record counts, field values, aggregates and business-rule results across source, staging and target layers

• Validate data completeness, accuracy, consistency, duplicate handling, null handling and rejected-record processing

• Perform basic testing of ETL jobs, workflows, schedules, dependencies and error-handling mechanisms

• Develop and maintain simple Python or scripting-based checks for repetitive regression and sanity validations

• Log defects with clear evidence, expected and actual results, sample records and reproducible steps

• Retest fixes and support regression testing before release or data-migration cutover

• Assist with API and integration-data validation where required

• Prepare test execution updates, defect summaries and data-validation reports

• Follow QA governance, data-security requirements and approved data-handling procedures


Education and Candidate Profile

• Bachelor's degree or final-semester student in Computer Science, Information Technology, Information Systems, Data Engineering, Statistics, Mathematics or a related discipline

• Fresh graduates are eligible; internship, bootcamp, certification, final project or portfolio work involving SQL, databases, ETL or data analytics is an advantage

• Candidates should be able to demonstrate SQL capability through coursework, projects or a technical assessment

• Willingness to learn enterprise ETL tools, testing frameworks, cloud data platforms and industry-specific data domains

• Ability to collaborate with QA, developers, data engineers and business analysts in a structured delivery environment


Suggested Entry-Level Screening Criteria

• SQL assessment covering joins, GROUP BY, CASE expressions, duplicate detection, null checks and record reconciliation

• Practical exercise comparing two small datasets and documenting mismatches and possible causes

• Basic Python task using pandas or standard data structures to validate row counts, mandatory fields or duplicate records

• Behavioural assessment focused on attention to detail, structured problem-solving and communication of data issues


Required Technical Skill Set : SQL, ETL/data testing, source-to-target validation, data reconciliation, basic Python or scripting, test documentation and defect management