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

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.

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