ZS Interview Questions, Process, and Tips

Normal aptitude round

Q1. SQL 4 QUESTION 1 BASIC 3 INTERMIDATE
Add your answer
Q2. DATA WAREHOUSE DETAILS ITS IMP THEY WORK ON THIS SO ASK ALL INFO ABOUT THIS
Add your answer

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

Q1. Tell me about yourself.
Add your answer
Q2. What is SQL?
Add your answer
Q3. Project experience
Add your answer

Q1. Aptitude and Maths
Add your answer
Q2. Logical Reasoning
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