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

Optum; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Optum is seeking a Senior Quality Engineer with expertise in Python, Selenium, SQL, and cloud data testing to validate ETL processes and data pipelines.

You will leverage AI-assisted testing to enhance coverage and efficiency while collaborating with data engineers and product teams to deliver high-quality data solutions.

Qualifications

• 6+ years of ETL/Data Warehouse Testing experience.
• Solid experience testing ERP/enterprise data warehouse apps.
• Experience in Agile/Scrum with Jira/Rally.
• Advanced SQL with complex joins, stored procedures, performance tuning.
• Hands-on ETL tools knowledge and cloud testing (AWS/Azure).
• Experience with Databricks and data pipelines.
• Automation using Python, PyTest, Great Expectations and SQL-based frameworks.
• Selenium/Cypress is a plus; AI testing tools familiarity is welcome.

Responsibilities

• 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 transformations.
• Verify business rules, data mappings, and transformation logic.
• Analyze source-to-target mapping documents and data lineage.
• Validate data migration and conversion activities.
• Test cloud pipelines in Azure and AWS (Redshift, Databricks).
• Develop test strategies, plans, and cases for ETL/DW projects.
• Perform functional, integration, regression, system, end-to-end testing.
• Identify, document, track, and retest defects; collaborate with teams.
• AI-assisted quality engineering: use AI tools to generate/test data and analyze defects.
• Design and maintain automated ETL validation frameworks and CI/CD integration.
• Mentor junior QA engineers and participate in Agile ceremonies.

Skills

ETL Testing

Data Warehouse Testing

SQL

Python

PyTest

Great Expectations

Selenium

Automation

Cloud Testing

AWS

Azure

Databricks

AI Testing Tools

SQL-based automation

Prompt Engineering (AI)

Tools

Jira

Rally

Postman

Rest Assured

Databricks

Job description

Improve the lives of others while Caring. Connecting. Growing together.

Job Description - Senior Quality Engineer - Python, Selenium, SQL, AWS/Azure (2381031)

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

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
• 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
• 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:

• 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
• 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.

UnitedHealth Group is committed to working with and providing reasonable accommodations to individuals with physical and mental disabilities. If you need special assistance or accommodation for any part of the application process, please call 1-866-566-8715 to be connected to Recruitment Services. Recruitment Services hours of operation are 7 a.m. to 7 p.m. CT, Monday through Friday.

UnitedHealth Group is a registered service mark of UnitedHealth Group, Inc. The UnitedHealth Group name with the dimensional logo, as well as the dimensional logo alone, are both service marks for the UnitedHealth Group, Inc.

Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.