ETL QA

HTC Global; Pune District; Híbrido; INR 800 000 - 1 200 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Hybrid and Workplace flexibility

Work-Life-Balance

Well-defined career development plan

Rewards & Recognition program

L&D focuses on upskilling

Hands-on with Emerging Technologies

Career Mobility programs

Resumo da oferta

HTC Global Services in Pune (MH) seeks an ETL QA lead with 8+ years of experience to evaluate systems and improve test processes. You will work independently to support functional and automation testing of data-heavy applications and data warehouses, ensuring data quality and regulatory compliance.

You will define test strategies for automation, regression and performance, manage a testing team, create detailed plans and test cases, and drive QA metrics.

Qualificações

• Extensive hands-on experience in ETL testing across multiple DB platforms and data warehouses.
• Strong expertise in database testing using SQL to validate data accuracy and business rules.
• Proven experience testing Asset Management systems and related workflows.
• Deep understanding of securities processing, NAV calculations and performance attribution.

Responsabilidades

• Define test strategies for Automation, Regression, and Smoke Testing.
• Effectively manage and lead a test team.
• Prepare automation test plans and deploy test frameworks.
• Coordinate for timely availability of test data and environments.
• Communicate risks during test planning and execution.

Conhecimentos

ETL Testing

SQL Queries

Asset Management

Data Validation

Data Warehousing

Agile/Scrum

Test Planning

Automation Testing

Descrição da oferta de emprego

Location: Pune (MH) | Employment Type: Full Time - 40 hours per week | Job Level: T5 | Work Preference: Onsite at work location address | Job Code: 245797

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.

At HTC Global Services, our culture is an embodiment of who we are – a value-led organizationcommitted to success of our people and customers.

• Hybrid and Workplace flexibility
• Work-Life-Balance
• Well-defined career development plan
• Rewards & Recognition program
• L&D focuses on upskilling
• Hands-on experience on Emerging Technologies and Digital Transformation
• Career Mobility programs