ZS Interview Questions, Process, and Tips

Aptitude, Cloud services, Python, SQL queries

Q1. About the project from current company.
Add your answer
Q2. SQL: Write a sproc logic to upsert data into a table.
Ans. 
A stored procedure logic to insert or update data in a table.
• Use MERGE statement to perform upsert operation in SQL.

• Check if the record exists in the table based on a unique key.

• If record exists, update it. If not, insert a new record.
Answered by AI
Add your answer

Q1. About the project, and other questions from resume
Add your answer
Q2. Guesstimate questions
Add your answer
Q3. Conflict resolution between team members.
Ans. 
Conflict resolution involves active listening, communication, empathy, and compromise.
• Encourage open communication between team members to address conflicts early on.

• Practice active listening to understand each team member's perspective.

• Promote empathy and understanding to foster a collaborative environment.

• Encourage compromise and finding common ground to resolve conflicts effectively.

• Seek mediation or intervention fr
Answered by AI
Add your answer

Q1. What is xgboost algorithm
Ans. 
XGBoost is a powerful machine learning algorithm known for its speed and performance in handling large datasets.
• XGBoost stands for eXtreme Gradient Boosting

• It is an implementation of gradient boosted decision trees designed for speed and performance

• XGBoost is widely used in machine learning competitions and real-world applications

• It can handle missing data, regularization, parallel processing, and custom optimization o...read more
Answered by AI
Add your answer

Verbal ability, quantitative ability, logical reasoning, language test

Q1. HR Questions were included.
Add your answer
Q2. Case Study round with riddles and data centric questions.
Add your answer

4 sections with verbal ,reasoning ,logical and pattern based question

Buiessness based case study question

Q1. Guestimate question
Add your answer
Q2. Puzzle question
Add your answer

Q1. Puzzle guesstimate sql problem solving
Add your answer
Q2. Sql , resume, problem solving
Add your answer

Basic maths, logic, aptitude and SQL

Gave business questions for which we had to solve and then discuss with manager

Q1. Guesstimates from geeks for geeks
Ans. 
Guesstimates are estimation questions that test a candidate's ability to think logically and make educated guesses.
• Break down the problem into smaller parts

• Use approximations and assumptions to come up with a reasonable answer

• Communicate your thought process clearly to the interviewer
Answered by AI
Add your answer
Q2. Project discussion
Add your answer