Role: Quality Assurance Engineer III (ETL Test Engineer) Location: Chennai, Tamilnadu
Why Pearson?
At Pearson, you’ll join a mission-driven team dedicated to helping people make progress in their lives through learning. We value curiosity, collaboration, and innovation—empowering every employee to make a real impact. If you’re passionate about education and growth, Pearson is the place to thrive.
Job Summary
We are looking for a skilled Data Quality / ETL Test Engineer (Individual Contributor) to support data integration, analytics, and reporting initiatives. The ideal candidate will have a strong foundation in ETL concepts, database and SQL skills, data analysis, and testing, with hands‑on experience in Google Cloud Platform (GCP) and BigQuery . This role involves close collaboration with data engineers, business analysts, and stakeholders to ensure high‑quality and reliable data solutions.
Key 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.
Required Skills & Qualifications
Technical Skills
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).
Testing & Documentation
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.
Ability to validate business rules and logic through structured testing approaches.
Communication & Collaboration
Strong written and verbal communication skills .
Ability to interact regularly with stakeholders to clarify requirements and provide quality updates.
Good analytical, problem‑solving, and attention‑to‑detail skills.
Ability to work independently as an individual contributor within a collaborative team environment.
Good to Have
Exposure to Agile/Scrum delivery models.
Experience with data orchestration or modeling tools (e.g., dbt, Airflow).
Familiarity with CI/CD concepts for data or test automation.
Experience working in enterprise‑scale data platforms or cloud environments.
#LI-AK1
Who we are:
At Pearson, our purpose is simple: to help people realize the life they imagine through learning. We believe that every learning opportunity is a chance for a personal breakthrough. We are the world's lifelong learning company. For us, learning isn't just what we do. It's who we are. To learn more: We are Pearson.
Pearson is an Equal Opportunity Employer and a member of E-Verify. Employment decisions are based on qualifications, merit and business need. Qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, sexual orientation, gender identity, gender expression, age, national origin, protected veteran status, disability status or any other group protected by law. We actively seek qualified candidates who are protected veterans and individuals with disabilities as defined under VEVRAA and Section 503 of the Rehabilitation Act.
If you are an individual with a disability and are unable or limited in your ability to use or access our career site as a result of your disability, you may request reasonable accommodations by emailing [email protected].
Job: Data Engineering
Job Family: TECHNOLOGY
Organization: OCTO
Schedule: FULL_TIME
Workplace Type: Hybrid
Req ID: 24705
