Senior QA Automation Engineer – SQL, API & Data Testing
About The Position
The Senior QA Automation Engineer supports and validates multiple enterprise business applications in a fast-moving Agile environment. The Quality Engineering group combines manual testing, data validation, API testing, and automation to ensure applications and underlying data meet established quality standards. The role spans a diverse portfolio of applications and user stories rather than a single product. It offers structured knowledge transfer, established QA practices, and mature automation frameworks, while requiring ownership, rapid learning, and independent application of standards. This is a hybrid role with four days per week onsite and an approximately six-month contract engagement, with periodic extension reviews based on business needs. The engineer will work across data automation, API testing, UI automation, and CI/CD-integrated testing, using technologies that may include Azure DevOps, data-validation platforms, API automation tools, UI automation solutions, and AI-assisted development tools.
Requirements
- 3–5 years of Quality Assurance experience within technical software environments.
- Strong hands-on SQL expertise, including joins, multi-table queries, database investigation, and source-to-target validation.
- At least 3 years of data integration, ETL, or database testing experience.
- At least 3 years of API testing experience.
- Strong understanding of API authentication, payloads, parameters, responses, and database validation.
- Hands-on experience creating automated test scripts, rather than solely executing existing automation.
- Understanding of test automation frameworks, reusable components, and automated execution through CI/CD pipelines.
- Experience working with Azure DevOps or comparable test-management and delivery platforms.
- Ability to understand an established testing framework and become productive without continuous hand-holding.
- Strong attention to documentation, QA standards, test-case structure, and process consistency.
- Ability to independently investigate unfamiliar systems and ask focused questions when additional guidance is needed.
- Comfort shifting between multiple applications, datasets, and testing priorities within an Agile sprint.
- Collaborative, adaptable, curious, and accountable working style.
Nice To Haves
- Experience with QuerySurge, SOAtest, UiPath, C#, Azure DevOps pipelines, or similar technologies.
- Experience building or enhancing automation frameworks.
- Exposure to GitHub Copilot or similar AI-assisted development/testing technologies.
Responsibilities
- Develop and maintain automated and manual test cases across multiple enterprise applications.
- Translate business requirements and source-to-target mapping documents into SQL queries to validate application and data behavior.
- Perform database and ETL validation using complex SQL, including joins across multiple tables.
- Test APIs by evaluating definitions, authentication mechanisms, parameters, payloads, responses, and underlying database results.
- Develop automation scripts and reusable testing components within established automation frameworks.
- Execute automated testing through CI/CD pipelines and understand how automated tests fit into the broader delivery lifecycle.
- Maintain accurate, consistently structured test cases and QA artifacts within Azure DevOps.
- Move effectively between different applications and types of user stories within the same Agile sprint.
- Learn existing frameworks, processes, and internal tools quickly while applying established QA standards.
- Participate in Agile refinement, testing, troubleshooting, peer reviews, and continuous improvement initiatives.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Senior
Education Level
No Education Listed
