Overview
Skills
Job Details
Our government client is looking for experienced Quality Assurance Analyst on a hybrid 12+ months renewable contract opportunity in Columbia, SC.
Role: Quality Assurance Analyst
SCOPE OF THE PROJECT:
The Quality Assurance Analyst – Project Lead will be assigned to projects for the agency, the Medicaid Agency for SC. Candidates who enjoy working on complex, change-oriented projects will find this position attractive.
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 (RANKED IN ORDER OF IMPORTANCE):
- 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 (RANKED IN ORDER OF IMPORTANCE):
- 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