🎯 My Barclays Internship Interview Experience

Hello! Myself Samarth Mali, final year student at PICT, Pune.
I am doing an internship at Barclays. Here, I will share my interview experience and story about how I got into Barclays.

Barclays came to our college around the 2nd week of September 2023 for the Technology Summer Intern post during the on-campus internship drive.

---

📌 Barclays Selection Process

Barclays conducted two rounds:

1. OA - Online Assessment Round
2. Interview Round

---

🖥️ Round 1: Online Assessment

The OA round was conducted online on the company-specific portal. It was an online test, but due to college and company norms, students had to give the test on college computers.
Duration: 2 hours
Test Structure: 20 MCQs + 5 SQL Queries

📌 Topics Covered in MCQs:

• C++ Code Snippets
• Java Code Snippets
• C++/ Java Theory Questions (OOP Based Mostly)
• DSA
• DBMS
• CNS
• OS

MCQs were simple but tricky at the same time.

On the other hand, SQL Queries were quite logical-based. Five questions were given, and students were supposed to write and execute SQL queries in the provided SQL Query Runner.

📌 Key SQL Concepts Required:

• Statements
• Clauses
• Operators
• Aggregate Functions

---

🏆 Round 2: Interview Experience

On the day of the interview, we had a PPT Talk from the Barclays Interview Panel.
A copy of our resumes was already provided to the Interview Panel.
I had to wait till afternoon until it was my turn for the interview.

🔹 Interview Process

1️⃣ First, I introduced myself to the interviewer, mentioning my academics, technical stack, domain of interest, and extra-curricular activities.
2️⃣ The interviewer had my resume and started asking questions based on it.

📌 Technical Questions Topics:

• Web Development
• React DOM
• NodeJS
• Asynchronous and Non-blocking I/O features of JS
• DBMS
• SQL Query
• PL/SQL Concepts
• Indexes, Triggers, Joins
• MongoDB
• DSA
• Real-world application of DSA
• Previous projects

📌 HR Questions Topics:

• Club-related activities
• Team Coordination
• Team Management
• My biggest challenges
• My strengths and weaknesses
• Situation-based questions
• Barclays-related questions like Why do you want to join Barclays? and Barclays Values (RISES)

At the end of the interview, I also asked a few questions to the interviewer.
The interview lasted around 1 hour.

📢 On the same evening, results were declared, and I was selected! 🎉

---

📚 Preparation Tips

✅ Revise the following topics thoroughly:

1. DBMS (Most important)
2. DSA
3. CNS
4. Java Multithreading
5. OS

✅ Have complete knowledge of your project—not just the code and implementation but also how the technology works.

✅ Research the company's values, principles, and current work in technology.

All the best with your preparation and test! 🚀