ZS Associates Interview Experience for BTSA | On-Campus 2021

Eligibility:  70% & above in std. 10th and 12th, 6.5+ CGPA

Format Of Hiring:  Each and every Round was an Elimination Round. 

Platform for Phase – 1: Talview

Phase – 1 

Test – 1(Aptitude Test):

MCQs: 50

Time Allotted: 45 Minutes

Topics Included :  

• Basic Data Structures and Algorithms
• DBMS and  SQL
• Quantitative Reasoning
• Logical Reasoning
• Verbal Reasoning
  

Tips:   

• Practice Questions on India Bix or any other website
• Use GFG (geek quizzes) for SQL, DBMS, and DSA Practice Questions
• Only when you clear this round, you can proceed for 2^nd round
• 2^nd  Round is in continuation only, which means once you clear 1^st round, 2^nd round will start immediately.
  

Test – 2(Problem Solving Deep Dive):

MCQs: 8-10

Time Allotted: 30 Minutes

Topics Included :  

• Data Interpretation Questions
• Small Calculations based on given data and graphs

Tips :

• You need to be quick in doing calculations and reading questions as questions will be of Comprehension Type
• Only when you clear this round, you can proceed to 3^rd round
• 3^rd Round is in continuation only, which means once you clear 2^nd round, 3^rd round will start immediately.

Test – 3(Video Interview):

Format: Audio and Video Recording are on and we need to answer the question visible on the Screen.

Time Allotted: 3  Minutes for recording your answer

Sample Questions: 

• What will you do in case 2 people in your team are not doing work on time and you are the team lead?
• Predict the number of Footballs sold in India.

Phase – 2

Round -1(Case Study Round):

Format: 

• Given a Case Study make a report, identify discrepancies in the tables.

Sample :  

• We need to identify whether the tables can be normalized further.
• We also need to write SQL queries for report generation.
• Lastly, what changes would you suggest if you were the owner of the given firm? ( Managerial Question )

Round -2 (Case Debriefing Round Interview):

Duration: 

• My interview went on for 45 Minutes

Experience: 

• In this round, the interviewer generally asks questions seeing the answers you have written for the Case Study.
• Also, he asked questions from DBMS and SQL.
• Some common puzzles and Project discussions also will be there.

Tips: 

• Go through your resume.
• Prepare your projects well.
• Go through SQL joins and complex queries involving HAVING and GROUP BY clauses.
• Go through Guesttimates and Puzzles from GFG

Final Interview Round

Duration:

• My interview went on for 35 Minutes

Experience:

• In this round, the interviewer asked me to open MS-Excel and write SQL queries for given scenarios.
• Also, he asked about Joins and some DBMS concepts.
• I was asked the guesstimate of predicting the “Number of Trees in my City”.
• He also asked me about my Past Internship Experiences and Projects.

Final Verdict: 14 Students were selected for the BTSA role and I was one of them.

Verdict: Selected