AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
ZS
Compare
Filter interviews by
ZS Interview Questions, Process, and Tips
Top ZS Interview Questions and Answers
- Q1. What are some of the window functions and their use?asked in Business Technology Associate interview
- Q2. 3 ants are sitting on the vertices of an equilateral triangle and they start moving in a random direction along its perimeter. What is the probability of any 2 ants colli ...read moreasked in Decision Analytics Associate interview
- Q3. 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 ...read moreasked in Business Technology Analyst interview
ZS Interview Experiences
449 interviews found
Anonymous
Selected
I appeared for an interview before Feb 2024.
(5 Questions)
- Q1. What is the SQL query using PIVOT to transform the given input table into the expected output?
- Ans.
Using PIVOT in SQL to transform input table into expected output
Use the PIVOT keyword followed by the aggregation function and column to pivot on
Specify the values to pivot on as columns in the output table
Include the FOR clause to specify the values to pivot on
Example: SELECT * FROM input_table PIVOT (SUM(value) FOR category IN ('A', 'B', 'C')) AS output_table
- Q2. What is the process flow for implementing an incremental load?
- Ans.
Incremental load process flow involves identifying new/updated data, extracting, transforming, and loading it into the target system.
Identify the source data that has changed since the last load
Extract only the new/updated data from the source system
Transform the data as needed (e.g. applying business rules, data cleansing)
Load the transformed data into the target system, either appending to existing data or updating e
- Q3. What are the steps involved in query optimization?
- Ans.
Query optimization involves steps to improve the performance of database queries.
Identify slow queries using tools like query logs or profiling.
Analyze query execution plans to understand how queries are being processed.
Optimize queries by adding indexes, rewriting queries, or restructuring data.
Consider factors like data distribution, join types, and query complexity.
Test and benchmark optimized queries to ensure perf
- Q4. What is the process flow of Slowly Changing Dimension Type 2 (SCD 2), and what are the associated post commands?
- Ans.
SCD Type 2 is used to track historical changes in data by creating new records for changes.
Identify changes in source data
Insert new record with updated data
Update end date of previous record
Add post commands like updating flags or triggers
Example: If a customer changes their address, a new record is created with the updated address while the previous record is marked as expired.
- Q5. Difference Between dimension tables and fact tables.Which one loaded firs?
- Ans.
Dimension tables store descriptive attributes while fact tables store quantitative data. Dimension tables are loaded first.
Dimension tables contain attributes like customer name, product category, etc.
Fact tables contain quantitative data like sales revenue, quantity sold, etc.
Dimension tables are typically loaded first as they provide context for the quantitative data in fact tables.
ETL Developer Interview Questions asked at other Companies
Rate your
company
🤫 100% anonymous
How was your last interview experience?
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.
Junior Analyst Interview Questions asked at other Companies
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
Associate Interview Questions asked at other Companies
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
Senior Data Analyst Interview Questions asked at other Companies
ZS interview questions for popular designations
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
Get interview-ready with Top ZS Interview Questions
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
Top ZS Business Technology Associate Interview Questions and Answers
Business Technology Associate Interview Questions asked at other Companies
Jobs at ZS
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
Data Analyst Interview Questions asked at other Companies
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
Business Development Manager Interview Questions asked at other Companies
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.
Top ZS Business Technology Associate Interview Questions and Answers
Business Technology Associate Interview Questions asked at other Companies
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
- Q4. Anything which is not there in your resume
Interview Preparation Tips
- sql
- python
- pbi
- excel
- puzzles
- guestimates
DAA Interview Questions asked at other Companies
I applied via Campus Placement
Case study question along with mental aptitude question
2 sql questions and one general dsa based coding question easy level
(2 Questions)
- Q1. Puzzles were asked
- Q2. Basics of sql and coding
Interview Preparation Tips
Top ZS Business Technology Associate Interview Questions and Answers
Business Technology Associate Interview Questions asked at other Companies
Top trending discussions
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.
Recently Viewed
REVIEWS
ARDEM Incorporated
No Reviews
SALARIES
Simplimadly
SALARIES
Guidehouse
SALARIES
Guidehouse
REVIEWS
ARDEM Incorporated
No Reviews
SALARIES
Guidehouse
JOBS
Pinnacle Group Inc
No Jobs
SALARIES
Guidehouse
SALARIES
ANZ Banking Group
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 Business Analyst Interview Questions
- ZS Associate Decision Analytics Consultant 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
- Business Analyst Interview Questions
- Associate Decision Analytics Consultant Interview Questions
- Consultant Interview Questions
- Show more
ZS Interview Process
based on 334 interviews
Interview experience
Anonymously discuss salaries, work culture, and many more
Get Ambitionbox App
Interview Questions from Similar Companies
Fast track your campus placements
|
Associate Consultant
2k
salaries
|  ₹9.3 L/yr - ₹27 L/yr |
|
Decision Analytics Associate
1.7k
salaries
| ₹5.5 L/yr - ₹18.2 L/yr |
|
Business Technology Associate
1.2k
salaries
| ₹8 L/yr - ₹17.4 L/yr |
|
Associate Decision Analytics Consultant
890
salaries
| ₹10.4 L/yr - ₹26 L/yr |
|
Consultant
643
salaries
| ₹14.7 L/yr - ₹38 L/yr |
Wipro
TCS
Infosys
HCLTech
- Home >
- Interviews >
- ZS Interview Questions
