Job Title: Quality Assurance Analyst
Location: Columbia, SC (3 days onsite, 2 days remote)
Client: South Carolina Department of Health & Human Services
Posting ID: 7512
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:
- 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
FedTec Overview:
FedTec is a Woman-Owned Small Business with headquarters in Reston, VA. However, FedTec is more than just a company – we are a dedicated team of visionary individuals who understand the power of transformation. With our unwavering commitment to innovative technology and forward-focused methods, we empower government agencies to fulfill their missions successfully with our Digital Transformation and Cyber Security capabilities. Our strategy is rooted in in-depth advising and a unique shoulder-to-shoulder mission experience, all geared towards enabling our clients, their agencies, and every American to thrive. We use the same approach with our employees, building meaningful and lasting relationships to meet their evolving needs and help them grow. We’re excited to welcome you to our family.
When You Join FedTec, You Are Joining a Family! We take pride in our work and the true and transparent relationships we build with our employees and partners. Just as you would do for your own family, we prioritize your safety, health, and happiness. That is why we've created the FedTec Total Well-Being program, offering benefits like:
- Health & Wellness: Medical, dental, and vision plans with valuable features like Telehealth virtual care and resources to support your physical and mental well-being.
- Time to Recharge: Generous paid time off to relax and rejuvenate.
- Financial Security: 401(k), company-paid short- and long-term disability, life insurance, and additional voluntary coverage.
- Life & Family Support: Employee Assistance Program (EAP), Pet Insurance, and PrepaidLegal services.
- Recognition & Growth: The FedTec Applause program rewards outstanding contributions, while our Learning & Development programs support your career growth.
- Fitness & Wellness: The FedTec Fit Program includes an on-staff Fitness Coach, personal and group training sessions, company fitness challenges, and ongoing wellness support.
Visit https://fedtec.com/ to learn more about who we are and where you can make an impact!
Job Type: Full-time
Pay: $78,598.03 - $94,655.69 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Work Location: In person