Consultant - ETL Tester

Senior ETL Tester: Thryve Digital Health LLP is an emerging global healthcare partner that delivers strategic innovation, expertise, and flexibility to its healthcare partners. Being a US healthcare conglomerate captive, we have direct access to deeper insights that help us accelerate our learning process and keeps us ahead of the curve. Thryve delivers next-generation solutions that enable our healthcare partners to provide positive experiences to their consumers. Our global collaborative of healthcare, operations, and IT experts creates innovative and sustainable processes for our clients, which keeps the ever-evolving consumers engaged and assists them in managing the future of their healthcare better. We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. Thryve is an equal opportunity employer and places a high value on integrity, diversity, and inclusion in the organization. We do not discriminate based on any protected attribute. For more information about the organization, please visit www.thryvedigital.com Role Summary: We are seeking a highly skilled and detail-oriented ETL Senior Tester to join our growing data team. The successful candidate will be responsible for validating the accuracy, completeness, and integrity of data as it flows through our enterprise-grade Extract, Transform, Load (ETL) and Extract, Load, Transform (ELT) processes and data pipelines. This role is crucial for ensuring the reliability of our data for analytics, reporting, and critical business operations. The ETL Tester will play a key role in designing and executing comprehensive test plans, scenarios, and cases for complex data transformations, data migrations, and data warehousing solutions. They will collaborate closely with data engineers, developers, business analysts, and other stakeholders to ensure that our data solutions meet business requirements Essential Responsibilities • Test Strategy & Planning: Analyze business, functional, and technical requirements to identify testable scenarios and clarify ambiguities in user stories and specifications. Design comprehensive test plans, test scenarios, and test cases for ETL workflows, data platforms, and reporting solutions. • ETL Testing Execution: Execute manual and automated testing for ETL processes, data transformations, data validation, and data pipelines. • Data Validation & Integrity: Perform thorough data validation, data comparison, and backend testing to ensure the accuracy of data transformations and mappings. Validate data mapping, transformations, aggregations, and business rules across source systems, staging layers, data warehouses, and reporting layers. Conduct data integrity checks, reconciliations, and consistency validations using advanced SQL and other data validation techniques. • SQL Proficiency: Write and execute complex SQL queries for data validation, reconciliation, integrity checks, and to verify data transformations and business rules. • Defect Management: Identify, log, track, and manage defects using tools such as Jira or Azure DevOps, and collaborate with developers and data engineers to resolve issues and verify fixes. • Performance Testing: Support ETL performance testing and validate load performance against benchmarks. Analyze pipeline runtime, throughput, latency, and resource utilization. • Documentation & Reporting: Document test execution results, defect reports, test evidence, and sign-off artifacts to support quality assurance, audits, and compliance. Communicate test results, risks, quality metrics, and recommendations clearly to cross-functional stakeholders. • Agile Collaboration: Actively participate in Agile delivery processes, including Program Increment planning, stand-ups, sprint planning, grooming, and retrospectives, and collaborate effectively with cross-functional teams. • Continuous Improvement: Incorporate learnings and best practices to improve the ETL testing process over time and contribute to continuous QA process improvements The experience we are looking to add to our team Required • Bachelor’s degree or higher from a reputed university • 6 to 10 years of experience in manual and automated testing, with a strong focus on ETL, data transformation, and data validation. • Strong understanding of ETL processes, data warehousing concepts (facts, dimensions, star/snowflake schema), and relational databases. • Advanced SQL skills, including writing complex queries for data validation, reconciliation, and integrity checks (joins, aggregations, subqueries, window functions). • Hands-on experience creating test cases, test scenarios, and executing test plans • Experience with cloud platforms such as Azure, AWS, or Google Cloud Platform • Experience with defect tracking tools such as Jira or Agility etc. • Strong analytical, problem-solving, and communication skills • Ability to work independently and collaboratively in an Agile environment • Experience with scripting languages like Python for test automation Good to have • Healthcare industry experience • Experience with cloud platforms such as Azure, AWS, or Google Cloud Platform • Familiarity with healthcare data models (claims, clinical, eligibility, provider data, etc.) • Understanding of data governance and data quality standards