Apply on Employer Site

InterSources Inc · 5 months ago

Quality Assurance Analyst - Project Lead

Columbia, SC

Full-time

Onsite

Senior Level

5+ years exp

InterSources Inc. is a Small, Woman, and Minority-Owned Business Enterprise with over 18 years of experience in IT Consulting Services. The role involves leading quality assurance efforts, developing test strategies, and automating test processes to ensure the integrity of data pipelines and applications.

Artificial Intelligence (AI)Cyber SecurityInformation TechnologySoftware

Growth Opportunities

H1B Sponsor Likely

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

Qualification

PythonETL automationSQLSeleniumCI/CD integrationJIRAAgile methodologyData profiling

Required

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

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

Company

InterSources Inc

Innovative IT Solutions Built for Your Business. InterSources Inc is your partner in Growth and CyberSecurity.

Founded in 2007

Fremont, California, USA

501-1000 employees

https://www.intersourcesinc.com

H1B Sponsorship

InterSources Inc has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (4)

2024 (5)

2023 (16)

2022 (1)

2021 (7)

2020 (7)