Data Automation QE

Capgemini; Fort Mill (SC); On-site; USD 48,000 - 75,000; Full time

Benefits offered by this job

Medical, dental, vision benefits

Retirement benefits

Job summary

Tundra Technical Solutions is seeking a Data Automation Engineer in Fort Mill, SC. You will develop and maintain automated test scripts using Python and PyTest, validate data integrity with SQL queries, and contribute to AI-assisted testing within an Agile team.

Responsibilities include integrating tests into CI/CD pipelines, collaborating with product and engineering teams to broaden test coverage, and mentoring junior developers on automation best practices.

Qualifications

• Bachelor's degree in CS or related field required.
• Proven experience designing and maintaining automation frameworks.
• Strong Python and PyTest skills with SQL experience.

Responsibilities

• Develop and maintain automated test scripts using Python and PyTest.
• Collaborate with product and engineering teams to automate test cases.
• Perform database testing and validate data integrity.
• Integrate automated tests into CI/CD pipelines for continuous testing.
• Write complex SQL queries to verify data.
• Mentor junior team members on automation practices.

Skills

Python

PyTest

Automation framework

SQL queries

CI/CD tools

API automation

AI tooling

Cloud platforms

Agile methodologies

Education

Bachelor's degree in Computer Science

Tools

GitHub Actions

Jenkins

Azure DevOps

Docker

Kubernetes

Postman

Allure

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 AI powered 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 cross functional 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 AI-assisted testing and database testing
• Hands-on 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

Must Have Skills:

• ETL process validation Database Testing and SQL Complex Queries
• Hands-on experience with cloud platforms such as AWS Azure or GCP
• Strong Python programming skills with hands-on 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

Required Skills and Qualifications:

• 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 AI assisted development tools to improve automation efficiency and framework development
• Excellent problem solving 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

Preferred Knowledge and Skills:

• 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
• Hands-on experience using AI assisted software development and testing tools such as GitHub Copilot ChatGPT Azure Open-AI Cursor Claude or equivalent technologies
• Ability to evaluate and adopt AI powered solutions to improve test automation coverage quality and efficiency

The pay range that the employer in good faith reasonably expects to pay for this position is $34.64/hour - $54.13/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America's leading providers of Staffing and Consulting Services. Our success and our clients' success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.