ETL QA Engineer

• *Location:** Hyderabad
• *Work Mode**: Hybrid – 3 Days Work From Office per Week
• *Experience**: 5\+ Years
• *Notice Period**: Immediate Joiners Preferred

• *About P99Soft**

P99Soft is a technology and digital engineering company delivering innovative software solutions across cloud, data, AI, and modern application engineering. We are looking for an experienced **ETL QA Engineer** who can ensure the quality, reliability, and accuracy of data pipelines and analytics solutions while leveraging automation and emerging AI/GenAI tools to improve testing efficiency.

• *About the Role**

We are looking for a **ETL QA Engineer** with 5\+ years of experience in **ETL/Data Warehouse testing, SQL, and test automation**. The ideal candidate should have strong expertise in validating data pipelines, transformations, data quality, and end\-to\-end ETL workflows.

The candidate should also have an understanding of **GenAI, AI\-assisted testing, and modern AI tools**, and be comfortable exploring how AI can be used to improve test case generation, data validation, automation, defect analysis, and overall QA productivity.

• *Key Responsibilities**

\* Design and execute test strategies for **ETL pipelines, data warehouses, and data integration workflows**.

\* Validate data extraction, transformation, and loading processes across multiple data sources and target systems.

\* Perform **source\-to\-target validation**, data reconciliation, transformation testing, and data quality checks.

\* Write complex **SQL queries** to validate data accuracy, completeness, consistency, and integrity.

\* Develop and maintain **automated test scripts/frameworks** for ETL and data validation.

\* Identify opportunities to automate repetitive data validation and regression testing activities.

\* Perform functional, integration, regression, and end\-to\-end testing of data pipelines.

\* Validate data transformations, business rules, mappings, joins, aggregations, and calculated fields.

\* Analyze defects, perform root\-cause analysis, and work closely with developers, data engineers, and business teams to resolve issues.

\* Validate data across databases, APIs, files, and cloud\-based data platforms.

\* Participate in test planning, estimation, test case design, execution, and reporting.

\* Contribute to improving QA processes, automation coverage, and overall testing efficiency.

\* Explore and utilize **GenAI/AI** tools for test case generation, test data creation, SQL assistance, defect analysis, documentation, and automation.

\* Stay updated with emerging **AI\-assisted QA and testing practices** and identify opportunities to integrate them into the QA lifecycle.

• *Required Skills \& Experience**

\* **5\+ years of experience** in ETL/Data Warehouse Testing or Data QA.

\* Strong hands\-on experience with **ETL testing concepts and methodologies**.

\* Strong proficiency in **SQL** and database testing.

\* Experience with data validation, reconciliation, transformation testing, and data quality testing.

\* Good understanding of **Data Warehousing concepts**, including fact/dimension tables, ETL workflows, joins, aggregations, and data models.

\* Experience with **test automation** using tools/frameworks such as Python, Selenium, PyTest, or similar automation technologies.

\* Experience in automating data validation and regression test scenarios.

\* Experience working with databases such as **SQL Server, PostgreSQL, MySQL, Oracle**, or similar.

\* Exposure to cloud/data platforms such as **AWS, Azure, Snowflake, Databricks**, or similar is preferred.

\* Good understanding of QA processes, defect management, and Agile methodologies.

\* Hands\-on experience with **GenAI/AI tools** such as ChatGPT, Claude, Gemini, GitHub Copilot, or similar AI\-assisted development/testing tools.

\* Ability to use AI tools effectively for **test design, SQL generation/optimization, automation assistance, test data generation, and defect analysis.**

• *Good to Have**

\* Experience testing **cloud\-based ETL/data pipelines**.

\* Exposure to **Snowflake, Databricks, AWS, Azure, or GCP**.

\* Experience with ETL tools such as **Informatica, Talend, SSIS, dbt, or similar**.

\* Knowledge of **Python\-based data testing/automation**.

\* Exposure to **CI/CD pipelines and DevOps practices**.

\* Exposure to **LLMs, RAG, AI agents, or AI\-based testing solutions**.

\* Experience integrating AI tools into QA workflows or building AI\-assisted testing utilities.

Pay: ₹2,000,000\.00 \- ₹2,400,000\.00 per year

Work Location: Hybrid remote in Hyderabad, Telangana