Software QA Engineer I, Database Validation

TransCore, LP in; Nashville (TN); Hybrid; USD 90,000 - 120,000; Full time

Job summary

TransCore, a ST Engineering subsidiary, is seeking a detail-oriented Software QA Engineer I focused on database validation in Nashville, TN. The role centers on validating complex datasets, writing SQL queries, and ensuring data integrity across enterprise workflow systems.

You'll work with the ARM Scrum Team, design comprehensive test plans for SQL logic, perform backend testing, and collaborate with product owners, developers and business stakeholders in an Agile environment.

Qualifications

• Bachelor’s or Master’s in Computer Science, IT, or related field preferred.
• 5+ years of experience in software quality assurance.
• Experience with Azure DevOps for test management, defect tracking, and CI/CD integration.
• Strong proficiency in SQL and data validation across complex datasets.
• Experience validating complex business logic in SQL, including conditional logic and error handling.
• Experience with automated testing using Playwright with C#.

Responsibilities

• Collaborate with Product Owners and Developers to refine user stories, acceptance criteria, and test scenarios.
• Design, develop, and execute test plans and cases for SQL stored procedures, functions, tables, views, and complex DB logic.
• Analyze requirements to ensure DB objects meet functional and non-functional expectations.
• Perform backend testing with complex SQL queries.
• Conduct functional, integration, regression, and exploratory testing during sprints.
• Ensure compliance with data standards and DB design best practices.
• Document defects with clear steps, severity, and business impact; collaborate on resolution.
• Participate in Agile ceremonies: backlog refinement, sprint planning, daily stand-ups, reviews, retrospectives.
• Maintain documentation of test scenarios, execution results, and data validation processes.

Skills

SQL

Azure DevOps

QA

Agile

Data validation

CI/CD

Playwright C#

Education

Bachelor’s or Master’s in Computer Science/IT or related field

Tools

Azure DevOps

Playwright

Job description

Software QA Engineer I, Database Validation

Job Category: Engineering

Requisition Number: SOFTW002196

• Full-Time
• Hybrid

Description

TransCore (TRN), a subsidiary of ST Engineering, is seeking a detail-oriented QA Engineer I tojoin our software development team in Nashville, TN.

Summary: This position will be heavily involved with database testing, focused on maintaining data integrity, accuracy, and consistency across enterprise workflow systems. Responsible for validating complex datasets, developing and executing SQL queries, and working closely with development and business teams to deliver reliable, high-quality data-driven workflow solutions. This position will be an assigned member of the Automation Rules Management (ARM) Scrum Team.

Essential Duties and Responsibilities: Other duties may be assigned.

• 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, Common Table Expressions (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.

Required Qualifications:

• Bachelor’s or master’s in computer science, IT, or related field preferred.
• More than 5 years of experience in software quality Assurance
• Solid experience in Quality Assurance with expertise in Azure DevOps for test management, defect tracking, and CI/CD integration, along with active participation in Agile ceremonies such as sprint planning, daily stand-ups, sprint reviews, and retrospectives.
• Strong proficiency in SQL
• Experience validating complex business logic implemented in SQL, including conditional logic, loops, and error handling.
• Proven ability to perform data validation and ensure data integrity across large and complex datasets.
• Experience using data simulation to exercise all execution paths of a workflow environment.
• Hands-on experience with Azure DevOpsfor test case management, work item tracking
• Strong analytical, problem-solving, and debugging skills with attention to detail.
• Excellent communication skills to collaborate withdevelopers, analysts, and stakeholders.
• Ability to manage multiple priorities and work effectively in a fast-paced environment.

Desired Qualifications:

• Experience with data warehousing concepts and large-scale databases.
• Knowledge of ETL tools such as Informatica, Talend, or SSIS.
• Experience with CI/CD pipelines and DevOps practices.
• Experience developing automated solutions using Playwright with C#, including scripting and maintaining scalable test frameworks.
• ISTQB or other QA-related certifications are a plus.

* No visa sponsorship is available for this position.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.