---
title: Barclays Interview Questions & Process (2026)
description: Real Barclays interview questions for freshers and laterals — the online assessment, the Java and SQL technical round, the values round, and a prep plan.
url: https://usegreenroom.app/blog/barclays-interview-questions
last_updated: 2026-07-17
---

← Back to blog

Companies

# Barclays interview questions and process

July 17, 2026 · 10 min read

![Barclays interview questions — cover from Greenroom, the AI mock interviewer](/assets/blog/barclays-interview-questions-hero.webp)

A candidate I'll call Sneha spent six weeks grinding LeetCode mediums for her Barclays Pune interview. Graphs, DP, the works. The interviewer opened with: "What's the difference between DELETE, TRUNCATE and DROP?" Then: "Walk me through the database schema of your final-year project." Then, gently: "Which Barclays value do you connect with most?" Sneha knew binary lifting. She did not know Barclays had values. She'd prepared brilliantly — for a completely different movie.

That's the thing to understand about **Barclays interview questions**: the bank's technology centres in Pune and Chennai hire thousands of engineers, and the loop is *broad*, not deep. The coding bar is moderate; the differentiators are SQL written live, database and OS fundamentals explained out loud, an honest grilling on your projects, and a values round most candidates don't know exists. I built Greenroom after freezing in an interview I'd "prepared" for in exactly this lopsided way — all algorithms, no answers for the questions actually asked. This guide covers the real **Barclays interview process** for freshers and laterals: the online assessment, the technical rounds, the values round, and a prep plan that matches the actual weightings.

## The Barclays interview process

For campus and graduate technology roles (the analyst intake most Indian freshers enter through), candidates consistently report three stages after the application:

- **Online assessment** — logical and quantitative aptitude plus one to three coding problems, easy-to-medium difficulty.
- **Technical interview (one or two rounds)** — Java/Python fundamentals, SQL queries written live, DBMS and OS basics, and a long walkthrough of your projects.
- **Professional-fit / HR round** — behavioral questions mapped to Barclays' published values, plus motivation and logistics.

Lateral hiring follows the same skeleton with a hiring-manager discussion added, and a system-design conversation for senior roles. The pattern across every stage: **breadth beats depth**. Nobody fails Barclays on a hard algorithm; people fail it on a JOIN they couldn't write, a project they couldn't defend, or a values question they'd never considered. Barclays' own early-careers site describes the values-based assessment openly — it's the most ignored piece of free syllabus in banking interviews.

![Barclays interview process for freshers — online assessment, technical rounds, values-based professional fit round](/assets/blog/barclays-interview-questions-diagram.webp)
*The Barclays loop is broad, not deep — each stage filters on a different axis.*

## The online assessment

The **Barclays online assessment** is the widest filter, and candidates report a consistent shape:

- **Aptitude** — logical reasoning and quantitative questions under time pressure; nothing exotic, but the clock is real.
- **Coding** — one to three problems on arrays, strings and hash maps, occasionally a simple DP problem. Easy-to-medium; partial marks for passing test cases are common, so a clean brute force beats a broken optimal solution.

If you've done a season of campus OAs this will feel familiar — our [aptitude test preparation guide](/blog/aptitude-test-preparation-placements) covers the reasoning section, and the coding section sits well below the bar of the product-company OAs covered in our [DSA preparation guide](/blog/dsa-coding-interview-preparation-india).

## Technical interview questions

This is where Sneha's movie went off-script. The technical rounds are a fundamentals tour, and **SQL is the star** — this is a bank; the data layer is the job. Recurring questions, per candidate reports across Glassdoor and GeeksforGeeks experiences:

- **SQL, written live:** second-highest salary, department-wise top earners, duplicate detection, the difference between `WHERE` and `HAVING`, and JOIN types with a worked example.
- **DELETE vs TRUNCATE vs DROP** — and which ones can be rolled back.
- **Java/Python OOP:** the four pillars with real examples, abstract class vs interface, `HashMap` internals, exception handling, `String` immutability.
- **DBMS and OS basics:** ACID properties, normalization to 3NF, indexing, deadlocks, processes vs threads.
- **Your projects:** schema design, why you chose your stack, what breaks under load, what you'd redo.

The classic SQL question, answered the way the interviewer hopes:

```sql
-- Second-highest salary: the answer everyone gives
SELECT MAX(salary) FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);

-- The follow-up they actually care about: window functions
SELECT name, salary
FROM (
  SELECT name, salary,
         DENSE_RANK() OVER (ORDER BY salary DESC) AS rnk
  FROM employees
) ranked
WHERE rnk = 2;
```

> **The core truth:** Barclays' technical round is a fundamentals interview wearing a coding interview's clothes. The candidates who clear it comfortably are the ones who can explain ACID out loud, write a windowed SQL query without a syntax check, and defend their project's schema — our [SQL interview questions guide](/blog/sql-interview-questions) and [Java interview questions guide](/blog/java-interview-questions) cover exactly this layer.

## The values and behavioral round

