AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
ZS
Work with us 
Compare
Filter interviews by
ZS Business Technology Associate Interview Questions and Answers
17 Interview questions
A stored procedure logic to insert or update data in a table.
Use MERGE statement to perform upsert operation in SQL.
Check if the record exists in the table based on a unique key.
If record exists, update it. If not, insert a new record.
SQL basics involve understanding databases, queries, and data manipulation using structured query language.
SQL stands for Structured Query Language, used for managing and manipulating relational databases.
Common SQL commands include SELECT (to retrieve data), INSERT (to add data), UPDATE (to modify data), and DELETE (to remove data).
Example of a SELECT statement: SELECT * FROM employees WHERE department = 'Sales';
...
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.
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
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
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
Some common window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
They are used to calculate running totals, moving averages, and cumulative sums.
Window functions require an OVER clause to define the window of rows that the function will operate on.
Different types of joins in SQL include inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables
Left join: Returns all rows from the left table and the matched rows from the right table
Right join: Returns all rows from the right table and the matched rows from the left table
Full outer join: Returns rows when there is a match in either table
There are approximately 1,000 traffic lights in New Delhi.
New Delhi is a large metropolitan city with heavy traffic, so there are likely many traffic lights.
The number of traffic lights can vary based on the size of the city and the traffic flow.
An estimate of around 1,000 traffic lights is reasonable for a city like New Delhi.
Dense rank assigns consecutive integers to rows with the same value, while rank leaves gaps in the ranking sequence.
Dense rank assigns the same rank to rows with the same value, with no gaps in the ranking sequence.
Rank leaves gaps in the ranking sequence for rows with the same value.
ROW_NUMBER() assigns a unique sequential integer to each row in the result set.
A rolling sum calculates the cumulative total of a series of numbers over a specified window.
A rolling sum can be calculated using a fixed-size window, e.g., the sum of the last 3 numbers in a series.
Example: For the series [1, 2, 3, 4, 5], the rolling sums with a window of 3 would be [6, 9, 12].
Rolling sums are useful in time series analysis to identify trends over time.
They can be implemented in programming lang...
ZS Business Technology Associate Interview Experiences
36 interviews found
Anonymous
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
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 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
Selected
I appeared for an interview in Jun 2024.
Aptitude + coding round (1-1.5 hrs)
(2 Questions)
- Q1. SQL deep dive with data modelling
- Q2. Data warehousing questions and concepts
(2 Questions)
- Q1. Scenario based questions
- Q2. Case studies and guesstimates
(1 Question)
- Q1. Salary negotiation
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Aug 2024. There were 3 interview rounds.
Quantitative, logical reasoning, data interpretation, verbal ability
(2 Questions)
- Q1. Grammar check question
- Q2. Speaking n comunication
(2 Questions)
- Q1. How to copy a table in sql
- Ans.
To copy a table in SQL, you can use the CREATE TABLE AS SELECT statement.
Use the CREATE TABLE AS SELECT statement to copy the structure and data of a table.
Specify the new table name after CREATE TABLE and the existing table name after SELECT.
Example: CREATE TABLE new_table AS SELECT * FROM existing_table;
- Q2. How to copy only contents of table in sql
- Ans.
Use SELECT INTO statement to copy contents of a table in SQL.
Use SELECT INTO statement to copy contents of a table into a new table.
Specify the columns you want to copy in the SELECT statement.
Ensure the new table has the same structure as the original table.
Interview Preparation Tips
Skills evaluated in this interview
Selected
I appeared for an interview in Aug 2024.
Aptitude, Cloud services, Python, SQL queries
(2 Questions)
- Q1. About the project from current company.
- Q2. SQL: Write a sproc logic to upsert data into a table.
- Ans.
A stored procedure logic to insert or update data in a table.
Use MERGE statement to perform upsert operation in SQL.
Check if the record exists in the table based on a unique key.
If record exists, update it. If not, insert a new record.
(3 Questions)
- Q1. About the project, and other questions from resume
- Q2. Guesstimate questions
- Q3. Conflict resolution between team members.
- Ans.
Conflict resolution involves active listening, communication, empathy, and compromise.
Encourage open communication between team members to address conflicts early on.
Practice active listening to understand each team member's perspective.
Promote empathy and understanding to foster a collaborative environment.
Encourage compromise and finding common ground to resolve conflicts effectively.
Seek mediation or intervention fr...
I applied via Campus Placement and was interviewed in Jul 2024. There were 4 interview rounds.
Easy were there in this round
(1 Question)
- Q1. Easy ques were there
Sql and 1 dsa was asked in this round
(2 Questions)
- Q1. Sql ques were asked
- Q2. Puzzles ques were asked
Selected
Reasoning ,English,Guessttimates
(2 Questions)
- Q1. Puzzles related to maths
- Q2. Why wanna join consulting
(2 Questions)
- Q1. Joins SQL detail
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
- Q2. Project in derail
- Ans.
When a project is in derail, it means it is off track and not progressing as planned.
Identify the root cause of the derailment
Reassess project goals and timeline
Implement corrective actions to get the project back on track
Communicate with stakeholders about the situation and the plan moving forward
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Feb 2024. There were 3 interview rounds.
Basic aptitude LR DI quant and speaking skills
(2 Questions)
- Q1. SQL MCQs 15 - 20 were there
- Q2. SQL query writing questions were there i guess 2 3 and 1 coding question in python
(2 Questions)
- Q1. SQL query writing question was there
- 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.
I applied via Campus Placement
Ques about aptitude and guesstimates
2 coding question and 3 sql questions were there also some mcqs
Interview Preparation Tips
aptitude
What people are saying about ZS
ZS Interview FAQs
The duration of ZS Business Technology Associate 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
- Assistant Manager Interview Questions
- System Engineer Interview Questions
- Business Analyst Interview Questions
- Associate Interview Questions
- Senior Associate Interview Questions
- Senior Analyst Interview Questions
- Senior Business Analyst Interview Questions
- Research Analyst Interview Questions
- Show more
Overall Interview Experience Rating
based on 36 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
ZS Business Technology Associate Reviews and Ratings
based on 169 reviews
Rating in categories
Pune,
Gurgaon / Gurugram
4-8 Yrs
Not Disclosed
|
Associate Consultant
2.2k
salaries
|  ₹15.1 L/yr - ₹25 L/yr |
|
Decision Analytics Associate
1.9k
salaries
| ₹10 L/yr - ₹18.5 L/yr |
|
Business Technology Associate
1.3k
salaries
| ₹10.4 L/yr - ₹17.4 L/yr |
|
Associate Decision Analytics Consultant
982
salaries
| ₹15 L/yr - ₹26.1 L/yr |
|
Consultant
782
salaries
| ₹21 L/yr - ₹35.5 L/yr |
Deloitte
Ernst & Young
PwC
KPMG India
- Home >
- Interviews >
- ZS Interview Questions
