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.
Questions d'entretien [1]
Question 1
What will i do if i do not get the offer? (In HR round)
J'ai postulé via un établissement d'enseignement supérieur ou universitaire. Le processus a pris 2 jours. J'ai passé un entretien chez ZS Associates (Pune) en août 2020
Entretien
4 rounds; case study solving, case study discussion, Technical, HR
Discussion: case study discussion, some technical questions on SQL, python
Technical: the questions were mostly asked around the topics Python, SQL queries (joins, where clause, etc.), DBMS (Normalization, Keys, etc), Puzzles
Questions d'entretien [1]
Question 1
SQL: Joins, CLauses, some queries for given tables
Python: Do the same table operations using python
DBMS: what is normalization, foreign key, etc.
J'ai passé un entretien chez ZS Associates (Gurgaon, Haryana)
Entretien
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