APPSTEK INFORMATION SERVICES PRIVATE LIMITED

We are seeking a skilled and detail-oriented Functional & Database Test Engineer with 5-8 years of experience to join our QA team in the mortgage technology domain. The ideal candidate will have strong expertise in manual testing, database and XML validation, and experience with automation frameworks using Java, Selenium, and Python. You'll play a key role in ensuring the accuracy, stability, and compliance of our mission-critical mortgage systems-ranging from loan origination to servicing platforms. Design and execute test cases for key mortgage workflows (e.g., loan origination, underwriting, document validation, compliance checks) Validate backend mortgage data through SQL queries and XML structures across various systems (e.g., LOS, CRM, underwriting engines) Analyze API responses and errors related to mortgage data and services (e.g., credit pulls, income verification, disclosures) Perform patch testing and production release testing in high-availability environments Develop and maintain automated tests using Java/Selenium for UI, and Python for backend/API scripting Customize and enhance test automation frameworks to align with mortgage business needs Participate in Agile ceremonies, work closely with developers, product managers, and business teams to understand functional requirements Use Azure DevOps (ADO) for managing test plans, test execution, and tracking defects Integrate test suites into CI/CD pipelines via Jenkins and support continuous testing Provide demos/presentations on test deliverables and ensure stakeholder visibility Maintain high test coverage and documentation to support mortgage compliance and audit needs. 5-8 years of experience in QA, with solid background in STLC, manual testing, and automation Strong understanding of mortgage domain workflows and terminology (LOS, AUS, disclosures, compliance, etc.) Proficient in SQL for database testing and XML validation Solid understanding of API testing, including error handling and request/response verification Hands-on experience with UI automation using Java Selenium and Python scripting Familiar with Azure DevOps (ADO) for test management and issue tracking Knowledge of defect lifecycle, test case preparation, regression, and smoke testing Experience with CI/CD tools like Jenkins for test integration Strong communication and collaboration skills to work with cross-functional teams Ability to work independently and take full ownership of testing responsibilities. Experience with mortgage LOS platforms (e.g., Encompass, ICE Mortgage Tech, Calyx) Understanding of regulatory compliance requirements (e.g., CFPB, FHA, Fannie Mae/Freddie Mac) Exposure to performance testing and test data management tools (ref:hirist.tech)