Job Description

Mode of Interview: Webcam Interview

Work Arrangement: Hybrid (3 days onsite, 2 days remote), First month will be fully onsite for training & Candidate must be a CURRENT SC resident.

Work Location: Columbia, SC

Shift: EST

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

Job Tags

Similar Jobs