Senior QA Lead: ETL & Healthcare Claims Testing

Capgemini; Aguascalientes; On-site; MXN 900,000 - 1,500,000; Full time

Job summary

Capgemini is seeking a Senior QA Lead - ETL & Healthcare Claims Testing in Mexico to steer end-to-end QA across data platforms, ETL processes, and healthcare claims systems. You will drive data accuracy, integrity, and validation across payer ecosystems, guiding cross-functional teams and defining quality metrics.

You will mentor QA resources, shape test strategies, and ensure robust data movement and transformations, with a focus on risk reduction and continuous improvement.

Qualifications

• 8+ years of experience in Quality Assurance, Data Testing, or ETL Testing roles.
• Proven experience leading QA teams and large-scale testing initiatives.
• Strong hands-on experience with ETL Testing, Data Warehouse Testing, and Data Migration Validation.
• Advanced SQL skills for data validation, reconciliation, and quality assurance activities.
• Experience validating source-to-target mappings and transformation logic.
• Strong understanding of healthcare payer systems and claims processing workflows.
• Knowledge of claims adjudication, pricing, eligibility, reimbursement, and payment processes.
• Experience managing defect lifecycles, test execution, and quality reporting.
• Experience working with Agile and Waterfall delivery methodologies.
• Strong communication, leadership, and stakeholder management skills.

Responsibilities

• Lead QA activities across ETL, data migration, data warehouse, and healthcare claims processing initiatives.
• Develop comprehensive test strategies, test plans, test cases, and execution schedules for data-centric projects.
• Validate ETL processes, data transformations, and source-to-target mappings to ensure data accuracy and completeness.
• Perform data migration testing, reconciliation testing, and data integrity validation across multiple systems.
• Execute SQL-based data validation and quality assurance activities.
• Validate healthcare payer workflows, claims lifecycle processes, adjudication, pricing, reimbursement, and payment functionality.
• Coordinate functional, integration, regression, and end-to-end testing activities across business and technical teams.
• Identify, document, prioritize, and track defects through resolution and retesting.
• Establish quality metrics, testing dashboards, governance processes, and reporting standards.
• Collaborate with ETL developers, Data Engineers, Business Analysts, Product Owners, and stakeholders to ensure complete test coverage.
• Support automation initiatives for ETL and data validation processes where applicable.
• Lead QA resources, provide mentoring and technical guidance, and promote testing best practices across teams.
• Drive continuous improvement initiatives focused on quality, efficiency, and risk reduction.

Skills

QA leadership

ETL testing

Data warehousing

Healthcare domain

SQL expertise

Tools

ETL Testing Tools

Jira

Data Warehouse Platforms

Job description

Capgemini is seeking a Senior QA Lead - ETL & Healthcare Claims Testing in Mexico to steer end-to-end QA across data platforms, ETL processes, and healthcare claims systems. You will drive data accuracy, integrity, and validation across payer ecosystems, guiding cross-functional teams and defining quality metrics.

You will mentor QA resources, shape test strategies, and ensure robust data movement and transformations, with a focus on risk reduction and continuous improvement.