I applied through college or university. The process took 2 days. I interviewed at ZS Associates (New Delhi) in Aug 2016
Interview
The first round was the Aptitude and Technical round which was conducted online by HirePro. It was a 85 mins test comprising of mostly easy questions (though the calculations were time consuming)
The second round was Case Study. I was given a case to study and within 35 mins I had to answer 5 sql queries and some other questions related to data inconsistency. After that a case interview took place for another 30 mins
Interview questions [1]
Question 1
I was asked about the way I would solve each of the sql queries.
I applied through college or university. The process took 5 days. I interviewed at ZS Associates (New Delhi) in Aug 2017
Interview
It was a 5 round process -
1. Aptitude test - Difficult and lengthy questions.
2. Video Interview Round - A total of 10 questions - 2 guestimates, questions related to database scalability, recursive relations in DBMS, etc.
3. Case Interview Round - You can expect questions on Database optimisations, writing SQL commands using 4-5 tables.
4. Technical Round - It was stress interview. The interviewer asked me the time to solve the questions and started the timer. Expect programming questions, guestimates, SQL questions.
5. HR Round - It was not a formality round like in other companies. Many students were out from this round. You can expect questions related to real-life situations and your resume.
I applied through college or university. I interviewed at ZS Associates (Pune)
Interview
Aptitude test was taken by some hire website and not amcat. This aptitude test has around 60-70 questions that should be completed in 75 minutes. Test is not that easy so prepare well for aptitude. Then video interview wherein situational questions will be asked and your behavior and problem solving skills will be tested which will then be followed by interview round.