• ETL Test Lead - Hybrid

    MSys Inc. (Columbia, SC)


    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 [email protected]

     

    Our recruiters will be more than happy to help you to get this contract.