ETL QA

Job Description

a text-decoration: none; color: #464feb; tr th, tr td border: 1px solid #e6e6e6; tr th background-color: #f5f5f5;

About The Role

We are seeking a ETL QA with 8+ years of experience as a QA Associate evaluates systems and develops test processes to improve the reliability and maintainability of products and applications. Working independently, this job supports the functional and automation testing of various systems, applications, and databases.

Requirements

• Extensive hands-on experience in ETL testing, including data extraction, transformation, and load validation across multiple database platforms and data warehouses.
• Strong expertise in database testing using SQL queries to validate data accuracy, integrity, referential integrity, and business rule implementation.
• Proven experience testing Asset Management systems, including portfolio management, trading platforms, investment accounting, and regulatory reporting applications.
• Deep understanding of Asset Management business processes, including securities processing, position reconciliation, NAV calculations, and performance attribution.
• Hands-on experience with data validation techniques, including source-to-target mapping verification, data quality checks, and reconciliation testing.
• Proficient in designing and executing test strategies for data migration projects and data warehouse implementations.
• Experience creating detailed test plans, test scenarios, and test cases based on business requirements and data specifications for ETL processes and Asset Management workflows.
• Prior experience working in Agile/Scrum methodology within Asset Management and financial services environments.
  
  

Key Responsibilities And Duties

• Define the test strategies for Automation, Regression and Smoke Testing.
• Effectively manage and lead a test team.
• Understand and implement the testing processes.
• Prepare automation test plans.
• Deploy and manage test frameworks.
• Identify and communicate risks during test planning and execution phases.
• Own (Lead) the end-to-end testing tasks like scoping, estimation, planning, work allocation, resource management, test design & execution, defect management, progress tracking & status reporting, management reporting, UAT support, test closure etc.
• Plan & coordinate for timely availability of the test data & environments
• Proactively communicate and collaborate with project teams, test teams and support partners across US & India
• Ensure that all test execution activities are conducted for projects per procedure / requirements.
• Self-starter, highly organized; Works well with all functional levels in the organization; excellent presentation and interpersonal skills; high level of business management and facilitation skill; capability to resolve complex problems with minimum confusion, frustration, and inconveniences for all parties concerned.
• Customer focused; Action-Oriented; Building Team Spirit; Self Development; Creativity & Innovation; Problem Solving; Ethics & Values
• Ability to handle multiple tasks and to work independently as well as in a team setting.
• Define and implement the QA metrics framework.
• Identify & drive the improvement opportunities in the QA space.
• Should be willing to work in shifts and provide QA support on weekend as per the project requirements.
  
  

Additional Skills

• Understanding on Asset Management business domain.