Test Automation Engineer (Java & ETL Testing)

Position Overview : The department is responsible for development and maintenance of Risk and Finance applications used by worldwide users. Among others, it includes Credit Approval & Counterparty Risk IT. It also covers Front Office Applications, Credit Decision Processing tool, Global Authorization Repository system and Default History Data Base. The applications are all in-house developments.

Main responsibilities

As Functional QA:

Good knowledge in Risk area like Deals, Authorization, Guarantees, Risk Weighted Assets, etc.

Hands on experience on various Risk Reporting. Should have worked on data mapping and testing of such risk data.

Requirements gathering and analysis for ETL processes

handle the different integration test phases (planning, test functional coverage and adequacy with functional content) and manage regression test, integration test on functional test campaign.

Experience with MS SQL Server: writing queries, analyzing data, and supporting database design.

Ability to translate business needs into technical requirements for data extraction, transformation, and loading.

Data validation, quality assurance, and documentation of data flows

Experience with data mapping, process documentation, and user acceptance testing

Analyze and assess business functional specifications recommend amendments to maximize efficiency and improve business value.

Proficient in User Acceptance Testing (UAT), Functional & System Integration testing of banking and financial applications

Manage the change requests during the implementation stage in coordination with sponsors, project managers and technical teams

Ensure the daily follow up for the implementation of the solution with the developers and provide clarifications when necessary

Manage L3 support to ensure application stability and work closely with L1/L2 support team & business line on resolution in support issues.

As 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.

Qualifications and Profile

This position requires a minimum of 4-6 years' relevant experience in software testing.

Good understanding & working knowledge of Agile/Scrum

Other Professional Skills and Mindset

Knowledge in Risk

Practical knowledge of SQL language

Familiarity with SAP BI (Business Intelligence) tools and report analysis

Proficient in MS Office

Knowledge of project management and software development lifecycle would be a plus

Excellent analytical and organizational skills

Fast reacting and autonomous, with a problem solving orientation

Knowledge of scrum tools and agile process would be an added advantage

If interested, you can click on 'Apply here' or write an e-mail to [HIDDEN TEXT] with your updated resume.

NOTE: - Only shortlisted candidates will be contacted back.

Thanks & Regards

Deeksha Agarwal

EA Licence No.91C2918

Personnel Registration No. R26161520