ZS Interview Questions and Answers

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...read more
Answered by AI
Add your answer
Q2. Question on real life scenarios
Add your answer

Q1. Salary expectation
Ans. 
I am looking for a competitive salary that reflects my skills and experience in data analysis, ideally in the range of $70,000 to $90,000.
• Research industry standards: For example, Glassdoor and Payscale indicate that data analysts in my region earn between $65,000 and $85,000.

• Consider my experience: With over 3 years in data analysis, I believe a salary closer to $80,000 is appropriate.

• Factor in the company's size and ...read more
Answered by AI
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

Q1. Tell me about your self
Ans. 
I am a data-driven professional with a passion for analytics, problem-solving, and leveraging insights to drive business decisions.
• Educational Background: I hold a degree in Data Science, where I developed strong analytical skills and a solid foundation in statistics.

• Professional Experience: I worked as a data analyst at XYZ Corp, where I utilized SQL and Python to analyze sales data, leading to a 15% increase in reven...read more
Answered by AI
Add your answer
Q2. Tell me about your projects
Ans. 
I worked on various projects involving data analysis, predictive modeling, and optimization techniques to drive business decisions.
• Developed a predictive model to forecast customer churn, resulting in a 15% reduction in attrition rates.

• Conducted a market basket analysis for a retail client, identifying key product associations that increased cross-selling opportunities.

• Implemented a dashboard using Tableau to visualize...read more
Answered by AI
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
Ans. 
I successfully managed a corporate event by planning meticulously, coordinating with vendors, and ensuring smooth execution on the day.
• Defined the event objectives and target audience to tailor the experience.

• Created a detailed timeline for planning and execution, ensuring all tasks were on schedule.

• Coordinated with vendors for catering, audio-visual equipment, and venue setup, ensuring all needs were met.

• Developed a b...read more
Answered by AI
Add your answer
Q4. Anything which is not there in your resume
Add your answer