ZS Business Technology Analyst Interview Questions, Process, and Tips

Round duration - 30 Minutes
Round difficulty - Medium

In this round Business case studies were asked. The interviewer was friendly and helped me. The round was about 30 minutes. Some Sql question was also asked. One guesstimate and and a coding question was also asked.

Q1. 
Ways To Make Coin Change
Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these coins. If it's not possible to make...read more
Ans. 
The task is to determine the total number of ways to make change for a specified value using given denominations of coins.
• Create a function that takes the number of denominations, the denominations array, and the value to make change for as input parameters.

• Use dynamic programming to iterate through all possible combinations of coins to make the change.

• Keep track of the number of ways to make change for each value from...read more
Answered by AI
Add your answer
Q2. What is an index in SQL?
Ans. 
An index in SQL is a data structure that improves the speed of data retrieval operations on a database table.
• Indexes are used to quickly locate data without having to search every row in a table.

• They can be created on one or more columns in a table.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Medium

Round duration - 180 Minutes
Round difficulty - Hard

This round consisted of an MCQ round + Problem-Solving round + a video interview round, all were elimination rounds.
The MCQ round contained problems to test problem-solving skills, data interpretation, and aptitude.
If we clear the MCQ round then the problem-solving round is unlocked immediately. This round contained questions that tested the candidate's problem-solving abilities and how he reaches the optimal solutions to that problem.
If we clear this round then the video interview round is unlocked.
Video interview contained situation based questions which we were given 10 seconds to read and then answer them on camera for more than a minute.

Round duration - 120 minutes
Round difficulty - Medium

This round consisted of a business case study.
A case study was given to the candidate to study and analyze it and then formulate the approach on how to reach answers to those questions. The time for all this was 1 hour.
After that, an interviewer discussed the approach and solutions to the questions that we formulated. Why and how did we choose the particular path to that approach, everything was discussed. MySQL questions were also asked

Q1. What SQL query would you use to generate a report of customer churn based on the data in the case study?
Ans. 
Use SQL query to generate a report of customer churn based on case study data.
• Identify the criteria for customer churn in the case study data (e.g. last purchase date, account status)

• Select the relevant fields from the database tables (e.g. customer ID, churn date)

• Filter the data to include only customers who meet the churn criteria

• Group the data by relevant time periods (e.g. monthly, quarterly) to analyze churn trend...read more
Answered by AI
Add your answer

Round duration - 45 Minutes
Round difficulty - Medium

The interview was in the evening. The interviewer was a senior manager in the company.