Meesho Interview Experience | Full Time

Last Updated : 23 Oct, 2024

Company: Meesho

Online Assessment

  • Duration: 90 minutes
  • Format:
    • 25 Multiple Choice Questions (MCQs)
    • 3 SQL Queries

Interview Process

The interview comprised one technical round lasting between 20 to 30 minutes.

Interview Breakdown:

  1. Introduction: The interview began with both of us introducing ourselves.
  2. Technical Questions:
    • The interviewer provided a document containing questions, and I was required to type my answers directly into it.
    • Question 1: A database-related question requiring the use of ROW_NUMBER(), RANK(), and DENSE_RANK() functions. I needed to explain the expected output.
    • Question 2: Write a SQL query for a given database that involved applying a WHERE condition.
    • Question 3: A query based on grouping and using the WHERE clause.
    • Question 4: A complex SQL query that required the use of subqueries and a WITH statement.

Outcome:

There was a second round, but I was not shortlisted for it.

Comment

Explore