Prepare for and practice interview questions from Meesho.

Meesho Interview Questions

Meesho Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Meesho Salaries by Position

Job Description: About the RoleAs a Senior Business Analyst, you will work on improving the reporting tools, methods, and processes of the team you are assigned to. You will also create and deliver weekly, monthly, and quarterly metrics critical for tracking and managing the business. You will manage numerous requests concurrently and strategically, prioritizing them when necessary.You will actively engage with internal partners throughout the organization to meet and exceed customer service levels and transport-related KPIs. You will brainstorm simple, scalable solutions to difficult problems, and seamlessly manage projects under your purview. You will maintain excellent relationships with our users – and in fact, advocate for them – while keeping in mind the business goals of your team. What you will do<ul><li>Create various algorithms for optimizing demand and supply data</li><li>Conduct analysis and solution-building based on insights captured from data</li><li>Give insights to management and help in strategic planning</li><li>Analyze metrics, key indicators and other available data sources to discover root causes of process defects</li><li>Support business development and help to create efficient designs and solution processes</li><li>Determine efficient utilization of resources</li><li>Research and implement cost reduction opportunities</li></ul> Must have skills<ul><li><a>B.Tech/M.Tech</a> /MBA in any discipline</li><li>2+ years of experience as a Business Analyst</li><li>Proficiency in Advanced Excel and Advanced SQL (must-have) and Python(must have)</li><li>Understanding of basic statistics and probability concepts</li><li>Proven problem-solving skills</li></ul>

Meesho Interview Questions

Meesho Interview Guides

Meesho Interview Questions

Meesho Salaries by Position

Meesho Opening Jobs