Automation Tester with ETL

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.