I applied through university. I interviewed at ZS Associates (Noida) in Sept 2025
Interview
Asked about python and sql implementation, specifically sql in python, asked from resume i.e. projects and experience. cse fundamentals little bit of oops and SQL fundamentals, did not ask dsa or query but that depended on the interviewer too.
Interview questions [1]
Question 1
How a sql query runs in the compiler, how sql is implemented in python etc etc
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