Leading International Technology company is currently seeking a QA professional with hands-on functional and Oracle database testing experience to help deliver reliable applications and accurate data. The role involves understanding business requirements, testing application features and workflows, and validating backend data using SQL. You will work closely with business analysts, developers, and business users to identify issues early and ensure the application meets business needs.
Day to day responsibilities:
- Analyze business requirements, functional specifications, user stories, and data mappings; clarify business rules, dependencies, and acceptance criteria with stakeholders.
- Prepare test plans, scenarios, cases, and test data covering business workflows, positive and negative paths, boundary conditions, and exception handling.
- Execute smoke, sanity, system, integration, regression, and end-to-end testing to validate complete workflows across connected applications.
- Write SQL queries using joins, subqueries, and aggregate functions to validate records, calculations, and business rules against expected results.
- Reconcile data between source and target systems; identify missing, duplicate, incorrect, or inconsistent records and validate transformation rules.
- Investigate failures using application behavior, logs, and database records; report defects with clear reproduction steps and evidence, support triage, and retest fixes.
- Maintain traceability between requirements, test cases, and defects; assess change impacts and report test coverage, progress, blockers, and release risks.
- Support UAT by preparing business scenarios and validating reported issues; collaborate with product owners, business users, and developers throughout the delivery.
Requirements:
- Bachelor’s or master’s degree in engineering or a related discipline, with relevant experience in manual functional and database testing.
- Functional knowledge of finance, investments, portfolio management, portfolio construction, OCIO applications, trading, cash management, compliance, risk, or capital markets is must-have skill.
- Strong understanding of SDLC, STLC, test design techniques, defect management, and Agile Scrum delivery.
- Ability to translate business requirements and acceptance criteria into clear test scenarios, expected results, and comprehensive test coverage.
- Hands-on experience testing application features, business workflows, calculations, role-based access, and integration points.
- Experience validating data across application, reports, database tables, and integrated systems, including source-to-target reconciliation.
- Strong SQL skills, including joins, subqueries, grouping, and aggregate functions, with experience in a relational database such as Oracle, SQL Server, PostgreSQL, or MySQL.
- Practical knowledge of database tables, keys, relationships, constraints, and transactions, with the ability to investigate data integrity issues.
- Experience using Jira, Azure DevOps, or equivalent tools for test management, defect reporting, and progress tracking.
- Experience supporting UAT and working effectively with business users, business analysts, developers, and product owners.
- Strong analytical and problem-solving skills, attention to detail, clear written and verbal communication, and the ability to manage competing priorities.
- Experience testing stored procedures, ETL processes, data migrations, or data warehouse workflows is preferred
- Exposure to API testing using Postman or Bruno, or functional test automation, is an added advantage
#J-18808-Ljbffr
QA - Functional and Database Testing in London employer: Sentinel
As a global consultancy based in Central London, we pride ourselves on fostering a dynamic and inclusive work culture that prioritises employee development and well-being. Our team is dedicated to delivering impactful capital projects within the healthcare sector, offering unique opportunities for early-career professionals to gain hands-on experience and grow alongside industry experts. With a commitment to supporting your journey towards recognised project management qualifications, we ensure that our employees thrive in a collaborative environment while making a meaningful difference in the health sector.
