Overview
Skills
Job Details
Position Title: Quality Assurance Analyst - Project Lead
Location: Columbia, SC
Required Experience: 10+ years
Tax Terms: C2C, W2
Note: Need only locals from Columbia, SC with local Id.
PROJECT DESCRIPTION:
Responsible for performing tests on technical solutions to isolate and solve issues. Initiates test, 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.