I applied through a staffing agency. I interviewed at ZS Associates (Pune) in Feb 2025
Interview
There were 2 round. Both were technical.
There asked question on sql, Python, aws , project, pyspark.
Second round was more focus on project, what was your role, your team structure, etc
Interview questions [1]
Question 1
Explain your project.
Your role.
Few scenarios based question on aws.
Questions on sql, pyspark
I applied through career page. I got the call from HR after two days and got shortlisted, the recruiter reach out to me for scheduling interview process. The overall interview process was good.
Interview questions [1]
Question 1
Some Python and SQL questions
List employees who earn above their department’s average salary.
Pretty smooth. First an online test, then a couple of case interviews where they mainly checked how I think and break down problems. One technical round with SQL/stats basics. Final HR chat about my interest and past experiences. Overall structured and focused on problem solving + communication.
Interview questions [1]
Question 1
What is difference between INNER JOIN and LEFT JOIN
Two rounds of interviews are planned: one technical, covering coding, algorithms, and problem-solving; and one hiring manager (HM) round, focusing on leadership, teamwork, motivation, and alignment with company goals and culture.
