Test Lead - DB and API Testing

Northern Base; Cleveland (OH); On-site; USD 90,000 - 120,000; Full time

Job summary

Northern Base in Cleveland, OH is seeking a skilled Test Lead to own end-to-end QA for database and API integrations within Finastra Loan IQ. You will design tests, write complex SQL queries, validate ledger entries, and ensure backend accuracy matches front-end actions.

The role requires hands-on experience with REST and SOAP APIs, API automation, and familiarity with Jira/Zephyr, CI/CD basics, and agile ceremonies.

Qualifications

• Minimum 2–4 years of hands-on QA experience in Finastra Loan IQ.
• Core knowledge of the Loan IQ Data Model, tables, and schema.
• Strong understanding of the commercial loan lifecycle, including syndicated/bilateral loans, drawdowns, fee management, accruals, and repayments.
• Advanced SQL scripting skills (complex joins, subqueries, aggregations, data profiling).
• Backend data validation for CRUD operations and transactional integrity.
• Experience with Oracle SQL or MS SQL Server.
• ETL testing experience (source-to-target mapping validation).
• Knowledge of database performance optimization or stored procedures.
• RESTful and SOAP API testing using Postman or SoapUI.
• API test automation using RestAssured (Java) or Python requests.
• SDLC/STLC, and bug life cycle tracking in Jira/Zephyr.
• Manual and automated regression testing experience.
• Basic automation framework knowledge with Java/Selenium or Python.
• Basic exposure to CI/CD triggers (Jenkins, GitLab CI, or GitHub Actions).

Responsibilities

• Test Design & Planning: Design, write, and execute test cases mapped to business specs for commercial lending workflows in Loan IQ.
• Database & Integrity Validation: Run complex SQL queries against Loan IQ DB to validate ledger entries and balances.
• API Testing: Validate system integrations, APIs, and microservices powering Loan IQ, using manual or automated tools.
• Defect Lifecycle Management: Document and track defects in Jira, collaborate to reproduce, troubleshoot, and resolve issues.
• Agile Participation: Participate in Sprint ceremonies to maintain quality gates throughout.

Skills

QA Testing

SQL Scripting

API Testing

LoanIQ Knowledge

Jira/Zephyr

Tools

Postman

SoapUI

RestAssured

Selenium

Python Requests

Job description

Job Description

Skill: Test Lead - DB and API Testing

Must Have Technical/Functional Skills:

Domain & Platform:

• Minimum 2 4 years of hands-on QA experience in Finastra Loan IQ
• . Core knowledge of the Loan IQ Data Model, tables, and schema
• . Strong functional understanding of the commercial loan lifecycle, including syndicated/bilateral loans, drawdowns, fee management, accruals, and repayments

Database Testing:

• Advanced SQL scripting skills (complex joins, subqueries, aggregations, data profiling)
• . Backend data validation for CRUD operations and transactional integrity
• . Experience working with relational databases like Oracle SQL or MS SQL Server
• ETL testing experience (source-to-target mapping validation)
• . Knowledge of database performance optimization or stored procedures.

API Testing:

• Robust hands-on experience in testing RESTful and SOAP APIs using Postman or SoapUI
• . Validation of API status codes, response payloads, headers, error handling, and authorization tokens
• API test automation using RestAssured (Java) or Python requests

QA Methodology & Automation:

• Strong understanding of SDLC, STLC, and bug life cycle tracking in Jira or Zephyr
• . Manual and automated regression testing experience.
• Basic hands-on automation framework knowledge utilizing Java / Selenium WebDriver or Python
• . Basic exposure to CI/CD pipeline triggers (Jenkins, GitLab CI, or GitHub Actions)

Roles & Responsibilities:

• Test Design & Planning: Design, write, and execute detailed test cases mapping to business specifications for commercial lending workflows in Loan IQ
• Database & Integrity Validation: Write and execute complex SQL queries directly against the Loan IQ database to ensure backend ledger entries, balance updates, and operational configurations accurately mirror front-end actions
• API Testing: Validate system integrations, APIs, and microservices powering the Loan IQ platform using manual or automated tools
• Defect Lifecycle Management: Identify, document, and track software defects in Jira, collaborating closely with developers to reproduce, troubleshoot, and resolve issues
• Agile Participation: Actively participate in Sprint Ceremonies (Daily Standups, Backlog Grooming, Sprint Retrospectives) to ensure quality gates are maintained throughout