Job ID: SC-7512 (98590724)
Hybrid/Local Automation Tester with ETL (must), Python, Pytest, SQL Server/Oracle, Web UI/Selenium, CI/CD, Medicaid, Atlassian JIRA/Confluence, REST API, microservices, data ingestion, regression testing, Agile/waterfall experience
Location: Columbia, SC (DHHS )
Duration: 12 Months (Possibility for Extension: Yes)
Position: 1
Work Location: Hybrid (3 days onsite, 2 days remote), First month will be fully onsite for training & Candidate must be a CURRENT SC resident or willing to relocate to SC prior to starting the role at their own expense.
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:
• Integrate test automation into CI/CD pipelines.
• 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
Job 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.
The South Carolina Department of Health & Human Services (SCDHHS) is the State Medicaid Agency for South Carolina.
The Quality Assurance Analyst – Project Lead will be assigned to projects for the South Carolina Department of Health and Human Services (SCDHHS), the Medicaid Agency for SC.
Candidates who enjoy working on complex, change-oriented projects will find this position attractive.
SCMSP_Candidate_Cover_Sheet_Updated (1).docx