Tester

About the role

Ensures the accuracy, integrity, and reliability of data across systems and processes. This role involves designing and executing test plans, validating data transformations, and identifying discrepancies between source and target datasets.

Responsibilities

• Designing and executing test plans
• Validating data transformations
• Identifying discrepancies between source and target datasets
• Collaborating with analysts, data engineers, developers, and business stakeholders to troubleshoot issues, document findings, and recommend corrective actions
• Test tracking and reporting
• Test script construction and execution (including script structure, components, expected results, defect tracking, approval processes)

Requirements

• Minimum 3‑5 years of testing experience working in Data and Analytics projects
• Minimum 5 years working experience with SQL
• Minimum 2 years working in MS Azure environments and defects management using Azure DevOps and SQL database
• Knowledge of Mortgage Industry, Single Family and Multi‑Family preferred
• Intermediate/Advanced Microsoft Office Suite of Tools
• Intermediate Azure DevOps defect management
• SQL Intermediate to advanced knowledge
• SQL Server Data Management Studios (navigation, read/write/execute queries)
• SQL Server Reporting Services (navigate reports as read‑only)
• Microsoft PowerBI (navigate and filter reports as read only)
• Intermediate testing data validation, test execution, regression testing
• Significant experience in test script construction and execution including script structure and components, expected results, defect tracking, approval processes

Skills

• Communicates effectively through various channels
• Works effectively with business SMEs and facilitates conversations efficiently
• Manages time effectively with the ability to proactively seek prioritization
• Strong analytical skills, attention to detail, and proficiency in SQL and data validation tools
• Solid foundation of application and data testing strategies, concepts, and documentation
• Ability to collaborate with analysts, data engineers, developers, and business stakeholders to troubleshoot issues, document findings, and recommend corrective actions