At a Glance
- Tasks: Ensure quality and reliability of financial applications through functional and database testing.
- Company: Leading financial services firm with a focus on innovation and collaboration.
- Benefits: Hybrid work model, competitive salary, and opportunities for professional growth.
- Other info: Collaborative Agile environment with excellent career advancement opportunities.
- Why this job: Join a dynamic team to make an impact in the financial sector with your QA expertise.
- Qualifications: Experience in functional testing, SQL proficiency, and knowledge of financial services.
The predicted salary is between 63000 - 77000 £ per year.
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, Postgre SQL, or My SQL, 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 Dev Ops, 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.
#J-18808-Ljbffr
Functional & Database Testing – QA Engineer / Senior QA Analyst in London employer: Dwi Consulting
As a leading employer in the tech industry, we offer our Technical Solutions Architects a dynamic work environment that fosters innovation and collaboration. Our commitment to employee growth is evident through continuous learning opportunities and hands-on experience with cutting-edge technologies like cloud-native solutions and AI. Located in a vibrant area, we provide a flexible work arrangement that supports a healthy work-life balance, making us an attractive choice for professionals seeking meaningful and rewarding careers.
StudySmarter Expert Advice🤫
We think this is how you could land Functional & Database Testing – QA Engineer / Senior QA Analyst in London
✨Join Local Tech Meetups
Get out there and mingle with fellow developers by joining local tech meetups. It’s a fantastic way to meet people who might be working at Dwi Consulting or know someone who does. Plus, you can pick up some trendy tech skills and trends while you're at it!
✨Contribute to Open Source Projects
Show off your coding chops by jumping into open-source projects. Not only does this give you practical experience, but it also gets you noticed in the dev community. You'll create a killer portfolio that speaks volumes about your skills to Dwi Consulting.
✨Tap into Online Developer Communities
Don’t underestimate the power of online developer communities like GitHub, Stack Overflow, and even Reddit. Participate in discussions, share your projects, and build your visibility. We can often find opportunities through these channels that can lead to a full-time gig at companies like Dwi Consulting.
✨Explore Job Boards Specifically for Tech Roles
Keep your eyes peeled on job boards that focus on tech roles. Sites like TechCareers or Stack Overflow Jobs can often have listings for companies like Dwi Consulting that might not show up on broader job sites. Make it a habit to check these regularly, and don’t hesitate to apply directly through our website!
We think you need these skills to ace Functional & Database Testing – QA Engineer / Senior QA Analyst in London
Some tips for your application 🫡
Show off your coding skills:When applying for a software engineering role, it's super important to showcase your coding skills. Make sure your CV includes your tech stack, any relevant programming languages you’re comfortable with, and examples of projects you've worked on. If you have a GitHub profile, link it up! We love to see code in action.
Tailor your portfolio:For a full-time role, we’d expect to see some solid examples of your work in your portfolio. Make sure to include at least two or three projects that highlight your problem-solving skills and your ability to work with different technologies. Focus on the projects that are most relevant to the position at Dwi Consulting.
Craft a killer cover letter:Your cover letter is your chance to stand out—make it personal! Explain why you want to work at Dwi Consulting and how your skills align with the role. Show us your passion for software development. We dig enthusiastic candidates who understand the value of collaboration and continuous learning!
Be clear and concise:When it comes to writing your CV and cover letter, clarity is key. Avoid jargon that could confuse us and stick to simple, direct language. Highlight your achievements with quantifiable results where possible, and keep everything easy to read. A well-organised application goes a long way!
How to prepare for a job interview at Dwi Consulting
✨Brush Up on Your Coding Skills
For a full-time software engineering role, it's crucial that we stay sharp with our coding abilities. Expect technical questions that might involve solving problems on the spot or discussing algorithms. Practise on platforms like LeetCode or HackerRank to get comfortable with the types of questions that often come up.
✨Know Your Tools and Frameworks
Make sure we’re well-acquainted with the tools and technologies listed in the job description. Familiarise ourselves with any specific frameworks or programming languages mentioned. If Dwi Consulting uses React or Node.js, for instance, be ready to discuss how we’ve used them in previous projects or coursework.
✨Showcase Your Projects
Bring along a portfolio that highlights our best work. This could be code samples, GitHub repositories, or any side projects we’ve built. Make sure we can talk through our thought process for each project, especially the challenges we faced and how we solved them—this shows our problem-solving skills in action.
✨Prepare for Behavioural Questions
While technical skills are key, full-time positions also require cultural fit. Be ready to discuss our previous experiences and how we handle teamwork, conflict, and deadlines. Brush up on the STAR method—Situation, Task, Action, Result—to clearly articulate our past experiences when discussing how we've contributed to a team.
