Test Lead - DB and API Testing
S&K GLOBAL SOLUTIONS LLC
Cleveland, OH, United States
about 2 months ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Working hours
Regular working hours
Job source
Tech stack
Java (Programming Language)
Application Programming Interfaces (APIs)
Agile Methodology
JIRA
Automation of Tests
Databases
Continuous Integration
Data Validation
Extract Transform Load (ETL)
Data Mapping
Data Profiling
Relational Databases
+27 more
Database Testing
Github
Python (Programming Language)
Microsoft SQL Server
Oracle SQL Developer
Scrum Methodology
Systems Development Life Cycle
Regression Testing
SoapUI
SQL Stored Procedures
SQL Databases
Software Testing Automation Framework
Systems Integration
Scripting
Freeform SQL
Postman
ReadyAPI
SOAPAPI
Database Performance
Backend
Gitlab-ci
Restful APIs
Selenium Webdriver
Api Management
Jenkins
Crud
Microservices
Job description
- 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
Requirements
- 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)
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