Data Automation Engineer / Functional Tester

APAR TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 80,000 - 120,000; Full time

Job summary

AparTechnologies Pte Ltd is seeking a Data Automation Engineer in Singapore to drive testing across ETL pipelines and data processing jobs. You will leverage Java and Spark-based tooling, build robust automated tests, and collaborate with CI/CD workflows to ensure data quality and reliability.

You will validate large datasets with SQL, Spark SQL, and Python scripting, while supporting batch loads, regression checks, and production-like test environments.

Qualifications

• Experience in ETL testing, data validation and data reconciliation.
• Hands-on with Java-based test automation and Spark-driven data processing.
• Familiar with CI/CD pipelines and automated test reporting.
• Ability to analyze ETL logs and optimize SQL Server performance.

Skills

ETL testing

Data validation

Data reconciliation

Source-to-target testing

Data quality checks

Regression testing

CI/CD practices

Test data management

Tools

MS SQL Server

T-SQL

Java

JUnit/TestNG

Maven/Gradle

Spark

Jenkins

GitLab CI

Azure DevOps

GitHub Actions

PowerShell

Bash

Python

Spark SQL

Job description

Data Automation Engineer:

• Strong experience in ETL testing, data validation, data reconciliation, and source-to-target testing.
• Strong hands-on experience with MS SQL Server and advanced T-SQL.
• Experience testing Java/Spark-based data processing applications.
• Hands-on automation experience using Java, JUnit/TestNG, Maven/Gradle, and data-driven test frameworks.
• Ability to validate large datasets using SQL, Spark SQL, and automated comparison utilities.
• Experience with batch processing, incremental loads, data quality checks, and regression testing.
• Familiarity with CI/CD tools such as Jenkins, GitLab CI, Azure DevOps, or GitHub Actions.
• Experience with Git, scripting using PowerShell/Bash/Python, and automated test reporting.
• Ability to analyze ETL logs, Spark job logs, and SQL Server performance issues.
• Knowledge of file formats such as CSV, JSON, XML, Parquet, Avro, and fixed-width files.
• Good understanding of test data management, data masking, and production-like test data setup.

EALicense No: 11C4879 / Registration ID : R1218583

AparTechnologies Pte Ltd, Singapore