I applied through university. The process took 4 weeks. I interviewed at ZS Associates (Pune) in Oct 2021
Interview
its conducted in two phases
phase 1: 3 rounds(mcq(quant,apt,verbal,eng),,,case study,,,AI recorded Interview)
phase 2: 2 rounds(Technical interview,HR)
Technical mostly based on dbms mostly sql query
DSA mostly not asked
mcq test is 35 questions 45 minutes
Interview questions [1]
Question 1
Mention the issues with traditional file-based systems that make DBMS a better choice?
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