Senior Quality Engg-ETL Testing, SQL, Python

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.

Primary Responsibilities:

• Design, Develop, Execute and analyze automation test scripts & test results
• Perform root cause analysis, database validation, and data defect identification using SQL
• Create/Identify test data to validate functional and technical requirements
• Requirement traceability of test cases to ensure coverage for full system integration test
• Execute Test Planning and Automation for multiple strategic programs against well-defined milestones and business objectives
• Design, implement, and maintain data pipelines for data ingestion, processing, and transformation in Azure ADF
• Work together with data engineers and analysts to understand the needs for data and create effective data workflows
• Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and Azure Blob Storage
• 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 regards 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
• 7+ years of Software Quality Assurance experience on enterprise level applications which includes Data Warehouse / ETL / Power BI Testing
• Demonstrated experience of automation test frameworks across multiple platforms and technologies such as selenium, Python and understand its application throughout the full development lifecycle
• Experience in testing systems that capture, verify, and maintain field generated metadata Familiarity with multiple back-end and front-end languages and libraries, databases, database design, web servers, web services, APIs, and UI/UX design
• Experience of Agile Software Development & Testing methods for deployment in cloud environments
• Proven experience in all aspects of SDLC & Agile – Scrum methodologies
• Experience in writing complex SQL queries, Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e, data validation, regression, etc.), including evaluating the testability of requirements
• Experience in API testing using tools such as POSTMAN
• Experience in report testing(Power BI) using selenium
• Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle
• Solid understanding in advancement of CI/CD or DevOps Testing Models with Github, Jenkins
• Proven ability to write complex SQL queries for database validation and data defect identification

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.

Country: IN