Student 7's Barclays Interview Experience

Interview Experience

Projects discussion, ML/DL concepts, DBMS queries, and coding problems

Good number of questions from projects
Machine learning project - Detail out CNN architecture
Difference between CNN and RNN
Rate yourself in the subjects in which you are strong
Why did you prefer ReactJS over NodeJS for one of your projects?
List the new features which stand out in your projects
DBMS: Given two tables, find out how many records would be fetched after performing inner join and right outer join
DBMS: Library Management system - Query formulation to retrieve books that were borrowed from given date, up to previous 10 days
Coding: Find the transpose of a matrix
Coding: Find the frequency of all elements in an array, and also print the element with highest frequency

Behavioral and situational questions focused on workplace scenarios and challenges

Your colleague, who is your thick friend, has disrupted your code for the project, a day before you have to be presenting it, due to personal reasons (quarrel/misunderstanding). What would you do?
After you have joined the company as a fresher, you are not allotted to any project (you are still on the bench, just doing tracing, checking and JIRA activities on other projects, rather than being part of a real-time project development team), and this situation continues for long. At this time, assume you are getting good offer from another big tech giant. Will you immediately quit from the current company?
Your colleague slaps you suddenly in the workplace. What will be your reaction?
What has been the greatest challenge/difficulty for you?

Be prepared for deep dive into all projects mentioned in resume
If you use CNN in ML projects, know the complete architecture in detail
Understand the difference between CNN and RNN clearly
Be ready to justify technology choices (ReactJS vs NodeJS, etc.)
Practice SQL joins thoroughly - inner join, outer joins, and record counting
Practice date-based SQL queries for real-world scenarios
Know basic matrix operations and array manipulation coding problems
Prepare for extreme workplace scenario questions - stay calm and professional
Think through career decisions carefully - don't give impulsive answers about quitting
Show maturity in handling conflicts and difficult situations