ZS Interview Questions, Process, and Tips

The online assessment was broken into three individual rounds held separate days.
Online Assessment
Round 1: Aptitude test and Case Study round
Round 2: AI Communications Assessment test.
Round 3: Coding Round ( 1 DSA question + 2 SQL questions + 10-15 mcqs)

Q1. Started off with some questions were based on resume and projects.
Add your answer
Q2. Questions on sql, a. joins , b. cross join, c. what is window function d. PL/SQL query e. SDLC f. Case study
Add your answer

Verbal , crirical thinking and reasoning questions

Mcq on python and sql , 2 sql query and 1 Dsa question

Q1. Diffrence between turncat and delete
Ans. 
Turncoat refers to a traitor or someone who switches sides, while delete means to remove or erase something.
• Turncoat is a person who changes allegiance or loyalty, often seen as a traitor.

• Delete is a command used to remove or erase data or information.

• Example: A turncoat politician switches parties to gain personal benefits. Deleting a file from a computer removes it permanently.
Answered by AI
Add your answer
Q2. Find 3rd highest score in each of the subject
Ans. 
To find the 3rd highest score in each subject
• Sort the scores in each subject in descending order

• Get the 3rd element in the sorted array for each subject

• Repeat for each subject
Answered by AI
Add your answer

Q1. How to manage a conflict in team
Ans. 
Managing conflicts in a team involves effective communication, active listening, finding common ground, and seeking a win-win solution.
• Encourage open communication to address the issue

• Listen to all parties involved to understand their perspectives

• Identify common goals and areas of agreement

• Work together to find a mutually beneficial solution

• Seek mediation or involve a neutral third party if necessary
Answered by AI
Add your answer
Q2. Brain teaser and puzzle problems
Add your answer

Set of questions on english , aptitude , all are at easy level

Sql basics and some query questions

Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
Ans. 
I want to join ZS because of their reputation for data-driven decision making and innovative solutions. I see myself in a leadership role in 5 years.
• ZS is known for their expertise in data analytics and consulting

• I admire ZS's commitment to using data to drive business decisions

• I believe ZS's culture of innovation and collaboration aligns with my career goals

• In 5 years, I see myself leading a team of analysts and contr
Answered by AI
Add your answer
Q2. Question on real life scenarios
Add your answer

Q1. Salary expectation
Add your answer
Q2. When can u join
Ans. 
I can join within 2 weeks of receiving an offer.
• I can start within 2 weeks of receiving an offer.

• I need to give notice at my current job.

• I have some personal commitments that I need to wrap up before starting.
Answered by AI
Add your answer

First round was a 1 hr test compromising of logical and quant

Q1. I was examined for my communication skills
Add your answer

1 coding question
3 SQL queries
10 SQL mcq

Q1. 5 queries on joints and indexes
Add your answer
Q2. 1 logical scenario question
Add your answer
Q3. Fundamental CS questions
Add your answer

Link of an aptitude test was shared

Q1. Basics about Tableau And SQL.
Add your answer

Q1. Deep dive on Tableau and working in my projects.
Add your answer

90 mins apti -with quant, critical thinking, un-structured and so on

You can go through hungry kya case study

Q1. Guestimates on no of pertol pumps
Ans. 
The number of petrol pumps can vary greatly depending on the location and population density of the area.
• The number of petrol pumps in a city will be higher compared to a rural area.

• Population density and traffic volume are key factors in determining the number of petrol pumps needed.

• Economic factors such as income levels and vehicle ownership rates also play a role in estimating the number of petrol pumps.

• For example,...read more
Answered by AI
Add your answer
Q2. Puzzle of cake cutting by 3 cuts
Add your answer
Q3. How you managed an event
Add your answer
Q4. Anything which is not there in your resume
Add your answer

Case study question along with mental aptitude question

2 sql questions and one general dsa based coding question easy level

Q1. Puzzles were asked
Add your answer
Q2. Basics of sql and coding
Add your answer