Job summary: Title: ETL Test Lead - Hybrid Location: Columbia, SC, United States Length and terms: Long term - W2 Only Position created on 07/17/2025 07:09 pm Job description: *** Hybrid***Full time with benefits or long term hourly contract *** W2 only; ***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.*** 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 Contact the recruiter working on this position: The recruiter working on this position is Chinmayee Patro(Raghu Team) His/her contact number is +(1) (202) 6979490 His/her contact email is chunlipatro@msysinc.com Our recruiters will be more than happy to help you to get this contract.