Applied with 2 referrals. 30 min quick phone screening. Second round Python and SQL OA. Third round unstructured case study and SQL questions. Final round includes a 1 hour structured case study and 45 min behavioral. Case studies do not require much prep in my opinion and are very conceptual. However, your interviewer does matter. As a native English speaker, I had a very hard time understanding my final case study interviewer and believe my clarifying questions might've been the rejection.
Difficult interview
Application
I applied through university. I interviewed at ZS Associates in Sept 2023
Interview
There was an aptitude round in mettle platform consisting of 6 parts ranging from logical to quant etc. The second round was to check verbal ability of a person and third was a sql specific round where you have write 2 sql query one programming question and some Mcqs related to sql. And the last round was Interview. It was a Technical+ Behavioural round. Although mine was more on a Behavioural part.
Interview questions [1]
Question 1
Introduction about yourself Proficiency in sql and programming language Guesstimate question related to fuel wasted in a day due to construction of metro in Pune
I applied through an employee referral. I interviewed at ZS Associates (London, England)
Interview
A total of 3 rounds, consisting of Aptitude as R01. 2nd round consisted of solving SQL questions and a few multiple-choice questions. Final round with an employee where past projects, experience, DSA, and guess estimates were asked.
Interview questions [1]
Question 1
Past projects and experience in the respective field.
I applied through university. The process took 1 day. I interviewed at ZS Associates (Bengaluru) in Oct 2025
Interview
So there was a SQL and resume-based questions for the first round .
i was asked questions based on my project and then there was SQL question like Q1) give me the list of employees whose salary is greater than manager salary
Q2)nth highest salary without using the offset method
and last there was a puzzle
the 1 heaviest ball among 8 balls question (Classic interview question )
and a guestimation asking how many people use BMTC bus in a given day
Interview questions [1]
Question 1
Q1) give me the list of employees whose salary is greater than manager salary
Q2)nth highest salary without using the offset method
and last there was a puzzle
the 1 heaviest ball among 8 balls question (Classic interview question )
and a guestimation asking how many people use BMTC bus in a given day
