ZS Data Engineer Interview Questions and Answers

Q1. Project explaining
Add your answer
Q2. Write code to generate csv file with note pad data
Ans. 
Code to generate a CSV file with notepad data
• Open a text file and read the data

• Parse the data and write it to a CSV file

• Use libraries like pandas in Python for easier CSV handling
Answered by AI
Add your answer

Maths, Puzzles, English, SQL

Q1. SQL Question, Find ranks based on scores
Ans. 
Use SQL to find ranks based on scores.
• Use the RANK() function to assign ranks to scores.

• Consider using the ORDER BY clause to sort scores before assigning ranks.

• Handle ties in scores appropriately to avoid skipping ranks.
Answered by AI
Add your answer
Q2. Puzzle about crorssing a bridge and then coin exchange problem
Add your answer

Sql coding questions

Pharma case study based on particular regional sales

Q1. Salary discussion
Add your answer

Round1 case study
Round2-sql+ puzzle
Round3-project based