ZS Interview Questions, Process, and Tips

Well structured and covered data interptions, reasoning,

Has a case study topic with detailed and lengthy questions.

Math problem verbal aptitude as well as directional questions ,work time questions

Basic questions were asked,not so tough

Q1. Introduction about myself
Add your answer
Q2. Guesstimates questions and puzzles
Add your answer

Q1. Prepare all possible questions that can be framed from your resume and past projects
Add your answer
Q2. Be ready for situation based questions
Add your answer

Case study related to healthcare can be shared to judge your critical thinking and analytical skills

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
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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
Answered by AI
Add your answer
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.
Answered by AI
Add your answer
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.
Answered by AI
Add your answer

2hrs aptitude test imcluding case studies

Q1. Approach about case study
Add your answer
Q2. Guesstimates on no of flights
Ans. 
Estimate the number of flights in a day at a major airport
• Consider the number of gates at the airport

• Think about the average number of flights per gate per day

• Factor in peak travel times and off-peak times

• Take into account the types of flights (international, domestic, etc.)
Answered by AI
Add your answer

Basic aptitude LR DI quant and speaking skills

Q1. SQL MCQs 15 - 20 were there
Add your answer
Q2. SQL query writing questions were there i guess 2 3 and 1 coding question in python
Add your answer

Q1. SQL query writing question was there
Add your answer
Q2. Guesstimate- estimate the number of urinals in ZS office
Ans. 
I would estimate there are around 20 urinals in the ZS office.
• Consider the size of the office building and the typical ratio of urinals to toilets in commercial spaces.

• Take into account the number of employees and visitors who would use the restroom facilities.

• If possible, try to gather information on the floor plan or layout of the office to make a more accurate estimate.
Answered by AI
Add your answer