I applied online. The process took 3 weeks. I interviewed at ZS Associates (Gurgaon, Haryana) in Nov 2024
Interview
Online Test - Based on Big Data and Cloud subjects. MCQs are easy to moderate along with one SQL problem & one coding (python) problem.
Technical Round 1 - SQL based questions majorly starting with easy then moving to moderate and one case study at the end that they shared over screen and asked questions related to database and queries.
Technical Round 2 - Manager (7years experience) took it and first discussed work experience related questions such as challenges I faced then SQL based questions along with a guesstimate at the end.
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.
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 college or 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