Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Myntra Team. If you also belong to the team, you can get access from here

Myntra Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Myntra Business Analyst Interview Questions and Answers for Experienced

Updated 27 Oct 2024

Myntra Business Analyst Interview Experiences for Experienced

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Coding Test 

SQL queries based on e-commerce platform. Warehouse and data modelling related questions.

Round 2 - Case Study 

How to improve delivery system and logistics in e-commerce platform?

Interview questions from similar companies

I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions were from SQL, Python, Statistics & Business Case Studies/Metrics in the form of 4-5 rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - So Key Takeaway is You have to be good with your Technical Knowledge (SQL Expert, Python, Overall Stats Knowledge) and That is not really enough. What differs a Business Analyst from other Developers/Statisticians etc. is Business acumen, Problem Solving Skills etc. To have a Business Knowledge and Understanding such that you find the problems/solutions/ Metrics and then solve them using the Technology.

I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How can you reduce the delivery time of the order?
  • Ans. 

    Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.

    • Analyze the supply chain and identify bottlenecks

    • Implement automation tools to streamline processes

    • Improve communication between departments and with customers

    • Use data analytics to forecast demand and plan accordingly

    • Consider outsourcing or partnering with third-party logistics providers

    • Invest in tec...

  • Answered by AI
  • Q2. Questions based on Case Studies

Interview Preparation Tips

Interview preparation tips for other job seekers - The process consisted of two rounds. First was the business analysis kind of round which included the questions like how can you reduce the delivery time of the order? The second round was technical round where the person asked the questions on SQL and Excel

I applied via IIM Jobs and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Advance SQL Questions.
  • Q2. Multiple Approaches in the SQL questions were seen. Some unconventional SQL Syntax was also asked.
  • Q3. Metrics Driven Case studies.
  • Q4. More number of solutions were seen instead of in depth implementation of 1 solution. Good Communication skills is judged.
  • Q5. Tell me something about yourself.
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration with a focus on analytics.

    • I have experience working with cross-functional teams to gather and analyze business requirements.

    • I am proficient in using tools such as Excel, SQL, and Tableau for data analysis and visualization.

    • I have successfully im...

  • Answered by AI
  • Q6. Why quit last job.
  • Ans. 

    Seeking better growth opportunities and work-life balance.

    • Limited growth prospects in previous role

    • Lack of work-life balance

    • Desire for new challenges and learning opportunities

    • Company culture misalignment

    • Relocation or commute issues

    • Better compensation or benefits elsewhere

  • Answered by AI
  • Q7. Why Meesho.
  • Ans. 

    Meesho is a leading e-commerce platform that empowers individuals to start their own online businesses.

    • Meesho provides a user-friendly platform for individuals to sell products online without any investment.

    • It offers a wide range of products from various categories, allowing sellers to cater to different customer preferences.

    • Meesho provides extensive training and support to its sellers, helping them succeed in their on...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, It's very similar to any other business analyst interview in industry.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. SQL, Case study, and puzzles.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, case study, and Puzzles. That's what I was asked.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Case Study 

Normal discussion about guesstimates

I applied via Referral and was interviewed in Apr 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Understanding of Basic SQL was checked. Writing Basic SQL queries with where condition. SQL query question using Analytical function. ( 2nd most revenue-generating country) Difference between Rank and Dens...
Round 3 - Case Study 

Guestimate the number of people travelling in Metro at 6:30pm on weekday.
Case Study- Funnel Drop in a value chain( customer journey)
find out the reasons, and give the ideas to overcome and rank the ideas based on priority.

Round 4 - One-on-one 

(1 Question)

  • Q1. Business Round with Project Manager: Basically, tell about yourself more(not about work), what kind of person you are, future plans, expectations from the company, what you know about spinny, are you rea...

Interview Preparation Tips

Interview preparation tips for other job seekers - Solve Many Guestimates as much as you can.
Learn all techniques and difference type of Case Studies how to solve.
Increasing your business skills by watching different business case studies.
Learn SQL.

