The Role
Senior QA professional responsible for designing and executing ETL and data validation strategies, validating data pipelines and transformations, performing source-to-target reconciliation, investigating data quality issues, and developing automated data testing frameworks. The role requires advanced SQL, data warehousing knowledge, defect tracking, and collaboration with data engineers and business stakeholders. Experience with Azure Data Factory, Talend, Informatica, SSIS, cloud data platforms, CI/CD, and Agile methodologies is advantageous.
Summary Generated by Built In
We are seeking a highly skilled Senior QA Engineer with strong expertise in ETL Testing, Data Validation, and Data Warehousing to ensure the accuracy, integrity, and quality of enterprise data platforms.
The ideal candidate will have extensive experience validating complex data pipelines, performing source-to-target reconciliation, and developing automated data testing solutions
The ideal candidate will have extensive experience validating complex data pipelines, performing source-to-target reconciliation, and developing automated data testing solutions
Key Responsibilities
· Design, execute, and maintain comprehensive ETL and data validation test strategies.
· Validate data pipelines, transformations, and business rules across multiple source and target systems.
· Perform Source-to-Target (S2T) validation, data reconciliation, and end-to-end data flow testing.
· Develop and execute complex SQL queries for data analysis, validation, and defect investigation.
· Verify data completeness, accuracy, consistency, duplicate handling, NULL validations, and transformation logic.
· Investigate and troubleshoot data discrepancies, ETL failures, and data quality issues.
· Develop and maintain data test automation frameworks to improve testing efficiency and coverage.
· Collaborate with Data Engineers, Business Analysts, and stakeholders to ensure high-quality data delivery.
· Contribute to test planning, defect tracking, reporting, and continuous improvement initiatives.
Skills, Knowledge and Expertise
· 5+ years of experience in QA with a strong focus on ETL Testing and Data Validation.
·Hands-on experience in ETL/Data Testing across data warehouse and analytics platforms.
·Strong SQL expertise, including complex joins, aggregations, subqueries, and data analysis.
· Solid understanding of Data Warehousing concepts, dimensional modeling, fact and dimension tables.
· Proven experience with Source-to-Target (S2T) validation, data reconciliation, and data quality testing.
· Strong understanding of ETL processes, data transformations, and end-to-end data flows.
· Experience in identifying, analyzing, and resolving data quality issues.
· Hands-on experience with ETL/Data Test Automation frameworks and tools.
· Strong analytical, troubleshooting, and problem-solving skills.
Good to Have
- Experience with Azure Data Factory (ADF).
- Exposure to ETL tools such as Talend, Informatica, SSIS, or similar platforms.
- Understanding of CI/CD practices and Agile development methodologies.
- Experience working with cloud-based data platforms and modern data architectures.
About
At ParentPay Group, we believe that when schools run well, students thrive. That’s why we’ve spent decades building the operating system that supports well‑run schools – a seamless layer of tools, insights, and support that makes school life simpler for teachers, leaders, caterers, parents, and students alike.From cashless payments and parent engagement to catering management, library systems, and MIS platforms, we connect the everyday parts of education through simple, secure, and connected tools. What began as a way to make school payments easier has grown into Europe’s leading EdTech group – trusted by over 20,000 schools and 9 million users across the UK and Europe.Every day, our platforms process millions of payments, messages, and data points, quietly working in the background so schools can shine out front. Together, we’re helping schools save time, cut costs, and create more time for learning.ParentPay Group is more than a collection of brands. We are a group of people dedicated to supporting well‑run schools and giving time back to teachers, parents, caterers, admin staff – and most importantly, to students.
Skills Required
- 5+ years of QA experience focused on ETL testing and data validation
- Hands-on ETL and data testing experience across data warehouse and analytics platforms
- Strong SQL expertise, including complex joins, aggregations, subqueries, and data analysis
- Understanding of data warehousing concepts, dimensional modeling, fact tables, and dimension tables
- Experience with source-to-target validation, data reconciliation, and data quality testing
- Strong understanding of ETL processes, data transformations, and end-to-end data flows
- Experience identifying, analyzing, and resolving data quality issues
- Hands-on experience with ETL and data test automation frameworks and tools
- Strong analytical, troubleshooting, and problem-solving skills
- Experience with Azure Data Factory
- Exposure to Talend, Informatica, SSIS, or similar ETL platforms
- Understanding of CI/CD practices and Agile development methodologies
- Experience with cloud-based data platforms and modern data architectures
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
ParentPay Group is a leading European EdTech company that provides an integrated ecosystem of technologies for educational institutions. Their services include data management, cashless payments, parent engagement, meal management, and library systems. Their mission is to streamline administrative tasks for schools, allowing educators to save time and focus on teaching and supporting students, ultimately aiming to create more time for learning.
