Quality Assurance Engineer III

Jobtailor; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Jobtailor is seeking a data QA engineer to execute ETL and data warehouse testing for analytics pipelines. You will perform data analysis, validation, and reconciliation across source and target systems, and write complex SQL queries to validate transformations against business rules.

The role requires hands-on GCP/BigQuery experience and Python-based test automation to streamline repetitive data validation tasks.

Qualifications

• Strong understanding of ETL processes, data warehousing concepts, and relational databases.
• Experience in data analysis and data testing within analytics or reporting environments.
• Proficiency in writing complex SQL queries for data validation and troubleshooting.
• Hands-on experience with GCP and BigQuery.

Responsibilities

• Execute ETL and data warehouse testing for data pipelines and analytics solutions.
• Perform data analysis, reconciliation, and validation testing across source and target systems.
• Write and execute complex SQL queries to validate data transformations based on business rules.
• Prepare and maintain test strategies, test plans, test cases, and related QA documentation.
• Validate data for accuracy, completeness, consistency, and timeliness.
• Identify, log, and track defects, and actively participate in defect triage discussions with development and data engineering teams.
• Develop and maintain Python automation scripts for repetitive data validation and regression testing.
• Execute data validation and testing on Google Cloud Platform, with a strong focus on BigQuery datasets.
• Understand business requirements and translate them into effective data test scenarios.
• Communicate test progress, defects, and data quality risks clearly to stakeholders and project teams.
• Support UAT, production validations, and post-release data verification when required.

Skills

ETL

Data warehousing

SQL

Data analysis

Data validation

Python

Test automation

Data quality checks

Defect tracking

Reconciliation testing

Tools

JIRA

BigQuery

Google Cloud Platform

Job description

Responsibilities

• Execute ETL and data warehouse testing for data pipelines and analytics solutions.
• Perform data analysis, reconciliation, and validation testing across source and target systems.
• Write and execute complex SQL queries to validate data transformations based on business rules.
• Prepare and maintain test strategies, test plans, test cases, and related QA documentation.
• Validate data for accuracy, completeness, consistency, and timeliness.
• Identify, log, and track defects, and actively participate in defect triage discussions with development and data engineering teams.
• Develop and maintain Python automation scripts for repetitive data validation and regression testing.
• Execute data validation and testing on Google Cloud Platform, with a strong focus on BigQuery datasets.
• Understand business requirements and translate them into effective data test scenarios.
• Communicate test progress, defects, and data quality risks clearly to stakeholders and project teams.
• Support UAT, production validations, and post-release data verification when required.

Requirements

• Strong understanding of ETL processes, data warehousing concepts, and relational databases.
• Experience in data analysis and data testing within analytics or reporting environments.
• Proficiency in writing complex SQL queries for data validation and troubleshooting.
• Hands‑on experience with Google Cloud Platform (GCP) and BigQuery.
• Working knowledge of Python for test automation and data validation.
• Experience using defect tracking tools (e.g., JIRA or similar).
• Experience creating test strategies, test cases, test scenarios, and supporting documents.
• Good understanding of data quality checks and ETL testing types such as source-to-target, transformation, and reconciliation testing.

Hard Skills

• ETL
• data warehousing
• SQL
• data analysis
• data validation
• Python
• test automation
• data quality checks
• defect tracking
• reconciliation testing

Soft Skills

• communication
• collaboration
• problem-solving
• attention to detail
• stakeholder management