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.
