ZS Interview Questions, Process, and Tips

Aptitude test had heavy quant questions

Q1. No of signals in my area
Add your answer
Q2. Oncology disease areas and some drugs
Add your answer

Aptitude and english test for around 60min

Q1. We need speak the audio played
Add your answer
Q2. We also need to write an essay at last
Add your answer

One case study have been given and we need to solve the case study with 7 questions in 60min

Q1. Tell me about ur self
Ans. 
I am a data-driven individual with a background in analytics and a passion for problem-solving.
• Background in analytics

• Strong data-driven mindset

• Passion for problem-solving
Answered by AI
Add your answer
Q2. Some questions based on resume
Add your answer
Q3. Guesstimate was asked in the interview
Add your answer

Aptitude + coding round (1-1.5 hrs)

Q1. SQL deep dive with data modelling
Add your answer
Q2. Data warehousing questions and concepts
Add your answer

Q1. Scenario based questions
Add your answer
Q2. Case studies and guesstimates
Add your answer

Q1. Salary negotiation
Add your answer

Quantitative, logical reasoning, data interpretation, verbal ability

Q1. Grammar check question
Add your answer
Q2. Speaking n comunication
Add your answer

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

Aptitude, Cloud services, Python, SQL queries

Q1. About the project from current company.
Add your answer
Q2. SQL: Write a sproc logic to upsert data into a table.
Add your answer

Q1. About the project, and other questions from resume
Add your answer
Q2. Guesstimate questions
Add your answer
Q3. Conflict resolution between team members.
Add your answer