QA Engineer I: SQL & Data Integrity Automation

TransCore; Nashville (TN); On-site; USD 70,000 - 100,000; Full time

Job summary

TransCore, a subsidiary of ST Engineering, seeks a detail-oriented QA Engineer I in Nashville, TN to focus on database testing, data integrity, and complex SQL validation. You will work with cross-functional teams to validate data-driven workflow solutions and participate in Agile ceremonies.

Responsibilities include designing test plans, validating backend SQL logic, and maintaining traceable documentation.

Qualifications

• Bachelor’s or master’s in computer science, IT, or related field preferred.
• More than 5 years of QA experience.
• Strong proficiency in SQL.
• Experience with Azure DevOps for test management, defect tracking, and CI/CD.
• Experience validating complex SQL logic including conditional logic, loops, and error handling.
• Proven ability to perform data validation and ensure data integrity across large datasets.
• Experience with data simulation to exercise all execution paths of a workflow environment.
• Hands-on experience with Azure DevOps for test case management and work item tracking.

Responsibilities

• Collaborate early with Product Owners and Developers to refine user stories, acceptance criteria, and test scenarios, ensuring clear understanding of requirements and test coverage.
• Design, develop, and execute comprehensive test plans and test cases to validate SQL stored procedures, user-defined functions, tables, views, and other complex database logic.
• Analyze business and technical requirements to ensure database objects meet both functional and non-functional expectations.
• Perform backend testing by writing and executing complex SQL queries involving joins, subqueries, CTEs, and window functions to support thorough data validation.
• Conduct functional, integration, regression, and exploratory testing throughout the sprint lifecycle to ensure overall system quality.
• Ensure compliance with data standards, naming conventions, and database design best practices.
• Identify, document, and triage defects with clear reproduction steps, severity levels, and business impact, and collaborate with teams for resolution.
• Actively participate in Agile ceremonies, including backlog refinement, sprint planning, daily stand-ups, sprint reviews, and retrospectives.
• Maintain detailed and structured documentation of test scenarios, execution results, and data validation processes for traceability and reporting.
• Analyze system logs and application behavior to support defect investigation and root cause analysis.

Skills

SQL

Azure DevOps

QA Testing

Agile/Scrum

Data validation

Playwright with C#

Education

Bachelor's or Master's in CS/IT or related field

Tools

Playwright with C#

Job description

TransCore, a subsidiary of ST Engineering, seeks a detail-oriented QA Engineer I in Nashville, TN to focus on database testing, data integrity, and complex SQL validation. You will work with cross-functional teams to validate data-driven workflow solutions and participate in Agile ceremonies.

Responsibilities include designing test plans, validating backend SQL logic, and maintaining traceable documentation.