Data Automation QA Engineer

Role Name: Senior Data Automation QA Engineer
Location: Fort Mill, SC

Start date: 2026-11-02
Background check MANDATORY
GTD ID: HGTE0K

Due to additional onboarding requirements, a meet and greet is required for all new hires.

Candidates must be willing to go to the closest Capgemini, Client, or onsite location as indicated by project team to meet with a Capgemini team member prior starting their assignment. If the candidate is not local, travel covered by Capgemini. If travel is involved and after selection the candidate declines the offer, costs will be paid by vendor and not Capgemini.

JOB DESCRIPTION:
We are seeking a skilled Data Automation Engineer with expertise in Python automation PyTest automation framework development database testing and ETL validation The ideal candidate will have a strong background in software testing and automation with a focus on ensuring the quality and reliability of software solutions The candidate should also be capable of leveraging AIpowered development tools to enhance automation development productivity and quality while working within Agile teams

Key Responsibilities:

• Develop and maintain automated test scripts using Python and PyTest to ensure the quality of Data products
• Work closely with product and engineering teams to understand features develop and automate test cases and improve product quality
• Perform database testing to validate data integrity and accuracy
• Collaborate with crossfunctional teams to understand requirements and develop test plans
• Execute automated test cases and analyze results to identify defects and ensure product quality
• Integrate automated tests into the CICD pipeline to ensure continuous testing
• Document test cases test results and defects in a clear and concise manner
• Participate in code reviews and provide feedback to improve the quality of the codebase
• Stay up to date with the latest industry trends and best practices in test automation AIassisted testing and database testing
• Handson knowledge of cloud providers such as AWS Azure or GCP including services like EC2 S3 RDS Lambda etc
• Create and maintain test data and test environments
• Troubleshoot and debug issues in test scripts frameworks and test environments
• Mentor and train junior team members on automation framework development and testing best practices
• Collaborate with developers to ensure testability of code and sufficient automation coverage
• Write and execute complex SQL queries Joins Rank Union CTEs Window Functions etc to validate data integrity and accuracy
• Develop and maintain database testing scripts and tools
• Collaborate with database administrators to resolve databaserelated issues
• Work within Agile teams to deliver highquality database solutions
• Participate in Agile ceremonies such as sprint planning daily standups and retrospectives
• Leverage AI tools such as GitHub Copilot ChatGPT Cursor or similar technologies to accelerate framework development generate test scenarios improve code quality and enhance automation productivity

• 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
• Agile methodologies

• Experience using AIpowered development tools GitHub Copilot ChatGPT Cursor etc for automation development test case generation framework enhancements and productivity improvements

• Bachelors degree in Computer Science Engineering or a related field
• Proven experience with Varicent products and their implementation
• Strong proficiency in Python programming PyTest and automation framework development
• Experience building scalable and maintainable automation frameworks
• Experience with database testing including writing and executing complex SQL queries
• Familiarity with CICD tools and processes eg Jenkins GitHub Actions
• Experience with API automation testing
• Ability to effectively utilize AIassisted development tools to improve automation efficiency and framework development
• Excellent problemsolving skills and attention to detail
• Strong communication and collaboration skills
• Ability to work independently and as part of a team
• Experience working in Agile environments and familiarity with Agile methodologies

• Experience with other automation tools and frameworks
• Familiarity with cloud platforms AWS Azure GCP
• Experience with RESTful API testing and tools Postman SoapUI
• Knowledge of version control systems Git
• Understanding of Agile methodologies and practices
• Experience with containerization technologies Docker Kubernetes
• Experience with data warehousing and ETL processes
• Experience with PyTest plugins Allure Reporting and advanced automation framework architecture
• Handson experience using AIassisted software development and testing tools such as GitHub Copilot ChatGPT Azure OpenAI Cursor Claude or equivalent technologies
• Ability to evaluate and adopt AIpowered solutions to improve test automation coverage quality and efficiency