Meesho Interview Questions, Process, and Tips

3 coding questions on hackerrank medium to hard

Q1. Doctor low level system design question
Add your answer

Sql query error validation and analytics querying for test case

Q1. Ab testing experiment based aptitude
Add your answer
Q2. Sql query to find longest streak of orders by customer
Ans. 
Use SQL query to find longest streak of orders by customer
• Use window functions like ROW_NUMBER() to assign a sequential number to each order for each customer

• Partition the data by customer and order the rows by order date

• Calculate the difference between the sequential numbers to identify streaks of consecutive orders

• Select the maximum streak length for each customer
Answered by AI
Add your answer

Q1. Mostly Advance SQL question on some random cases
Add your answer
Q2. Some advance SQL theory questions
Add your answer

Sql questions and excel questions

Q1. Sql question was asked to find the nth value
Add your answer
Q2. Sql question based on rank and dense rank
Add your answer

Q1. Why is meesho suitable for u
Ans. 
Meesho is suitable for me because of its innovative business model, growth opportunities, and positive work culture.
• Innovative business model allows for flexible work hours and remote work options.

• Opportunities for growth and advancement within the company.

• Positive work culture that values employee well-being and encourages collaboration.

• Meesho's focus on empowering women entrepreneurs aligns with my values and interes
Answered by AI
Add your answer
Q2. What are the strength and weaknesses
Ans. 
Strengths include analytical skills, problem-solving abilities, and communication skills. Weaknesses may include lack of technical expertise or industry knowledge.
• Strengths: analytical skills, problem-solving abilities, communication skills

• Weaknesses: lack of technical expertise, lack of industry knowledge
Answered by AI
Add your answer

Q1. I like to this job
Add your answer
Q2. This job is very helpful
Add your answer
Q3. Very easy and helpful job
Add your answer

3 Medium level dsa questions

Q1. Lld of cab booking system
Ans. 
The Low Level Design (LLD) of a cab booking system involves detailing the system architecture and components at a lower level of abstraction.
• Identify the main components of the system such as user interface, booking engine, payment gateway, and driver allocation algorithm.

• Define the interactions between these components and how data flows between them.

• Specify the data structures and algorithms used for efficient bookin...read more
Answered by AI
Add your answer
Q2. Discussion about online assesment
Add your answer