Data Test Automation Engineer - Python/PyTest

GAC Solutions; Fort Mill (SC); On-site; USD 90,000 - 120,000; Full time

Job summary

GAC Solutions in Fort Mill, SC seeks a QA automation engineer with strong Python skills and hands-on experience in ETL validation, SQL and API testing. You will design and maintain automation frameworks from scratch, using CI/CD tools and cloud platforms (AWS/Azure/GCP).

Experience with PyTest and AI-assisted tooling is valued. The role focuses on building scalable test automation, validating data quality, and driving productivity through automation enhancements.

Qualifications

• Experience validating ETL processes and ensuring data quality.
• Proficiency in SQL querying and data validation techniques.
• Strong Python programming skills for test automation.
• Experience designing, developing and maintaining automation frameworks from scratch.
• Familiarity with CI/CD tools and processes (Jenkins, GitHub Actions, Azure DevOps).
• API test automation experience.
• Exposure to AI-powered development tools for automation and productivity improvements.

Responsibilities

• Design, implement and maintain automated test suites for data pipelines and APIs.
• Craft robust QA automation frameworks from scratch and integrate with CI/CD.
• Utilize cloud platforms (AWS, Azure or GCP) for testing and validation.
• Leverage PyTest and modern tooling to accelerate test case generation and execution.
• Improve automation productivity using AI-assisted development tools.

Skills

ETL validation

SQL

Python

Test automation

Automation frameworks

API testing

AI tooling

Tools

AWS

Azure

GCP

PyTest

Jenkins

GitHub Actions

Azure DevOps

Job description

• ETL process validation Database Testing and SQL Complex Queries
• Handson experience with cloud platforms such as AWS Azure or GCP
• Strong Python programming skills with handson experience in PyTest
• Experience designing developing and maintaining automation frameworks from scratch
• Familiarity with CICD tools and processes Jenkins GitHub Actions Azure DevOps etc
• API Test Automation
• Experience using AI powered development tools GitHub Copilot ChatGPT Cursor etc for automation development test case generation framework enhancements and productivity improvements