Functional & Database Testing – QA Engineer / Senior QA Analyst

DWI Consulting; Greater London; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

DWI Consulting in London is seeking an experienced QA professional focused on functional and database testing. The role involves validating complex financial workflows, backend data, and system integrations to ensure data accuracy and reliable application delivery.

You will design test scenarios, execute comprehensive test plans, and collaborate with analysts, developers, and product owners in an Agile setting. Hybrid work and exposure to finance operations are key aspects of this opportunity.

Qualifications

• Proven hands-on experience in manual functional testing and database testing across enterprise apps.
• Strong SQL skills for complex data validation, joins and aggregations.
• Experience with test design, defect lifecycle, and Agile/Scrum methodologies.
• Ability to translate requirements into effective test scenarios and support UAT.

Responsibilities

• Analyze requirements and data mappings to define test scenarios and acceptance criteria.
• Design, execute and maintain test plans, cases and data for various testing levels.
• Perform functional, integration, regression, and end-to-end testing across systems.
• Write and run SQL queries to validate backend data and calculations.
• Conduct source-to-target data reconciliation and validate data integrity.

Skills

Manual functional testing

Database testing

SQL proficiency

Test planning

Agile Scrum

UAT support

Stakeholder collaboration

Problem solving

Education

Bachelor's or Master's degree in Engineering, Computer Science, Information Technology, or a related discipline

Tools

Jira

Azure DevOps

Job description

Functional & Database Testing – QA Engineer / Senior QA Analyst

Location: London and Hybrid

Domain: Financial Services | Investment Management | Capital Markets

The Opportunity

We are looking for an experienced QA professional with strong functional testing, database testing, and SQL expertise to ensure the quality, reliability, and data accuracy of financial applications. The ideal candidate will have hands‑on experience validating complex business workflows, backend data, system integrations, and financial calculations.

You will collaborate with Business Analysts, Developers, Product Owners, and business stakeholders to deliver high-quality solutions aligned with business requirements.

What You'll Do

• Analyze business requirements, functional specifications, user stories, and data mappings to define comprehensive test scenarios and acceptance criteria.
• Design and execute test plans, test cases, and test data covering positive, negative, boundary, and exceptional scenarios.
• Perform functional, system, integration, regression, smoke, sanity, and end‑to‑end testing across applications and business workflows.
• Write and execute complex SQL queries using joins, subqueries, aggregations, and conditional logic to validate backend data, calculations, and business rules.
• Conduct source‑to‑target data reconciliation, validating data accuracy, completeness, transformations, and integrity across integrated systems.
• Validate financial workflows related to portfolio management, investment operations, trading, cash management, compliance, and risk.
• Investigate functional and database issues using application logs, SQL queries, and system behaviour; document, track, and retest defects.
• Maintain requirement traceability, test execution results, defect reports, and quality metrics while highlighting risks and blockers.
• Support UAT, defect triage, release validation, and continuous improvement of QA processes.
• Collaborate with cross‑functional Agile teams to ensure timely delivery of reliable, business‑critical applications.

What You Bring

• Bachelor's or master's degree in Engineering, Computer Science, Information Technology, or a related discipline.
• Proven hands‑on experience in manual functional testing and database testing, including end‑to‑end validation of enterprise applications.
• Mandatory domain knowledge in at least one of: Financial Services, Investment Management, Portfolio Management, Portfolio Construction, OCIO, Trading, Cash Management, Compliance, Risk, or Capital Markets.
• Strong SQL proficiency, including joins, subqueries, GROUP BY, aggregate functions, and complex data validation queries.
• Experience with relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL, including database structures, relationships, constraints, and transactions.
• Hands‑on experience in source‑to‑target reconciliation, data integrity testing, financial calculations, and validation across applications, databases, and reports.
• Strong understanding of SDLC, STLC, test design techniques, defect lifecycle, and Agile Scrum methodologies.
• Experience with Jira, Azure DevOps, or similar test management and defect tracking tools.
• Ability to translate business requirements into effective test scenarios, identify defects, perform root‑cause analysis, and support UAT.
• Excellent analytical, problem‑solving, communication, and stakeholder collaboration skills.

Good to Have

• Experience testing stored procedures, ETL processes, data migrations, or data warehouse workflows.
• Exposure to API testing using Postman, Bruno, or similar tools.
• Familiarity with functional test automation frameworks such as Selenium or Playwright.
• Experience with financial reporting, portfolio analytics, investment accounting, or complex financial data integrations.

What Makes You a Great Fit

You combine strong functional testing capabilities, advanced SQL/database validation skills, and financial domain expertise. You are detail‑oriented, analytical, and comfortable working across business and technical teams to identify issues, validate complex data, and ensure high‑quality application delivery.