QA - Functional and Database Testing

Sentinel; Greater London; Vor Ort; GBP 40.000 - 65.000; Vollzeit

Zusammenfassung

Sentinel is seeking a QA professional with hands-on functional testing and Oracle database testing experience to ensure reliable applications and accurate data in our global technology platform. You will collaborate with business analysts, developers and users to translate requirements into test plans, execute end-to-end tests, and validate backend data with SQL.

You will also support UAT and drive data reconciliation across source and target systems.

Qualifikationen

• Bachelor’s or Master’s degree in engineering or related discipline.
• Hands-on experience with manual functional testing and backend data validation.
• Strong SQL skills and ability to validate data using joins and aggregates.
• Experience with Oracle or similar RDBMS and data reconciliation.
• Familiarity with SDLC, STLC, test design and defect management.
• Experience using Jira, Azure DevOps or equivalent for test management.
• Experience supporting UAT with business stakeholders.

Aufgaben

• Analyze requirements, specifications, user stories, and data mappings to define test criteria.
• Prepare test plans, test cases, and test data covering workflows and edge cases.
• Execute smoke, sanity, system, integration, regression and end-to-end tests across connected applications.
• Write SQL queries to validate records against expected results.
• Reconcile data between source and target systems and verify transformation rules.
• Report defects with clear reproduction steps and evidence, and support triage.
• Maintain traceability between requirements, tests, and defects; report coverage and release risks.
• Support UAT with business users and product owners during delivery.

Kenntnisse

Manual functional testing

SQL

Data validation

SDLC/STLC

Agile Scrum

Requirements analysis

Ausbildung

Bachelor’s or Master’s degree in engineering or related discipline

Tools

Oracle database testing

Jira

Azure DevOps

Postman

Jobbeschreibung

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