Lead I - Software Testing

Who We Are At UST, we help the world’s best organizations grow and succeed through transformation. Bringing together the right talent, tools, and ideas, we work with our clients to co-create lasting change. Together, with over 30,000 employees in 30+ countries, we build for boundless impact, touching billions of lives in the process. Visit us at www.ust.com. Summary UST is looking for a highly skilled QA Engineer with strong expertise in ETL Testing, Database Testing, Snowflake, Data Warehouse Validation, and Test Automation. The ideal candidate will be responsible for validating complex data pipelines, ensuring data quality, executing automation testing, and supporting business-critical healthcare applications. This role requires excellent analytical skills, hands-on database testing experience, and a deep understanding of healthcare provider data systems. The Opportunity As a QA Engineer, you will play a critical role in validating enterprise data platforms, ETL workflows, and data warehouse solutions. You will collaborate closely with business stakeholders, development teams, data engineers, and product owners to ensure high-quality, reliable, and scalable data solutions.

Key Roles & Responsibilities

Design, develop, and execute test strategies, test plans, and test cases for ETL and Data Warehouse applications.

Perform ETL, Database, Data Warehouse, Functional, Smoke, Regression, Acceptance, Compatibility, and Exploratory Testing.

Validate source-to-target data movement and ensure data integrity across systems.

Perform comprehensive Snowflake database testing and validation activities.

Create and execute test scenarios for complex ETL workflows and data transformation processes.

Analyze business requirements and translate them into effective test cases and validation procedures.

Write and execute complex SQL queries for data validation and testing.

Validate Data Warehouse structures including fact tables, dimension tables, star schemas, and snowflake schemas.

Prepare test data and validation scenarios based on business requirements and healthcare datasets.

Develop and maintain automation frameworks using ICEDQ and other testing tools.

Manage defects through Jira and participate in defect tracking, triaging, and resolution activities.

Perform production support validation and participate in WAR room discussions for critical incidents.

Analyze and troubleshoot production failures and data quality issues.

Understand and validate job scheduling workflows using Control-M.

Collaborate with business analysts, developers, and stakeholders to ensure quality deliverables.

Create technical documentation, test reports, and knowledge transfer materials.

Participate in Agile ceremonies including sprint planning, backlog grooming, daily stand-ups, and retrospectives. What You Need

Requirements

Minimum 5+ years of experience in ETL, Database, Data Warehouse, and Automation Testing.

Strong hands-on experience in Snowflake testing and validation.

Expertise in ETL testing methodologies and data validation techniques.

Strong SQL and database querying skills.

Experience in Oracle PL/SQL and database testing.

Experience in functional, regression, acceptance, smoke, compatibility, and exploratory testing.

Strong understanding of Data Warehouse concepts and architectures.

Experience working with defect tracking and test management tools such as Jira.

Knowledge of automation testing frameworks and ICEDQ.

Experience working in Agile development environments.

Strong analytical and problem-solving skills.

Ability to work independently with business and technical teams.

Excellent communication and stakeholder management skills. Required Skills

ETL Testing

Data Warehouse Testing

Database Testing

Snowflake Testing

Oracle PL/SQL

SQL Query Development

Test Automation

ICEDQ

Jira

Functional Testing

Regression Testing

Smoke Testing

Acceptance Testing

Compatibility Testing

Exploratory Testing

Data Validation

Data Quality Assurance

ETL Validation

Defect Management

Defect Lifecycle Management

Control-M

STLC

Root Cause Analysis

Production Support

Defect Triaging Desired Skills

API Testing

Automation Framework Development

Python Programming

Data Analytics Validation

Cloud Data Platform Testing

Performance Testing

Healthcare Data Validation

CI/CD Exposure

Test Data Management

Advanced Data Quality Frameworks

Agile QA Practices Qualification

Bachelor's Degree in Computer Science, Information Technology, Engineering, or a related discipline. Experience 5+ Years Domain Expertise Candidates with experience in the US Healthcare domain will be highly preferred.

Preferred Healthcare Knowledge

Claims Processing

Member Management

Provider Management

Strategic Provider Systems

Provider Data Management

Pricing Automation

Reimbursement Assignment Processes

Healthcare Data Quality Validation

Skills

• ETL Testing
• Database Testing
• Snowflake
• Oracle PL/SQL
• Test Automation
• ICEDQ
• Control-M
• SQL
• Jira
• Data Warehouse Testing
• Data Quality Validation

What We Believe We're proud to embrace the same values that have shaped UST since the beginning. Since day one, we've been building enduring relationships and a culture of integrity. Today, those same values inspire us to encourage innovation, champion diversity and inclusion, and place people at the center of everything we do.

Humility

We will listen, learn, be empathetic, and help selflessly in our interactions with everyone.

Humanity

Through business, we will better the lives of those less fortunate than ourselves.

Integrity

We honor our commitments and act with responsibility in all our relationships.

Equal Employment Opportunity Statement

UST is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other basis protected by applicable law.

UST reserves the right to periodically redefine roles and responsibilities based on organizational requirements and/or employee performance.

Support and promote the values of UST.

Comply with all Company policies and procedures.