EduAtlas

Quality Assurance Engineer III– ETL & Data Test Automation

at Pearson, Chennai, India

Posted this week

Apply

Job Description: Quality Assurance Engineer III– ETL & Data Test Automation

Role Overview

We are looking for a hands-on Quality Engineering Engineer with strong expertise in ETL/Data Testing Automation and working knowledge of API Automation . The primary responsibility is to build scalable automated validation solutions for data pipelines, data transformations, and cloud-based data platforms.

Key Responsibilities

• Design, develop, and maintain Python and SQL-based ETL/Data Testing Automation frameworks .

• Automate source-to-target validation across complex ETL/ELT data pipelines.

• Validate data across Bronze/Raw, Silver/Curated, and Gold/Consumption layers .

Read the full advert

• ETL & Data Validation: Validate source-to-target data, transformations, schema, record counts, nulls, duplicates, and business rules using Big Query and SQL .

• Automation: Develop Python/dbt-based automation for ETL validation, data-quality checks, regression testing, and automated test reporting.

• GCP: Validate end-to-end data pipelines across Big Query, GCS, Dataflow, Pub/Sub, and Cloud Composer , including full and incremental data loads.

• Build reusable automation for:

• Source-to-target reconciliation

• Row-count and aggregate validation

• Schema and data-type validation

• Null, duplicate, and mandatory-field checks

• Data completeness and integrity checks

• Transformation and business-rule validation

• Incremental, delta, and historical load validation

• Data freshness and pipeline validation

• Develop solutions for validating high-volume datasets using Python, SQL, Pandas, and cloud data platforms.

• Perform complex SQL validation and troubleshoot data discrepancies across source and target systems.

• Validate structured and semi-structured data, including JSON and nested datasets .

• Develop reusable, configuration-driven or metadata-driven automation components to reduce manual testing.

• Integrate automated ETL/data-quality test suites with CI/CD pipelines such as Jenkins, Git Hub Actions, or Azure Dev Ops.

• Perform defect investigation and root-cause analysis by collaborating with developers, data engineers, and business teams.

• Maintain automation code using Git/Git Hub , including appropriate branching and pull-request practices.

• Support API validation as a secondary responsibility , including REST API request/response, status code, JSON payload, authentication, schema, and basic integration validation.

• Develop and maintain basic API automation using Python Requests/Pytest, Postman/Newman, or REST Assured when required.

• Contribute to test strategy, regression coverage, release readiness, and overall quality engineering practices.

Details

Type of post
IT and technicians
A support post, not a teaching post.
First seen
16 November 2026, on a public job listing
Apply on
hccz.fa.em3.oraclecloud.com
Listed by
EduAtlas: live education jobs from employers’ own careers pages and public job services.

More vacancies in India