AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
ZS
Work with us 
Compare
Filter interviews by
ZS Interview Questions and Answers
134 Interview questions
Window functions perform calculations across a set of table rows related to the current row, enabling advanced analytics in SQL.
Window functions allow calculations like running totals, averages, and rankings without collapsing rows.
Example: ROW_NUMBER() assigns a unique sequential integer to rows within a partition.
Example: SUM() OVER (PARTITION BY department) calculates the total salary per department while retai...
Adjusted R-squared accounts for the number of predictors, while R-squared does not, potentially leading to misleading interpretations.
R-squared measures the proportion of variance explained by the model, but it can increase with more predictors, even if they are irrelevant.
Adjusted R-squared adjusts the R-squared value based on the number of predictors, providing a more accurate measure of model fit.
For example, i...
RMSE measures average error magnitude with emphasis on larger errors, while MAE provides a straightforward average error.
RMSE (Root Mean Square Error) squares errors before averaging, giving more weight to larger errors.
MAE (Mean Absolute Error) calculates the average of absolute errors, treating all errors equally.
Example: For predictions [2, 3, 5] vs actuals [3, 2, 4], RMSE = sqrt((1^2 + 1^2 + 1^2)/3) = 1, MAE =...
This pseudocode outlines the Bubble Sort algorithm, a simple sorting technique that repeatedly steps through the list.
1. Start with an unsorted array of strings, e.g., ['banana', 'apple', 'cherry'].
2. Compare each pair of adjacent elements.
3. If the first element is greater than the second, swap them.
4. Repeat the process for each element in the array until no swaps are needed.
5. The array is sorted when a full pa...
MapReduce is a programming model for processing large data sets, while Apache Spark is a fast, in-memory data processing engine.
MapReduce processes data in two phases: Map (data processing) and Reduce (aggregation).
Apache Spark offers in-memory processing, which speeds up data processing compared to MapReduce's disk-based approach.
MapReduce is typically slower due to its reliance on disk I/O, while Spark can perfo...
Estimate annual shoe sales using population, user count, and monthly sales data.
Identify the total population and the percentage of users who buy shoes.
Calculate the total number of users: population * percentage of users.
Determine monthly sales per user and multiply by the total number of users.
Annual sales = monthly sales * 12.
SQL queries can be crafted to address various data retrieval and manipulation scenarios effectively.
Use SELECT to retrieve data: Example - SELECT * FROM patients WHERE age > 30;
Use JOIN to combine tables: Example - SELECT a.name, b.disease FROM patients a JOIN diagnoses b ON a.id = b.patient_id;
Use WHERE for filtering: Example - SELECT * FROM appointments WHERE date = '2023-10-01';
Use GROUP BY for aggregation: ...
SQL (Structured Query Language) is a standard programming language for managing and manipulating relational databases.
Used for querying data: Example - SELECT * FROM employees;
Allows data manipulation: Example - INSERT INTO employees (name, age) VALUES ('John', 30);
Supports data definition: Example - CREATE TABLE employees (id INT, name VARCHAR(100));
Facilitates data control: Example - GRANT SELECT ON employees TO...
The transformer model is a deep learning architecture designed for natural language processing tasks, utilizing self-attention mechanisms.
Introduced in the paper 'Attention is All You Need' by Vaswani et al. in 2017.
Uses self-attention to weigh the importance of different words in a sentence.
Replaces recurrent neural networks (RNNs) for better parallelization and efficiency.
Key components include the encoder and d...
To reduce hallucination in chatbots, implement strategies like fine-tuning, context management, and user feedback integration.
Fine-tune the model on domain-specific data to improve accuracy. For example, train on customer service transcripts for a support bot.
Implement context management to maintain conversation history, ensuring the bot understands previous interactions.
Use reinforcement learning from human feedb...
ZS Interview Experiences
475 interviews found
Lokesh Pappala
Selected
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. What is main role in sap Account payable
- Q2. What is use of charted accounting
- Q3. How is it connected to client ..?
- Q4. What is diffrence between ECc to S4 hana
- Q5. What is a chart of accounts how is it assigned..?
- Q6. What is sap active methodology...?
Interview Preparation Tips
Anonymous
Selected
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Common aptitude questions on mettl platform
(3 Questions)
- Q1. Python Standard interview questions
- Q2. SQL Standard interview questions (Easy)
- Q3. CaseStudy and questions based on it.
(3 Questions)
- Q1. Common hr questions
- Q2. Puzzles
- Q3. Project Discussion
Interview Preparation Tips
- Python
- SQL
- R
So confirm with the hr before even attending the interviews.
Selected
I applied via Campus Placement
1.1.1 Maths
1.1.2 English
1.1.3 Logical Reasoning
1.2 Objective Business Case
1.3 Video Round (guesstimates + behavioural)
1.1 Case Study - 2 page solid case study with multiple calculative and descriptive questions (similar to DILR of CAT but easier and business oriented)
1.2 Case Debrief - questions on 1.1
(1 Question)
- Q1. Basic interests, hobby, why ZS, Guesstimates, Puzzles
I appeared for an interview in Dec 2024.
Normal aptitude round
(2 Questions)
- Q1. SQL 4 QUESTION 1 BASIC 3 INTERMIDATE
- Q2. DATA WAREHOUSE DETAILS ITS IMP THEY WORK ON THIS SO ASK ALL INFO ABOUT THIS
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.
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)
(2 Questions)
- Q1. Started off with some questions were based on resume and projects.
- Q2. Questions on sql, a. joins , b. cross join, c. what is window function d. PL/SQL query e. SDLC f. Case study
Interview Preparation Tips
- DBMS
- SQL
- OOPS
- DSA
Selected
I applied via Campus Placement and was interviewed in Oct 2024. There were 4 interview rounds.
Verbal , crirical thinking and reasoning questions
Mcq on python and sql , 2 sql query and 1 Dsa question
(2 Questions)
- 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.
- 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
(2 Questions)
- 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
- Q2. Brain teaser and puzzle problems
Interview Preparation Tips
- gesstimates
- puzzle
- DSA
- SQL
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Dec 2024. There were 4 interview rounds.
Set of questions on english , aptitude , all are at easy level
Sql basics and some query questions
(2 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...
- Q2. Question on real life scenarios
(2 Questions)
- Q1. Salary expectation
- 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.
Interview Preparation Tips
First round was a 1 hr test compromising of logical and quant
(1 Question)
- Q1. I was examined for my communication skills
1 coding question
3 SQL queries
10 SQL mcq
(3 Questions)
- Q1. 5 queries on joints and indexes
- Q2. 1 logical scenario question
- Q3. Fundamental CS questions
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in Oct 2024. There were 3 interview rounds.
Link of an aptitude test was shared
(1 Question)
- Q1. Basics about Tableau And SQL.
(1 Question)
- Q1. Deep dive on Tableau and working in my projects.
I applied via Company Website and was interviewed in Oct 2024. There were 3 interview rounds.
90 mins apti -with quant, critical thinking, un-structured and so on
You can go through hungry kya case study
(4 Questions)
- 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,...
- Q2. Puzzle of cake cutting by 3 cuts
- 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...
- Q4. Anything which is not there in your resume
Interview Preparation Tips
- sql
- python
- pbi
- excel
- puzzles
- guestimates
What people are saying about ZS
ZS Interview FAQs
Some of the top questions asked at the ZS interview -
The duration of ZS interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
ZS Interviews By Designations
- ZS Decision Analytics Associate Interview Questions
- ZS Business Technology Associate Interview Questions
- ZS Business Operations Associate Interview Questions
- ZS Associate Interview Questions
- ZS Business Technology Analyst Interview Questions
- ZS Associate Decision Analytics Consultant Interview Questions
- ZS Business Analyst Interview Questions
- ZS Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Decision Analytics Associate Interview Questions
- Business Technology Associate Interview Questions
- Business Operations Associate Interview Questions
- Associate Interview Questions
- Business Technology Analyst Interview Questions
- Associate Decision Analytics Consultant Interview Questions
- Business Analyst Interview Questions
- Consultant Interview Questions
- Show more
Overall Interview Experience Rating
based on 358 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
|
Associate Consultant
2.2k
salaries
|  ₹15.1 L/yr - ₹25 L/yr |
|
Decision Analytics Associate
1.9k
salaries
| ₹10 L/yr - ₹16 L/yr |
|
Business Technology Associate
1.3k
salaries
| ₹7 L/yr - ₹17.4 L/yr |
|
Associate Decision Analytics Consultant
970
salaries
| ₹15 L/yr - ₹26.1 L/yr |
|
Consultant
746
salaries
| ₹15 L/yr - ₹39 L/yr |
Deloitte
Ernst & Young
PwC
KPMG India
- Home >
- Interviews >
- ZS Interview Questions