I applied via Naukri.com and was interviewed in Sep 2021. There were 4 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Problem statement - What data would you need to reduce air polutation in NCR?
  • Ans. 

    To reduce air pollution in NCR, data on sources of pollution, weather patterns, and population density is needed.

    • Sources of pollution such as industries, vehicles, and construction sites

    • Weather patterns such as wind direction and speed, temperature, and humidity

    • Population density and distribution to identify areas with high pollution levels

    • Data on emissions from power plants and factories

    • Information on the types of veh...

  • Answered by AI
  • Q2. Difference between drop, delete and truncate.
  • Ans. 

    Drop, delete and truncate are SQL commands used to remove data from a table.

    • DROP command removes the entire table and its data

    • DELETE command removes specific rows from the table

    • TRUNCATE command removes all the data from the table

  • Answered by AI
  • Q3. SQL queries -write queries using Subquery, Windows Function etc
  • Q4. Difference between dimension and measure.
  • Ans. 

    Dimensions are attributes used to group data while measures are numerical values used to perform calculations.

    • Dimensions are qualitative data while measures are quantitative data.

    • Dimensions are used for slicing and dicing data while measures are used for analysis and calculations.

    • Examples of dimensions include date, location, and product while examples of measures include sales, profit, and quantity.

    • Dimensions are ofte...

  • Answered by AI
  • Q5. What are parameters in Tableau
  • Ans. 

    Parameters in Tableau are user-defined values that can be used to control aspects of a visualization.

    • Parameters allow users to interact with a visualization by changing values such as filters, calculations, and reference lines.

    • They can be used to create dynamic visualizations that respond to user input.

    • Parameters can be created by right-clicking on a field or by selecting 'Create Parameter' from the Analysis menu.

    • Examp...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practise SQL queries. Topics - Aggregate function, Windows Function, sub queries.
Should know basics of Tableau.
Have hands on with Tableau, SQL and Excel.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. About business analyst , document
  • Q2. Documents realted
Round 2 - Technical 

(2 Questions)

  • Q1. About documentation like BRD
  • Q2. Scenarios based que

Interview Preparation Tips

Interview preparation tips for other job seekers - Think twice before joining firstcry. If you want to work stress free than don’t join this company
Round 1 - One-on-one 

(1 Question)

  • Q1. SQL related question asked like Window function, Rank, dense rank, Intermediate to hard level questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Do intermediate SQL and practice questions on case based and window function

Myntra Interview FAQs

How many rounds are there in Myntra Business Analyst interview for experienced candidates?
Myntra interview process for experienced candidates usually has 2 rounds. The most common rounds in the Myntra interview process for experienced candidates are Coding Test and Case Study.
How to prepare for Myntra Business Analyst interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Myntra. The most common topics and skills that interviewers at Myntra expect are Business Analysis, SQL, Advanced Excel, Business Planning and Data Analysis.
What are the top questions asked in Myntra Business Analyst interview for experienced candidates?

Some of the top questions asked at the Myntra Business Analyst interview for experienced candidates -

  1. I hevn't Got a callback Frm u ...read more
  2. given a table and asked to perform all kinds of jo...read more
  3. Y r u planing attent to my ...read more

Tell us how to improve this page.

Myntra Business Analyst Interview Process for Experienced

based on 1 interview

Interview experience

5
  
Excellent
View more
Myntra Business Analyst Salary
based on 43 salaries
₹6 L/yr - ₹19 L/yr
17% more than the average Business Analyst Salary in India
View more details

Myntra Business Analyst Reviews and Ratings

based on 5 reviews

3.6/5

Rating in categories

3.9

Skill development

2.4

Work-life balance

3.6

Salary

4.2

Job security

4.2

Company culture

2.9

Promotions

3.8

Work satisfaction

Explore 5 Reviews and Ratings
Data Analyst
252 salaries
unlock blur

₹5 L/yr - ₹18.4 L/yr

Manager
207 salaries
unlock blur

₹6.5 L/yr - ₹24 L/yr

Senior Manager
191 salaries
unlock blur

₹13.2 L/yr - ₹35.5 L/yr

Senior Assistant
184 salaries
unlock blur

₹1.5 L/yr - ₹5 L/yr

Associate
183 salaries
unlock blur

₹3 L/yr - ₹12 L/yr

Explore more salaries
Compare Myntra with

Flipkart

3.9
Compare

Amazon

4.0
Compare

Meesho

3.7
Compare

LimeRoad

2.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview