ZS Business Technology Associate Interview Questions, Process, and Tips

Aptitude questions like competitive exams

Detailed case study requiring analytical excel and sql solutions

Q1. Why do I want to join this company
Add your answer

Aptitide Test with questions related to Maths, English, Pseudo codes and Puzzles

It was a case for analyzing data and finding insights

Data related case study with basic SQL related answers

Q1. One on one round discussing the details from the case study, a few more SQL related quesstion while analysing the data shown to us
Add your answer
Q2. Mostly discussed about previously worked projects. Interviewer conversed related to the projects at decent depth and breadth.
Add your answer

Basic Aptitude question

Q1. Based Python, SQL, DATA WAREHOUSING Fundamental
Add your answer
Q2. What is list, tuple, dictionary
Ans. 
List, tuple, and dictionary are data structures in Python.
• List: ordered, mutable, allows duplicate elements (e.g. [1, 2, 3])

• Tuple: ordered, immutable, allows duplicate elements (e.g. (1, 2, 3))

• Dictionary: unordered, mutable, key-value pairs (e.g. {'key1': 'value1', 'key2': 'value2'})
Answered by AI
Add your answer
Q3. What is left,right,outer,inner join
Ans. 
Different types of SQL joins used to combine data from two or more tables.
• Left join: Returns all records from the left table and the matched records from the right table.

• Right join: Returns all records from the right table and the matched records from the left table.

• Outer join: Returns all records when there is a match in either left or right table.

• Inner join: Returns records that have matching values in both tables.
Answered by AI
Add your answer

Q1. General Hr Question
Add your answer