Meesho Interview Experience | Full Time

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.