Technology Consultant - Associate

It consisted of 3 sections: 

1. Online MCQ test having 4 sections: Aptitude , Computer Science Subjects Questions, Logical Reasoning and English Grammer and Passage. (50 questions in 40 minutes).

2. Problem Solving Deep Dive (PSDD round) : It consists of a business case study with graphs and pictorial representation, we are require to solve questions from the information provided (8 questions 30 minutes)

3. Video Questions Round: It consists of commonly asked HR questions that appear one by one.We have to record a video of our answer for a maximum time of 3 minutes. (8 questions 24 minutes)

Those who qualified the first round were given the opportunity to attend the 2nd round. It consisted of 2 sections:

1. Case Study (Writing): In this round , we were shown a video of a business case study. After the video we were given 60 minutes to read the case study as well as prepare our answers to the questions based on the case study. 

Eg: My case study was based on Automobile Industry(It had 5 tables like product manufacturing, customer details, product details, product quantity, Discounts)

I had to write Queries/Data flow diagrams for generating a report (Structure was given in the example).It also had questions for query optimisation.

2.Case Study(Discussion): This round was basically about case debriefing. In this round, I had to discuss the case study with a ZS interviewer and have to explain my answers for the case study questions. He also asked for a puzzle. Discussed the projects I had done. You will get a call based on the performance of this round for the last round

EBI + FIT Round : It was basically a Technical and HR round. First I introduced myself, discussed my projects. Thereafter the ZS leader asked me questions about my project. He also asked some project management questions, followed by a guesstimate (Asked the number of red lights my city). 
Some common HR questions: 
Why ZS ? 
Why this role ?
How will you manage the long hours at ZS ?
The round ended with me asking him questions about his experience and his learning curve.