Functional & Database Testing – QA Engineer / Senior QA Analyst

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 exception 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 behavior; 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.