ETL QA

HTC Global Services; Pune District; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

HTC Global Services is seeking an ETL QA with 8+ years of QA experience to evaluate systems and develop test processes ensuring reliability and maintainability of products. The role supports functional and automation testing of ETL processes, data warehouses, and Asset Management workflows.

Candidate should have extensive hands-on ETL testing, strong SQL validation skills, and experience leading testing efforts in an Agile environment within financial services.

Qualifications

• 8+ years of QA experience with ETL testing.
• Strong SQL-based data validation and database testing.
• Experience with Asset Management systems and related workflows is preferred.
• Experience working in Agile/Scrum environments in financial services.

Responsibilities

• Define test strategies for Automation, Regression and Smoke Testing.
• Effectively manage and lead a test team.
• Understand and implement testing processes.
• Prepare automation test plans.
• Deploy and manage test frameworks.
• Identify and communicate risks during planning and execution.
• Lead end-to-end testing tasks including scoping, estimation and test execution.
• Plan and coordinate test data and environments.
• Coordinate with project teams across US & India.
• Ensure test activities adhere to project requirements.
• Demonstrate strong communication and organizational skills; resolve issues with minimal disruption.
• Drive QA metrics and continuous improvement in QA space.
• Willing to work in shifts and provide weekend QA support as required.

Skills

ETL testing

SQL queries

Agile/Scrum

Data validation

Test planning

Team leadership

UAT support

Automation planning

Job description

Job Description

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.