SQL -> the order of execution, one question on inner join, and some theoretical questions on SQL. Then, there were some puzzles. One was about finding the top 5 horses among 25 horses, and another involved 9 identical balls, one of which is lighter than the others. The task was to determine the minimum number of weighings needed to identify the lighter ball. There was a guesstimate question asking how many coffee cups are used in a day at the Zomato office.
Regarding my prior work and experience
What would you like to do in the future
Parle moi de ton expérience.
Design a database system for storing information related to your favorite sitcoms, how many tables would be there and write some queries for fetching the most appearing special characters across all sitcoms.
Talk about xx experience on your resume.
For the product case study I was simply asked to thing aloud in response to a series of questions about how I might use data to inform product decisions.
There was a test on SQL and dashboard building.
2 minutes of self introduction
Tell me about yourself and why you're interested in this role.
Viewing 1871 - 1880 interview questions