Zerodha Trade Analyst Interview Questions and Answers

Q1. Questions on probability and puzzles
Add your answer

Basic coding based on job profile

Q1. More about project
Add your answer

Q1. Salary negotiation
Add your answer

I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.

Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.

Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.

Q1. Current CTC, Preferred location
Ans. 
Current CTC and preferred location are confidential information.
• Current CTC and preferred location are personal and confidential details.

• It is common practice not to disclose current CTC during interviews.

• Preferred location may vary based on individual circumstances and preferences.
Answered by AI
Add your answer

Q1. About yourself, projects worked, sql questions, Python questions
Add your answer

Q1. Introduction , knowledge about capital market
Add your answer

Nothing as such just basic

Q1. Joins, case when
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them. Case when is a conditional statement used to perform different actions based on different conditions.
• Joins are used to retrieve data from multiple tables based on a related column

• Case when is used to perform different actions based on different conditions in SQL queries

• Example: SELECT * FROM table1 JOIN table2 ON table1.id = ...read more
Answered by AI
Add your answer

Q1. Result of different sql joins
Ans. 
SQL joins combine data from two or more tables based on a related column between them.
• Inner join returns rows that have matching values 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 all rows when there is a match in either left or right table
Answered by AI
Add your answer