Meesho | Business analyst | Bengaluru | Aug 2024 [Reject]

My interview process for the Business Analyst position at Meesho began with an online assessment. This assessment was 90 minutes long and consisted of 25 multiple-choice questions along with 3 SQL queries to solve.

Following the online assessment, I had a technical interview. This round lasted between 20-30 minutes. We started with mutual introductions, and then the interviewer shared a document containing questions where I was expected to type my answers directly.

The questions in the technical interview were primarily SQL-based:

• The first question involved analyzing a given database schema and then predicting the output of several SQL queries that extensively used window functions like ROW_NUMBER(), RANK(), and DENSE_RANK().
• The second question asked me to write a straightforward SQL query based on applying a WHERE condition to the database.
• The third question required me to construct a query involving grouping data and using a HAVING clause.
• The final question was described as a hard-level SQL query, necessitating the use of subqueries and WITH statements.

Although I completed this round, I was unfortunately not shortlisted to proceed to the second interview round.