Software QA Engineer I, Database Validation

Essential Duties and 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.

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 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.
• Able 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.