I applied through university. I interviewed at ZS Associates (Noida) in Aug 2024
Interview
Mostly SQL questions were asking like write a query covering topics like procedures , nested queries etc. Then some puzzles were asked that you can read from gfg and lastly basic DSA question.
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.
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