Barclays publicly anchors hiring to five values — **Respect, Integrity, Service, Excellence and Stewardship** — and the professional-fit round asks you to evidence them with real stories, not recite them:

- **Tell me about a time you helped a teammate at cost to yourself.** (Respect / Service)
- **Tell me about a mistake you owned up to before anyone noticed.** (Integrity)
- **Tell me about something you improved that nobody asked you to.** (Excellence / Stewardship)
- **Why banking technology, and why Barclays specifically?**

Interviewers here will sometimes ask outright which value your story maps to — which instantly separates candidates who looked the values up from candidates hearing them for the first time. Prepare five short stories, one per value, structured the way our [HR interview questions guide](/blog/hr-interview-questions-answers) lays out. This round is spoken, not written, and rambling is the main failure mode.

## LeetCode, GeeksforGeeks, ChatGPT — where each fits

An honest map of the usual prep stack against this particular loop:

- **LeetCode** — worth a few weeks of easies and mediums for the OA; past that, you're over-investing in the least differentiating stage. Sneha's error, quantified.
- **GeeksforGeeks interview experiences** — genuinely useful for Barclays, since the loop is stable year to year; read five recent experiences and the question distribution above will jump out at you. Anecdotes, not a syllabus.
- **SQL practice platforms** — the highest-ROI hours in the whole prep; you need to *write* queries cold, not recognize them.
- **ChatGPT** — good for generating "explain ACID to me like an interviewer" drills and mock values questions; it won't notice you rambling for three minutes or ask the follow-up a bored human would.
- **Greenroom** — the spoken layer. [Ari, the AI interviewer](https://usegreenroom.app/), runs voice mocks on fundamentals and behavioral questions with real follow-ups, and grades how clearly you structure answers — which is most of what the Barclays technical and values rounds are actually scoring. It won't replace SQL reps; pair it with them.

## How to prepare for the Barclays interview

- **Week 1: SQL until it's reflex.** Joins, GROUP BY/HAVING, subqueries, window functions — write thirty queries by hand, no autocomplete.
- **Week 2: fundamentals out loud.** OOP pillars, ACID, normalization, indexing, deadlocks, processes vs threads — explain each in under ninety seconds, spoken, because that's the format they're graded in.
- **Week 3: projects and values.** Rehearse your project walkthrough including the schema and the "what breaks at scale" answer; write one short story per Barclays value.
- **Final week: OA drills plus one full spoken mock** covering a SQL question, a fundamentals chain, and two values questions back to back. If you're interviewing across banks, the loops rhyme — our [JPMorgan interview questions guide](/blog/jpmorgan-interview-questions) and [Goldman Sachs interview questions guide](/blog/goldman-sachs-interview-questions) map the neighbouring territory.

## Frequently asked questions

### What questions are asked in a Barclays interview?

For technology roles, expect Java or Python fundamentals (OOP, collections, exception handling), SQL queries written live (joins, GROUP BY, second-highest salary, window functions), DBMS and OS basics, a deep walkthrough of your projects, and behavioral questions mapped to Barclays' values — Respect, Integrity, Service, Excellence and Stewardship.

### How many rounds are there in the Barclays interview process?

Campus and graduate hiring typically runs three stages after the application: an online assessment (aptitude plus coding), one or two technical interviews, and a professional-fit or HR round covering values and motivation. Lateral hiring adds a hiring-manager discussion and sometimes a system-design conversation for senior roles.

### What is the Barclays online assessment like?

Candidates report a mix of logical and quantitative aptitude questions plus one to three coding problems of easy-to-medium difficulty — arrays, strings, hash maps, and occasionally a simple dynamic-programming problem. Clean, working code matters more than an optimal solution, and partial marks for passing test cases are common.

### Is the Barclays interview difficult for freshers?

It's moderate — the coding bar is below a FAANG or top-product-company loop, but the interview is broader than most freshers expect: SQL written live, DBMS and OS fundamentals explained out loud, and a genuine grilling on your final-year project. Candidates who only prepared DSA get caught by the breadth, not the depth.

### What are the Barclays values asked about in interviews?

Barclays publicly anchors its hiring to five values — Respect, Integrity, Service, Excellence and Stewardship. The behavioral round asks you to evidence them with real stories: a time you helped a teammate, a time you owned a mistake, a time you improved something nobody asked you to. Generic answers stand out badly here because interviewers ask which value your story maps to.

### Does Barclays ask DSA and coding questions?

Yes, but at a moderate bar — easy-to-medium array, string and hash-map problems in the online assessment, and sometimes a live problem in the technical round. The differentiators are usually SQL fluency, database fundamentals, and how clearly you explain your projects, not hard algorithmic tricks.

---

Barclays' loop is won on breadth: SQL without a safety net, fundamentals explained out loud, and values stories that don't ramble. [Greenroom](https://usegreenroom.app/) runs spoken mock interviews with Ari covering exactly that mix, with feedback on every answer. Free to start. New to voice practice? Here's [what an AI mock interview is and how it works](/blog/ai-mock-interview).