Quality Assurance Analyst - Project Lead - QAA25-26482

ob Title: Quality Assurance Analyst – Project Lead
Location: Columbia, SC (Hybrid)
Duration: 12 Months (Contract)

Candidate must currently reside in South Carolina.

Position Overview:

We are seeking a skilled Quality Assurance Analyst – Project Lead to oversee and execute comprehensive testing of technical solutions within a large-scale modernization project. This role focuses on automated testing for ETL pipelines, data validation, and web UI applications. The ideal candidate will have expertise in Python-based automation, SQL, and a collaborative approach to problem-solving.

Responsibilities:

• Develop test strategies and detailed test cases for data pipelines and transformations.

• Create automated test scripts for ETL processes using Python.

• Write advanced SQL queries for data profiling, validation, and debugging (SQL Server, Oracle).

• Automate ETL validation using Python and Pytest frameworks.

• Conduct Web UI automation using Selenium for front-end data validation.

• Implement REST API test automation for microservices and data ingestion points.

• Collaborate with data engineers, analysts, and business teams to clarify requirements and understand data flows.

• Perform regression testing of ETL jobs during maintenance and enhancements.

• Build reusable, Python-based frameworks to support ongoing ETL testing.

• Integrate automated tests into CI/CD pipelines.

• Validate ETL job performance and scalability with growing data volumes.

• Document results, report defects, and communicate findings clearly.

• Utilize orchestration tools like Apache Airflow or Prefect (preferred).

• Manage source code in Git and track work via JIRA or Azure DevOps.

Required Qualifications:

• 3+ years translating business requirements into test cases and scenarios.

• 3+ years building test cases into test systems.

• 5+ years automating ETL validation using Python and Pytest.

• 5+ years creating automated ETL test scripts in Python.

• 3+ years advanced SQL query writing for data validation/debugging (SQL Server, Oracle).

• 1+ year Web UI automation experience using Selenium.

Preferred Skills:

• Experience integrating automated tests within CI/CD pipelines.

• 5+ years in large enterprise or e-business systems.

• Background in healthcare or Medicaid environments.

• Familiarity with Atlassian tools (JIRA, Confluence).

• Experience working in both Agile and traditional SDLC (waterfall) environments.