Data Profiling SQL Server Analyst (Jobs in Columbia, SC)   Requirement id 154337 Job title Analyst Job location in Columbia, SC Skills required Test Scenarios, Python Scripting, ETL Process, Data Profiling SQL Server Open Date 17-Jul-2025 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Analyst: Test Scenarios, Python Scripting, ETL Process, Data Profiling SQL Server Start Date :8/26/2025 End Date :12 Months from projected start date Submission Deadline :7/24 at 5:00 PM EST. Client Info : SCDHHS Note: * Interview Process: 1 round - virtual * Duration of the Contract: 12 months * Possibility for Extension: Yes * Work Location: Hybrid (3 days onsite, 2 days remote), First month will be fully onsite for training & Candidate must be a CURRENT SC resident. No relocation allowed. Description : COMPANY / DEPARTMENT CULTURE The South Carolina Department of Health & Human Services (SCDHHS) is the State Medicaid Agency for South Carolina. The Quality Assurance Analyst – Project Lead will be assigned to projects for the South Carolina Department of Health and Human Services (SCDHHS), 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: • 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   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 154337 while calling.   Other jobs in SC: Beaufort (1), Blythewod (2), Blythewood (3), Charleston (17), Columbia (37), Greenville (4), Hartsville (2), North Charleston (2), Overland Park (1), San Francisco (1), SENECA (4), South Carolina (1), Spartanburg (3), Unknown (2), Test Scenarios job openings in Columbia, SC Jobs List Quality Assurance Tester - Advanced - 11428-1 Create date: 22-Oct-2024 Candidate Submission Limit Per Supplier : 2 Start date : 11/19/2024 Submission deadline : 10/29/2024 Client Info : Department of Health and Human Services Note : Q) INTERVIEW PROCESS A) Telephone interview conducted by appropriate team members. Description : ----.... (This job is for - job Jobs in SC COLUMBIA Tester - (in Columbia, SC)) Quality Assurance Tester - Advanced-11116-1 Create date: 30-Jan-2024 Start date : 2/27/2024 Submission deadline : 2/6/2024 Client Info : Department of Health and Human Services Note : Q) INTERVIEW PROCESS A) Telephone interview conducted by appropriate team members. Description : ------------------------------------------------------ Respo.... (This job is for - job Jobs in SC Columbia Tester - (in Columbia, SC)) Quality Assurance Tester - Advanced -10980-1 Create date: 03-Oct-2023 Start date :11/17/2023 Submission deadline :10/9/2023 Client Info : Department of Health and Human Services Note : Q) INTERVIEW PROCESS A) Video conference (Microsoft Teams) interview conducted by appropriate team members. Description : -----------------------------------------.... (This job is for - Jobs in SC Columbia Consultant - (in Columbia, SC)) LEAD DIGITAL ACCESSIBILITY TECHNICIAN-10262-1 Create date: 04-Feb-2022 Start Date :02/21/2022 Submission Deadline :2/11/2022 Client Info : University of South Carolina - Columbia Campus Note : * INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)? MS TEAMS * SCHEDULE INTERVIEW: HOW SOON CAN YOU SCHED.... (This job is for - Jobs in SC Columbia Consultant - (in Columbia, SC)) Quality Assurance Tester - Advanced - 10030-1 Create date: 30-Aug-2021 Start Date :09/27/2021 Submission Deadline :09/6/2021 Client Info : Department of Health and Human Services Note : * INTERVIEW PROCESS Telephone interview conducted by appropriate team members. * SCHEDULE INTERVIEW: Interviews will start prior to the position .... (This job is for - job Jobs in SC Columbia Tester - (in Columbia, SC))    Test Scenarios job openings in other states Jobs List Chesterfield County Business Analyst 4 (746504) Create date: 09-Sep-2024 No of submissions : 2 Start date : 9/23/2024 End date : 12/31/2024 Submission Deadline : 9/13/2024 Client info : Chesterfield County Note : * Agency Interview Type: Web Cam Interview Only * Work Arrangement: Hybrid Description : Project manager .... (This job is for - Business Analyst Jobs in VA Chesterfield Analyst - (in Chesterfield, VA)) DMAS - System Analyst 4 (746183) Create date: 04-Sep-2024 Hybrid No of Submissions : 2 start date :09/23/2024 End date :09/22/2025 submission deadline : 9/9/2024 client info : DMAS Note: * Agency Interview Type: Web Cam Interview Only * ON SITE REQUIRED: 3 days onsite and 2 days remote. Parking is not provided for .... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) ITSAC 529300491 Business Analyst 2 -SP Create date: 10-Feb-2023 Bid URL: Note: Total estimated hours per Candidate shall not exceed 1192 hours Submission Deadline: 2/17/2023 5:00 PM CT Start Date: 3/13/2023 End Date : 8/31/2023 Client: Texas Health and Human Services Commission (HHSC) Description: Years Required/Preferred Experience 5 Requi.... (This job is for - job Jobs in TX Austin Analyst - (in Austin, TX)) ITSAC 529310146 Business Analyst 2 -SP Create date: 26-Aug-2022 Note: RTR form must be signed by the candidate. Note: Total estimated hours per Candidate shall not exceed 2016 hours. Submission Deadline: 9/2/2022 5:00 PM CT Start Date: 10/3/2022 End Date : 8/31/2023 Client: Texas Health and Human Services Commission (HHSC) Description: Years Requ.... (This job is for - job Jobs in TX Austin Analyst - (in Austin, TX)) ITSAC 529310146C Business Analyst 2 -SP Create date: 26-Aug-2022 Note: RTR form must be signed by the candidate Note: Total estimated hours per Candidate shall not exceed 2016 hours. Submission Deadline: 9/2/2022 5:00 PM CT Start Date: 10/3/2022 End Date : 8/31/2023 Client: Health and Human Services Commission (HHSC) Description: Years Required/Pr.... (This job is for - job Jobs in TX Austin Analyst - (in Austin, TX))    Test Scenarios job openings in SC Jobs List Testing Manager - 5478-1 Create date: 09-Apr-2014 Description: The Medicaid Member Management project is one of the most complex technology development projects undertaken by Client. This project is a multi-year effort to replace the States Medicaid Eligibility Determination System (MEDS) with a multi-tier application environment that requires modern technologies, technical practic.... (This job is for - job Jobs in SC Clemson Manager - (in CLEMSON, SC)) (Analyst: Test Scenarios, Python Scripting, ETL Process, Data Profiling SQL Server in Columbia, SC)

Featured Jobs HL7 Analyst (Jobs in Boise, Idaho) PMI PMP SCRUM Manager (Jobs in Richmond, Virginia) MS Office Sharepoint Expert (Jobs in Raleigh, North Carolina) Troubleshooting Strong Analyst (Jobs in Charlotte, North Carolina) React Vue.Js Kendo Architect (Jobs in Madison, Wisconsin) - Engineer (Jobs in Madison, Wisconsin) Sql Server 2000 SSRS Administrator (Jobs in Richmond, Virginia) SWIFT Kendo Developer (Jobs in Madison, Wisconsin) Rfps Consultant (Jobs in Raleigh, North Carolina) Defect Analyst (Jobs in Madison, Wisconsin)