Barclays Software Engineer(Internship) interview questions

In the first round, I was given a technical test that consisted of 14 questions in total. The questions were spread across various topics, including: • 10 MCQs on OOPs concepts, primarily based on Java. • 2 MCQs on SQL, covering the basics of database queries. • 1 SQL Query where I had to write a query to run a specific function. • 1 DSA problem, which was focused on coding using strings. The overall difficulty level of the questions was from easy to medium, making it manageable if you have a good grasp of the fundamentals. In the second round, there was a one-on-one technical interview where I was asked the following questions: • Explain the time complexity of different sorting algorithms. • Discuss the usage of Hashmaps and Dictionaries, and when it is appropriate to use them. • Explain the four pillars of OOP (Abstraction, Encapsulation, Inheritance, Polymorphism) with examples. • Write and explain a query using SQL JOINs, including INNER JOIN and LEFT JOIN. • Why Barclays? What do you think we do here? • How do you manage stress and prepare yourself to work under tight deadlines? I also had to describe a past situation where I faced a similar challenge and how I handled it. • They asked a few questions related to the projects I mentioned in my resume.

Role and stipend was good. started with intro but i flunked the intro. after that we went on to talk about my projects and few dbms questions and basic python questions. then my interests, hobbies. delved deep into my passion and eventually told me about himself and what they expect in the role