Sr ETL QA Analyst

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

Job summary

HTC Global Services is seeking a highly skilled Sr ETL QA Tester in Chennai with 7+ years of experience to join our team. The role emphasizes ETL testing, SQL proficiency, and data quality assurance within data warehousing environments.

The ideal candidate will design and execute test plans, validate data across multiple sources, and collaborate with data engineers and stakeholders to ensure comprehensive testing coverage while maintaining high data integrity and process reliability.

Qualifications

• 7+ years of experience in ETL testing or a similar QA role.
• Strong proficiency in SQL and experience with query optimization.
• Hands-on experience with database management systems (Oracle & Snowflake).
• Autosys job scheduling and Python scripting.
• Solid understanding of data warehousing concepts, architectures and ETL processes.
• Experience with data validation frameworks and data quality tools.
• Excellent attention to detail and organizational skills.
• Ability to work independently and collaboratively in a fast-paced environment.
• Familiarity with QA tools like HP ALM, JIRA, TestRail, or similar.

Responsibilities

• Design, develop, and execute test plans and test cases for ETL processes.
• Validate data extraction, transformation, and loading workflows across multiple data sources and targets.
• Perform data quality checks and ensure data integrity across systems.
• Write complex SQL queries to validate data and troubleshoot issues.
• Collaborate with data engineers, analysts, and business stakeholders to understand requirements and ensure accurate testing coverage.
• Identify, document, and track defects using appropriate tools.
• Optimize SQL queries for performance and accuracy.

Skills

ETL testing

SQL

Data validation

QA processes

Data warehousing

Tools

Oracle

Snowflake

Autosys

Python scripting

HP ALM

JIRA

TestRail

Job description

About the Role

We are seeking a highly skilled and detail-oriented Sr ETL QA Tester with over 7+ years of experience to join our team. The ideal candidate will have a strong background in ETL testing, SQL, data validation, and quality assurance processes, with a deep understanding of data warehousing and transformation concepts.

Responsibilities

• Design, develop, and execute test plans and test cases for ETL processes.
• Validate data extraction, transformation, and loading workflows across multiple data sources and targets.
• Perform data quality checks and ensure data integrity across systems.
• Write complex SQL queries to validate data and troubleshoot issues.
• Collaborate with data engineers, analysts, and business stakeholders to understand requirements and ensure accurate testing coverage.
• Identify, document, and track defects using appropriate tools.
• Optimize SQL queries for performance and accuracy.

Required Skills & Qualifications

• Minimum 7+ years of experience in ETL testing or a similar QA role.
• Strong proficiency in SQL and experience with query optimization.
• Hands-on experience with database management systems (Oracle & Snowflake)
• Autosys job scheduling, Python Scripting
• Solid understanding of data warehousing concepts, architectures, and ETL processes.
• Experience with data validation frameworks and data quality tools.
• Excellent attention to detail and organizational skills.
• Ability to work independently and collaboratively in a fast-paced environment.
• Familiarity with QA tools like HP ALM, JIRA, TestRail, or similar.

Good to have

• Exposure to automation frameworks and scripting languages (e.g., Python)
• Exposure to AI tools relevant to QA