ETL Test Automation Engineer – Data Quality & Risk

SCIENTE INTERNATIONAL PTE. LTD.; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

SCIENTE INTERNATIONAL PTE. LTD. is seeking a test automation engineer with 4–6 years of experience in functional QA, test automation, ETL/data testing, and SQL, preferably within risk/finance banking applications.

The role requires hands-on experience with Java-based automation, SQL Server, and data validation across large datasets. The candidate will design and execute UAT and system integration tests, develop automated frameworks, and collaborate with cross-functional teams to ensure data

Qualifications

• 4–6 years of relevant software testing experience.
• Strong experience in functional QA, UAT, system integration, and regression testing.
• Strong SQL Server and advanced T-SQL skills.
• Hands-on ETL testing, data validation, reconciliation, and source-to-target testing.
• Strong Java-based test automation using JUnit/TestNG and Maven/Gradle.
• Experience testing Java/Spark-based data processing applications.
• Experience with data-driven test frameworks and large dataset validation.
• Knowledge of risk/finance applications and risk data such as deals, authorizations, guarantees, and RWA.
• Experience with data mapping, ETL requirements, and data quality validation.
• Good understanding of Agile/Scrum methodologies.

Responsibilities

• Analyze business and functional requirements and translate them into functional, integration, and automation test scenarios.
• Plan and execute UAT, functional, system integration, and regression testing for Risk and Finance applications.
• Perform ETL testing, source-to-target validation, data reconciliation, and large-volume data quality checks.
• Develop and maintain automated test frameworks using Java, JUnit/TestNG, and Maven/Gradle.
• Validate data using SQL, T-SQL, Spark SQL, and automated comparison utilities.
• Perform data mapping, data flow validation, and testing of risk reporting processes.
• Analyze ETL, Spark, and application logs to identify data and processing issues.
• Collaborate with developers, business users, project managers, and support teams to resolve defects and implementation issues.
• Manage change requests, provide functional clarifications, and ensure timely implementation of solutions.
• Support L3 application issues and work with L1/L2 teams and business users to maintain application stability.

Skills

Software testing

Functional QA

SQL Server

ETL testing

Java test automation

Data processing tests

Data mapping

Agile/Scrum

Tools

JUnit/TestNG

Maven/Gradle

Spark SQL

CI/CD tools

Job description

SCIENTE INTERNATIONAL PTE. LTD. is seeking a test automation engineer with 4–6 years of experience in functional QA, test automation, ETL/data testing, and SQL, preferably within risk/finance banking applications.

The role requires hands-on experience with Java-based automation, SQL Server, and data validation across large datasets. The candidate will design and execute UAT and system integration tests, develop automated frameworks, and collaborate with cross-functional teams to ensure data