What are the responsibilities and job description for the Test Lead - DB and API Testing, on-site in Cleveland OH- Full-time position at Ztek Consulting?
Role: Test Lead - DB and API Testing, on-site in Cleveland OH- Full-time
Job description: 429589/-KVK
Experience Required: 7 to 15 Years
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
Salary Range - $90,000-$110,000 a year
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary : $80,000 - $110,000