Software QA Engineer I, Database Validation at TransCore in Nashville, TN

Job description

• TransCore (TRN), a subsidiary of ST Engineering, is seeking a detail-oriented QA Engineer I to join 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.

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, 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.

Requirements

• 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 DevOps for test case management, work item tracking
• Strong analytical, problem-solving, and debugging skills with attention to detail.
• Excellent communication skills to collaborate with developers, analysts, and stakeholders.
• Ability to manage multiple priorities and work effectively in a fast-paced environment.
• 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.

Skills

Required

• Strong proficiency in SQL
• Data validation and data integrity
• Data simulation
• Attention to detail
• Excellent communication skills

Preferred

• Data warehousing concepts
• CI/CD pipelines and DevOps practices
• Playwright with C#
• ISTQB or other QA-related certifications