Ho sostenuto un colloquio presso ZS Associates (Nuova Delhi)
Colloquio
The interview started with an introduction. Then, the interviewer began to ask some questions about my projects. After that, for around 40 minutes, the interviewer focused on SQL Questions. The questions were about JOIN, SubQuery, Window functions, and various clauses.
Domande di colloquio [1]
Domanda 1
Given 2 tables, give the INNER JOIN, LEFT JOIN, and RIGHT JOIN
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.
Domande di colloquio [1]
Domanda 1
What will i do if i do not get the offer? (In HR round)
Ho sostenuto un colloquio presso ZS Associates (Gurgaon, Haryana)
Colloquio
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.
Ho sostenuto un colloquio presso ZS Associates (Gurgaon, Haryana)
Colloquio
Question related to python,sql and puzzle were asked. Python visualization tools like matplotlib and seaborn were also covered with numpy and pandas library. Topic related to big data were also asked, with pytorch and keras