Senior Quality Engineer - Python, Selenium, SQL, AWS/Azure

Optum India; Chennai District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Optum India is seeking an experienced Senior ETL QA Tester to ensure the accuracy, completeness, integrity, and performance of enterprise data pipelines. The role requires expertise in data warehouse testing, ETL validation, and cloud platforms, leveraging AI-powered QA practices.

Responsibilities include designing test strategies, validating data across sources, staging, and targets, and collaborating with data engineers, analysts, and product owners.

Qualifications

• Graduate degree or equivalent experience.
• 6+ years of ETL/Data Warehouse Testing experience.
• Experience in Agile/Scrum environments with Jira/Rally.
• Strong SQL skills with complex joins and performance tuning.
• Hands-on experience with ETL tools and cloud testing (AWS/Azure).
• Familiarity with Databricks and data pipelines.
• Automation: Python, PyTest, Great Expectations; SQL-based automation; Selenium/Cypress.
• AI tools for QA: Copilot, ChatGPT; AI-powered test automation platforms.

Responsibilities

• ETL & Data Validation: validate ETL/ELT across source, staging, and target systems.
• Data reconciliation, quality, and integrity testing; SQL validation of transformations.
• Verify business rules, mappings, and transformation logic; analyze data lineage.
• Validate data migration/conversion activities; plan and execute tests.
• Validate data pipelines in cloud environments such as Azure and AWS (Redshift).
• Develop test strategies, plans, and test cases for ETL/data warehouse projects.
• Execute functional, integration, regression, system, and end-to-end testing.
• Identify, document, track, and retest defects; collaborate with teams.
• AI-Assisted Quality Engineering: use AI tools to generate/analyze tests and data.
• Automation & Continuous Testing: maintain automated ETL validation frameworks; CI/CD integration.
• Leadership & Collaboration: mentor juniors; participate in Agile ceremonies; drive QA best practices.

Skills

ETL testing

Data validation

SQL proficiency

Cloud testing

AI-assisted QA

Agile / Scrum

Leadership & collaboration

Education

Bachelor's degree or equivalent experience

Tools

Databricks

AWS Redshift

S3

Azure Data Factory

Jira

Rally

Great Expectations

PyTest

Selenium

Cypress

Job description

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together. We are seeking an experienced Senior ETL QA Tester with expertise in data warehouse testing, ETL validation, cloud-based data platforms, and AI-assisted quality engineering practices. The ideal candidate will be responsible for ensuring the accuracy, completeness, integrity, and performance of enterprise data pipelines. This role leverages AI-powered testing tools to improve test coverage, accelerate defect detection, optimize test case generation, and enhance overall testing efficiency.

Primary Responsibilities

• ETL & Data Validation
  • Validate ETL/ELT processes across source, staging, and target systems
  • Perform data reconciliation, data quality, and data integrity testing
  • Create and execute SQL queries to validate complex data transformations
  • Verify business rules, data mappings, and transformation logic
  • Analyze source-to-target mapping documents and data lineage
  • Validate data migration and conversion activities
• Validate data pipelines in cloud environments such as Azure, AWS
  • Perform testing on large-scale datasets using AWS Redshift, Databricks
• Test Planning & Execution
  • Develop comprehensive test strategies, test plans, and test cases for ETL and data warehouse projects
  • Perform functional, integration, regression, system, and end-to-end testing
  • Execute batch process validation and workflow testing
  • Conduct negative testing and boundary condition validation
  • Review requirements and identify test scenarios with minimal ambiguity
• Identify, document, track, and retest defects
  • Collaborate with developers, data engineers, business analysts, and product owners to resolve issues
  • Conduct root cause analysis and recommend process improvements
• AI-Assisted Quality Engineering
  • Utilize AI-powered testing tools to generate and optimize test cases
  • Leverage AI assistants for SQL generation, test data creation, defect analysis, and root cause identification
  • Use AI-based anomaly detection techniques to identify data quality issues
  • Apply predictive analytics to prioritize testing efforts and identify high-risk areas
  • Automate repetitive validation tasks using AI-driven frameworks
• Automation & Continuous Testing
  • Design and maintain automated ETL validation frameworks
  • Develop automated test scripts using Python, SQL, or other automation tools
  • ntegrate automated testing into CI/CD pipelines
  • Monitor and analyze test execution reports and quality metrics
• Leadership & Collaboration
  • Mentor junior QA engineers and provide technical guidance
  • Participate in Agile ceremonies including sprint planning, daily standups, and retrospectives
  • Drive quality best practices across projects
  • Review peer test artifacts and automation code
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regard to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications

• Graduate degree or equivalent experience
• 6+ years of ETL/Data Warehouse Testing experience
• Solid experience testing enterprise data warehouse applications
• Experience working in Agile/Scrum environments and tools such as Jira/Rally
• Technical Skills
  • Advanced SQL skills with experience in complex joins, stored procedures, functions, and performance tuning
  • Hands-on knowledge of ETL tools
  • Cloud Testing - AWS Services - S3, Redshift, Data pipelines, Step function, EC2, etc.
  • Databricks
  • Automation
    • Python
    • PyTest
    • Great Expectations Framework
    • SQL-based automation frameworks
    • Selenium/Cypress - Good to know
  • AI Tools
    • Microsoft Copilot
    • GitHub Copilot
    • ChatGPT - Prompt Engineering
    • AI-powered test automation platforms
    • AI-based data validation and anomaly detection tools

Preferred Qualifications

• Certifications:
  • Microsoft Azure Data Engineer Associate
  • Microsoft Azure Fundamentals
  • ISTQB Advanced Test Analyst
  • Certified Agile Tester
  • Snowflake Certification
  • Databricks Data Engineer Certification
• Healthcare domain experience
• Experience with Data Lake and Big Data testing
• Experience with API testing using Postman or Rest Assured
• Familiarity with ML/AI data validation testing
• Knowledge of Data Governance and Data Quality frameworks

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone - of every race, gender, sexuality, age, location and income - deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.