ZS interview experience Real time questions & tips from candidates to crack your interview
Business Technology Solutions Associate
ZS
3 rounds | 10 Coding
problems
Selected Interview preparation journey
Journey
ZS was the first company to come to our campus, and ZS is a consulting firm that captures your technical skills equally along with the communications skills for this role. Hence, don’t just focus on your resume to reflect technical skills; gather all-round experience and share this with them.
Application story
ZS was the first company to come to our campus for three roles - data science, decision analytics, and business technology. There were three rounds; the first round was a Mcq-based online aptitude test, which lasted 60 minutes.
After clearing the first round, I got into the second round of technical assessment. The technical tests included questions from Sql query questions and data structures and algorithms questions; after clearing that round, there was a final round of HR and fit interviews.
Why selected/rejected for the role?
I had good SQL skills along with nontechnical elements of experience. Communication skills and a solving attitude are what they look for eagerly in candidates
Preparation
Duration: 1 month
Topics: SQL, DBMS, puzzles, guestimates, logical reasonings based on aptitude, quantitative aptitude, vocabulary, reading comprehension, guestimates related to your city, a little bit of data structures and algorithms for keeping your basics clear
Tip 1 : Practice aptitude questions so you can clear the first round
Tip 2 : Do nontechnical work as well
Tip 3 : Stay strong in SQL
Application process
Where: Campus
Eligibility: Above 7 CGPA
Tip 1: SQL is must
Tip 2: all-round experience should reflect
Interview rounds
01
Round
Easy
Online Coding Interview
Duration60 minutes
Interview date24 Apr 2021
Coding problem3
It was an aptitude round of 60 minutes in the morning time.
It was on mettl platform and was proctored.
1. MCQ
An aeroplane covers a certain distance at a speed of 240 kmph in 5 hours. To cover the same distance in 1 hours, it must travel at a speed of:
a) 300 kmph
b) 360 kmph
c) 600 kmph
d) 720 kmph
Problem approach
Ans: 720 kmph
2. MCQ
What percentage of numbers from 1 to 70 have 1 or 9 in the unit's digit?
1) 1
2) 14
3) 20
4) 21
Problem approach
Ans: 20
3. MCQ
A man buys Rs. 20 shares paying 9% dividend. The man wants to have an interest of 12% on his money. The market value of each share is:
1) Rs. 12
2) Rs. 15
3) Rs. 18
4) Rs. 21
Problem approach
Ans: 15 Rs
02
Round
Medium
Online Coding Interview
Duration60 minutes
Interview date29 Apr 2021
Coding problem4
SQL basic questions on joins and DBMS where tables were given with their primary and secondary keys. We had to join the table and extract the required column.
1. SQL
You are given 2-3 tables which you have to join and calculate values using aggregate functions. 2 tables were there having employee and their sales details. Find the month in which each employee had the highest sales
Problem approach
Joined both tables on employee id, applied sum of sales and grouped it on employee id and name. Pulled the sum of sales and employee id and name in select.
2. SQL
Bank management system was given and some cases were given and using that information we had to write the query and show the output which is required.
Tables and data were given.
Problem approach
Do practice sql query questions for the case study.
3. MCQ
Which SQL keyword is used to sort the result-set?
A. SORT BY
B. ORDER BY
C. ARRANGE BY
D. ALIGN BY
Problem approach
Order by
4. MCQ
What will the SQL query SELECT * FROM Users WHERE FirstName = ‘John’ AND LastName = ‘Doe’; return?
A. All users with the first name 'John'.
B. All users with the last name 'Doe'.
C. All users with the first name 'John' or the last name 'Doe'.
D. All users with the first name 'John' and the last name 'Doe'.
Problem approach
Ans: D
03
Round
Medium
Video Call
Duration45 minutes
Interview date3 May 2021
Coding problem3
Here they judge you in your communication skills and problem solving attitude by giving puzzles and guestimates. They also screen your resume and ask questions from that and on the projects done in college.
Guesstimate on How many white cars in Delhi currently on roads
1. SQL
Can we apply loops in MySQL. How can we do this for database.(Learn)
Problem approach
I explained loops are not available in MySQL but present in SQL Server which we can use. Alternatively if we need lesser number of loops, we can use union in MySQL
2. Project Related
Explain your role in the project that you’ve done in your final year
Problem approach
Tip 1: be thorough on your role and responsibilities and the learning you had
3. HR Questions
What makes you a good fit to be here.
Problem approach
Tip 1: Explain how can your skill set benefit them
Tip 2: Even if you don’t have the exact skills show your learning mindset
Tip 3: How you will also benefit from working here
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
How do you remove whitespace from the start of a string?
Choose another skill to practice
Similar interview experiences
Business Technology Analyst
3 rounds | 4 problems
Interviewed by ZS
Rejected
1207 views
0 comments
0 upvotes
Software Engineer
4 rounds | 4 problems
Interviewed by ZS
Selected 2058 views
0 comments
0 upvotes
Analytics Consultant
3 rounds | 10 problems
Interviewed by ZS
Selected 975 views
0 comments
0 upvotes
Business Technology Development Associate
4 rounds | 2 problems
Interviewed by ZS
Selected 527 views
0 comments
0 upvotes