Description:
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.
Business Skills:
- Communicates effectively through various channels
- Works effectively with business SMEs and facilitates conversations efficiently
- Manages their 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
- Hands on experience with test planning, progress tracking, defect tracking, expected results
- Ability to collaborate with analysts, data engineers, developers, and business stakeholders to troubleshoot issues, document findings, and recommend corrective actions.
- 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
- Test tracking and reporting
- 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