meesho logo
Meesho· Business analyst

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

Result
Rejected
Location
Bengaluru
Posted
18 Oct 2024
352 reads

Summary

I interviewed for a Business Analyst role at Meesho in August 2024, which started with an online assessment followed by a technical interview primarily focused on SQL. Unfortunately, I was rejected after the first interview round and did not proceed to the second.

How it went

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.

Questions asked (1)

  1. 01

    SQL Output with Window Functions

    Data Structures & Algorithms

    Given a sample database table structure and data, predict the output of various SQL queries. These queries specifically involve advanced SQL concepts such as window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). The task was to understand the behavior of these functions and how they apply to the given dataset.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Meesho recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!