Meesho Business Analyst Interview Questions + Guide in 2024

Meesho is a fast-growing Indian social commerce platform that enables small businesses and individuals to start their own online stores with zero investment. Meesho connects suppliers with resellers by providing easy-to-use tools to expand their reach and grow their businesses. With a focus on empowering entrepreneurs, Meesho leverages technology to democratize e-commerce nationwide.

This guide will help you navigate the interview process, equip you with key insights, provide Meesho business analyst interview questions, and boost your chances of securing the role. Let’s get started!

The interview process usually depends on the role and seniority. However, you can expect the following in a Meesho business analyst interview:

Resume Shortlisting

Once you submit your application, it undergoes a shortlisting process. Meesho’s hiring team evaluates your CV to ensure you meet the qualifications required for the role.

Hackerrank Test

Successful candidates will be invited to complete an online assessment via Hackerrank. This test typically includes 3 SQL coding questions to be solved within 60 minutes with webcam proctoring. The questions can range from intermediate to difficult levels and focus on SQL queries, joins, window functions, and DBMS concepts.

1-on-1 Interview Rounds

If you pass the Hackerrank test, you will proceed to the next stage, which involves multiple 1-on-1 interview rounds:

1. SQL Queries Round: This interview includes detailed questions about SQL queries, database management systems (DBMS), and potentially Python coding. Be prepared to solve complex SQL problems and demonstrate your database knowledge.

2. Technical Round: This round can cover a variety of technical topics, such as case studies, root cause analysis (RCA), business scenarios, and guesstimates. Ensure you are well-prepared for these types of questions.

Behavioral Round (Bar Raiser)

In this round, the focus is on your behavioral attributes and cultural fit within Meesho. HR or senior team members may ask you about your past experiences, how you handle difficult situations, and other behavioral questions.

Onsite Interview Rounds (If Applicable)

Depending on the role and the ongoing circumstances, Meesho may invite you for onsite interviews. These would typically involve additional technical discussions, case studies, and possibly a final evaluation round.

Offer and Negotiation

If you clear all interview rounds, Meesho will proceed with the offer and negotiation phase. You will be informed about the next steps and your compensation package.

Typically, interviews at Meesho vary by role and team, but commonly Business Analyst interviews follow a fairly standardized process across these question topics.

1. Create a function sum_pair_indices to find indices of two integers in an array that add up to a target integer.

Given an array and a target integer, write a function sum_pair_indices that returns the indices of two integers in the array that add up to the target integer. If not found, just return an empty list. Ensure the solution runs in (O(n)) time and does not use the same index twice.

2. How would you set up an A/B test for multiple changes in a sign-up funnel?

A team wants to A/B test changes in a sign-up funnel, such as changing a button from red to blue and/or moving it from the top to the bottom of the page. How would you set up this test?

3. Where and how could you promote Instagram through Facebook?

You work on the growth team at Facebook and need to promote Instagram within the Facebook app. Where and how would you promote Instagram through Facebook?

4. What metrics/graphs/models would you use to analyze churn behavior for different pricing plans?

You work for a company like Netflix with two pricing plans: $15/month or $100/year. An executive wants you to analyze the churn behavior of users subscribed to either plan. What metrics, graphs, or models would you build to provide an overarching view of subscription performance?

5. What analysis would you run for non-normal distribution in an A/B test with low data?

Uber Fleet has low data for experimentation, and you find the distribution is not normal in an A/B test. What kind of analysis would you run, and how would you measure which variant won?

6. What retention rate is required to surpass revenue from a non-subscription price?

You sell an e-commerce product for $29 with a 50% per unit margin. You want to switch to a monthly subscription model at a 20% discount on the retail price. What retention rate would be required to surpass the revenue from the non-subscription price?

7. How would you explain what a p-value is to someone who is not technical?

Explain the concept of a p-value in simple terms to a non-technical person, focusing on its role in determining the significance of results in an experiment or study.

8. What could be the cause of the decrease in overall capital approval rates?

Analyze why the overall capital approval rate dropped from 85% to 82% despite individual product approval rates staying flat or increasing. Consider factors such as changes in the mix of products or external influences.

9. What is the probability that both flips result in the same side with one fair and one biased coin?

Calculate the probability that both flips result in the same side when selecting a coin at random, where one coin is fair and the other has a ³⁄₄ probability of landing heads.

10. What is the percentage chance a review is actually fake when the algorithm detects it as fake?

Determine the probability that a review is fake given that the machine learning algorithm has identified it as fake, considering the base rates and accuracy of the algorithm.

11. What metrics would you use to track accuracy and validity of a spam classifier model?

Assume you have built a V1 of a spam classifier for emails. What metrics would you use to evaluate the model’s accuracy and validity?

12. When would you use a bagging algorithm versus a boosting algorithm?

Compare two machine learning algorithms. In which scenarios would you prefer a bagging algorithm over a boosting algorithm? Provide examples of the tradeoffs between the two.

13. What are the assumptions of linear regression?

List and explain the key assumptions underlying linear regression models.

14. How would you build a restaurant recommender on Facebook?

Describe how you would gather data and build a restaurant recommendation system for Facebook. What potential issues or concerns might arise from adding this feature?

15. How would you design the YouTube video recommendation algorithm?

Explain how you would design a recommendation system for YouTube videos. What important factors should be considered when building this recommendation algorithm?

You should plan to brush up on any technical skills and try as many practice interview questions and mock interviews as possible. A few tips for acing your Meesho business analyst interview include:

• Master SQL and DBMS Concepts: Given that a significant part of the interview process revolves around SQL queries and database management, make sure you are proficient in these areas, especially with complex queries and window functions.
• Prepare for Case Studies and Guesstimates: Meesho places a strong emphasis on business scenarios and analytical thinking. Practice solving different business case studies and guesstimates to demonstrate your problem-solving skills.
• Showcase Relevant Experience: Be prepared to discuss your past projects and how they align with the responsibilities of the role you’re applying for. Ensure that you can clearly articulate your work and its impact.

What is the average salary for a Business Analyst at Apixio?

According to Glassdoor, Business Analyst at Meesho earn between $97K to $101K per year, with an average of $99K per year.

What specific skills and experience are Meesho looking for in a Business Analyst?

Meesho seeks candidates with proven experience in enterprise systems analysis, particularly in supporting digital sales and marketing teams. They value expertise in eCommerce platforms, digital marketing analytics, and project management. Familiarity with manufacturing processes, strong communication skills, and experience with relevant software solutions like Salesforce and Adobe Experience platforms are highly desirable.

What types of projects will I work on as a Business Analyst at Meesho?

As a Business Analyst at Meesho, you will work on projects related to the integration, optimization, and effective utilization of enterprise systems to drive digital sales and marketing initiatives. You’ll collaborate with various departments to ensure technology solutions align with business objectives, and you’ll play a key role in process improvements and system performance monitoring.

What is the company culture like at Meesho?

Meesho fosters a collaborative and innovative culture. They emphasize diversity, teamwork, and continuous learning. The company values proactive problem-solving and encourages employees to engage in ongoing professional development.

As the digital landscape continues to evolve, Meesho remains steadfast in its quest for top-tier Business Analysts to drive their digital sales and marketing endeavors. With a focus on both technical prowess and team alignment, Meesho offers a collaborative and dynamic environment where you can truly unleash your potential.

If you want more insights about the company, check out our main Meesho Interview Guide, where we have covered many interview questions that could be asked. Additionally, explore our interview guides for other roles such as data engineer and data scientist to learn more about Meesho’s interview process for different positions.

Good luck with your interview!