Data Integration Test Analyst - SOSC

Job Title: Data Integration Test Analyst
Location: Columbia, SC
Duration: 12 Months
Pay Rate: $55 – $60/hour

Candidate must be a CURRENT South Carolina resident. No relocation allowed.

Job Description:
Seeking a Data Integration Test Analyst to lead testing efforts focused on data ingestion and transformation processes. The ideal candidate will have strong SQL, ETL, and Python scripting experience, working within CI/CD pipelines and collaborating across data engineering and analytics teams.

Daily Responsibilities:

• Design and execute test plans for data ingestion pipelines and transformations.
• Develop automated Python scripts to validate data integration processes.
• Perform data profiling and anomaly detection using advanced SQL queries.
• Build and maintain automated regression test suites.
• Validate API endpoints related to data ingestion and services.
• Work with Apache Airflow or similar orchestration platforms for scheduling and monitoring data workflows.
• Collaborate with development and operations teams to resolve data quality issues.
• Manage test artifacts using tools like Azure DevOps or JIRA.
• Provide testing support during release cycles and data migrations.

Required Skills:

• 4+ years testing ETL and data integration solutions.
• 3+ years Python scripting experience for automated validation.
• 3+ years SQL experience (Oracle, SQL Server, or PostgreSQL).
• 1+ year API testing experience using Postman or similar tools.
• Experience with test management tools and CI/CD pipelines.

Preferred Skills:

• Familiarity with Airflow, Prefect, or similar orchestration tools.
• Healthcare data experience is a plus.
• Experience in Agile delivery environments.