I applied through university. The process took 1 day. I interviewed at ZS Associates (Pune) in Jul 2024
Interview
There were 2 OLT rounds which were conducted online. Which had verbal ability and English comprehension and grammar related ques.
Then there was 1 technical round, and 1 HR round and then final selection was done.
Interview questions [2]
Question 1
They asked about Data warehouse, OLTP, OLAP, SQL queries. The main intention was to check efficiency in sql queries only. Also asked, DSA ques like, Reverse a string and finding duplicate elements in an array
In the ABI round, guestimate ques like
1) you are in 1500CE and you have a boat. How will you do the mapping of a country (you hv compass).
2) How many autorickshaws are there in Pune.
OA -> Technical coding rounds -> Tech interview -> HR Round -> selected. The Tech Round was on medium level SQL and project related.
It went pretty smoothly, I was asked some guessimates and puzzles in the HR round.
Interview questions [1]
Question 1
What will i do if i do not get the offer? (In HR round)
I have give 2 rounds of interview. one is SQL and another one behavioral and Gen AI. then they asked about case study based question and my project and experience.
The interview was average, with more focus on SQL and the resume. I was asked SQL in both the interviews. The questions were asked on resume too so prepare it thoroughly