Quality Assurance Project Lead - Hybrid

Title: Quality Assurance Project Lead - Hybrid

Mandatory skills:

ETL, ETL validation, ETL process,
SQL, SQL queries, SQL Server, Oracle,
test, test cases, test scenarios, test systems, test strategies, test scripts, test automation,
Python, Pytest framework, Web UI, Selenium, Apache Airflow, Prefect,
business requirements, policy documentation, front end validation, data driven applications,
enterprise systems, e-business systems, business process, debugging, microservices,
Medicaid, healthcare operations,
Atlassian tool suite, JIRA, Agile, Confluence, Waterfall, SDLC, CI, CD, Git,
technical solution, orchestration platforms, defect management,
data pipelines, data transformations, data profiling, data validation, data flow, data ingestion

Description:

Daily Duties / Responsibilities:
Responsible for performing tests on technical solutions to isolate and solve issues. Initiates tests, analyzes results, and finds solutions to technical problems
Develop test strategies and detailed test cases to validate data pipelines and transformations.
Create automated test scripts using Python for ETL processes.
Write advanced SQL queries for data profiling, validation, and debugging across various platforms (e.g., SQL Server, Oracle).
Automate ETL validation processes using Python and Pytest frameworks.
Conduct Web UI automation using Selenium for front-end validation of data-driven applications.
Implement REST API test automation to validate microservices and data ingestion endpoints.
Work closely with data engineers, analysts, and business users to clarify requirements and understand data flows.
Perform regression testing of ETL jobs during enhancements or maintenance cycles.
Build reusable Python-based test frameworks to automate ETL testing.
Integrate test automation into CI/CD pipelines.
Validate performance benchmarks and ensure ETL jobs scale with data volume.
Document test results, defects, and communicate findings effectively.
Work with tools such as Apache Airflow, Prefect, or similar orchestration platforms (a plus).
Use Git for source control and tools like JIRA or Azure DevOps for test case and defect management.

Required Skills:
3+ years translating business requirements or policy documentation into test cases and scenarios.
3+ years building test cases and scenarios into test systems
5+ years Automating ETL validation processes using Python and Pytest frameworks
5+ years Creating automated test scripts using Python for ETL processes.
3+ years Writing advanced SQL queries for data profiling, validation, and debugging across various platforms (e.g., SQL Server, Oracle).
1+ year Conducting Web UI automation using Selenium for front-end validation of data- driven applications.

Preferred Skills:
5+ years large enterprise or e-business systems experience.
Background in healthcare operations (preferably Medicaid) and business processes
Proficient in Atlassian tool suite including JIRA and Confluence.
Prior experience working in a standard SDLC (waterfall methodology) & in an AGILE delivery

VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.

Contact Details :

VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008