I applied through university. I interviewed at ZS Associates (Howrah) in Sept 2020
Interview
There are two rounds. Problem solving and other behavioural round. Main focus on dbms. They ask for puzzles and guesstimates also. Little bit Java too. Be confident they will ask u more queries. Do DBMS SQL and project mainly.
Interview questions [1]
Question 1
DBMS SQL & Java, about projects, puzzles and guesstimates
I applied through university. The process took 1 day. I interviewed at ZS Associates (Calcutta)
Interview
Round 1.Case Study Round
A case study is provided on healthcare data. Giving various scenarios and the candidate needs to provide his/her insights as well as scripts/queries to solve them
Round 2.Technical Interview
Question from SQL, Datawarehouse, OLTP, OLAP were asked
3.HR Interview
Whatever you mention in resume are asked plus some guesstimates questions
I applied in-person. The process took 1 day. I interviewed at ZS Associates (New Delhi)
Interview
The interview was good.one day process. HR team is good and co operative. Questions were asked around SQL and manual testing concepts. The complexity of questions were high and challenging, which made interview more interesting