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 [email protected] with your updated resume.

NOTE: - Only shortlisted candidates will be contacted back.

Thanks & Regards

Deeksha Agarwal

EA Licence No.91C2918

Personnel Registration No. R26161520