Test Automation Engineer

Job Description: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.Requirements: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 Management.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.