AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Myntra
Compare
Filter interviews by
Myntra Senior Data Analyst Interview Questions and Answers
Myntra Senior Data Analyst Interview Experiences
1 interview found
Anonymous
Question in sql based on join advance sql
(1 Question)
- Q1. Most question related to my project python sql
(1 Question)
- Q1. What yourself why you want ti change
Interview Preparation Tips
Interview questions from similar companies
(1 Question)
- Q1. SQL based questions were asked with some puzzles
I applied via Referral and was interviewed in Oct 2023. There were 2 interview rounds.
(3 Questions)
- Q1. Window functions
- Q2. Joins and aggregate functions
- Q3. Abalytical function lag() and lead() question
(1 Question)
- Q1. Guesstimate and Puzzle
Selected
I applied via Campus Placement and was interviewed before Jan 2024. There was 1 interview round.
We had an aptitude test which involved 60 questions in 15 minutes. Of course, no one can solve this fast, but it was about the hit rate / accuracy and volume. Subsequent followed with two guesstimate based rounds and final as HR round which involved asking about college projects, extra curricular experiences and so on.
I applied via LinkedIn and was interviewed before Apr 2022. There were 4 interview rounds.
(1 Question)
- Q1. Where do you see yourself in 5 years
(1 Question)
- Q1. How you will improve health of a marketplace
- Ans.
By analyzing data, identifying pain points, and implementing solutions to improve user experience and trust.
Analyze user behavior and feedback to identify areas of improvement
Implement measures to increase transparency and trust, such as user reviews and seller verification
Provide resources and support for dispute resolution
Encourage diversity and inclusivity in the marketplace to attract a wider range of buyers and se...
(1 Question)
- Q1. How you will design new customer support system
- Ans.
I will design a customer support system that is user-friendly, efficient, and personalized.
Conduct research to understand customer needs and preferences
Identify common customer issues and develop a knowledge base for quick resolution
Implement a ticketing system to track and prioritize customer inquiries
Integrate chatbots and AI to provide 24/7 support
Train support staff to provide personalized and empathetic service
Col...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. SQL, Business cases
Interview Preparation Tips
Aman Tomar
Interview Questionnaire
3 Questions
- Q1. General HR questions, some based on the CV
- Q2. A marketing specific question
- Q3. Weight of an aircraft
- Ans.
The weight of an aircraft is crucial for its performance and safety.
The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.
The weight of an aircraft is measured in pounds or kilograms.
The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.
Aircraft manufacturers provide maximum takeoff and la...
Interview Preparation Tips
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.
Round: Guesstimate Interview
Experience: A very commonly asked guesstimate problem. Ask as many questions as possible to clear out the situation for yourself and get enough hints to solve the problem. Break it down into smaller sections and solve each section individually.
Tips: Follow "case in point", Analytics Vidya and similar blogs and websites to practice more and more guesstimates.
General Tips: There are so many opportunities. You just need one. Be focused on that ONE.
Skill Tips: Take part in discussions among your friends. Read books and quora to get more content. Practice as many questions as possible for aptitude. Discuss problems and have critical analysis sessions to understand things with a company's perspective.
Skills: Communication , Aptitude, Business Acumen
College Name: IIT GUWHATI
Motivation: To learn the operations and Logistics of the e-commerce industry.
Funny Moments: There will be many while you'll be preparing with your friends. :D
All the best.
Interview Questionnaire
1 Question
- Q1. Question 1: General HR questions, some based on the CV Question 2: A marketing specific question
Interview Preparation Tips
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Duration: 40 minutes
Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Duration: 50 minutes
Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.
Skills: Communication And Confidence, Analytical Skills, Business Logic, Business Acumen
College Name: Institute of Management, Nirma University
I was interviewed before Nov 2019.
Interview Questionnaire
6 Questions
- Q1. Visualize a Uber database of drivers and riders(users) and write a SQL query to get the top 100 drivers by city.
- Ans.
SQL query to get top 100 Uber drivers by city
Join drivers and users tables on city
Aggregate driver ratings and count of rides
Order by rating and count of rides
Limit to top 100
- Q2. How do you optimize the listing of Restaurants on Swiggy?
- Ans.
Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.
Analyze user behavior and preferences to understand their needs and preferences
Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time
Optimize search functionality to ensure accurate and relevant results
Collaborate with restaurants to imp...
- Q3. What are the major differences between a Linear Regression and a Logistic Regression?
- Ans.
Linear Regression is used for continuous data while Logistic Regression is used for categorical data.
Linear Regression predicts continuous values while Logistic Regression predicts probabilities.
Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.
Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.
Linear Regression is...
- Q4. What is the Bias Variance trade-off and name some models with high bias and low variance?
- Ans.
Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.
Bias-Variance trade-off is a fundamental concept in machine learning.
High bias models are simple and have low variance, but are inaccurate.
Low bias models are complex and have high variance, but can overfit the data.
Examples of high bias models are linear r...
- Q5. A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
- Ans.
Possible reasons for a car manufacturer's decline in profits by 40% year over year
Decreased demand for cars due to economic downturn
Increased competition from other car manufacturers
Rising production costs and expenses
Decline in consumer confidence and spending
Changes in government regulations impacting the automotive industry
- Q6. If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the de...
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
2 Questions
- Q1. What are tree traversals?
- Ans.
Tree traversals are methods of visiting all nodes in a tree data structure.
There are three types of tree traversals: in-order, pre-order, and post-order.
In-order traversal visits the left subtree, then the root, then the right subtree.
Pre-order traversal visits the root, then the left subtree, then the right subtree.
Post-order traversal visits the left subtree, then the right subtree, then the root.
Tree traversals are ...
- Q2. What is pre-order and post-order?
- Ans.
Pre-order and post-order are traversal methods used in binary trees.
Pre-order: visit root, left subtree, right subtree
Post-order: visit left subtree, right subtree, root
Used to traverse binary trees and perform operations on nodes
Example: Pre-order traversal of binary tree: A, B, D, E, C, F, G
Example: Post-order traversal of binary tree: D, E, B, F, G, C, A
Interview Preparation Tips
Experience: I consulted my seniors for preparation of my resume. I believe that seniors provide the best provide you with the best possible insights in this regards.
Round: Test
Experience: The first round was the written test. There were 8 theoretical questions asked in the paper. The questions were either in the form of puzzles or probability based questions. The first three questions in the paper were compulsory questions and needed to be answered correctly for the rest of your paper to be evaluated; if a particular candidate answered any one of these questions incorrectly then he was rejected then and there. Apart from these 3 questions solving 2 more questions would have assured a candidate’s chance of getting selected for the next round. The duration of the test was of around 40 minutes.
For the written test nearly 300 people appeared out of which 30-40 were shortlisted for the interviews.
Round: Puzzle Interview
Experience: In the interview I was asked few puzzles and few coding problems.
Some puzzles asked were:
1) There are 3 couples (each couple consists of a man and a woman: husband and wife pair) who want to cross a particular river with only one boat available for the voyage. At a time the boat can carry a maximum of 2 people and a woman cannot stay in presence of other male in absence of her husband. All three couples want to cross the river, what are the ways in which this could be done?
2) There are 2 ropes which burn in 60 minutes. How to measure 45 minutes without cutting any of the ropes?
In the coding questions the interviewers did not ask me to write down the complete codes of the problems, they only asked me to suggest some suitable algorithms. In one of the questions they gave me a binary number and asked me to write down the algorithm to calculate the number of one’s in the binary number.
Round: Technical Interview
Experience: In second round of interview I was asked some hardcore programming questions on data structures since I wrote it as my area of interest. Some of the questions asked were:
If you have an array of ‘n+m’ elements and have these ‘n’ elements separately and you have to transfer these n elements in the n+m element slot which already contains the m elements. The transfer has to be done in such a way that all the m+n elements are sorted.
I was asked some puzzles as well. For instance in one of the puzzles, I was given a square consisting of 9 dots on its periphery. I was asked to join those 9 dots using 4 lines without lifting the pencil.
College Name: IIT ROORKEE
Skills evaluated in this interview
Myntra Interview FAQs
Tell us how to improve this page.
Myntra Interviews By Designations
- Myntra Software Developer Interview Questions
- Myntra Software Engineer Interview Questions
- Myntra Data Analyst Interview Questions
- Myntra Product Manager Interview Questions
- Myntra Business Analyst Interview Questions
- Myntra Associate Category Manager Interview Questions
- Myntra Quality Analyst Interview Questions
- Myntra Team Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Data Analyst Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Myntra Senior Data Analyst Interview Process
based on 1 interview
Interview experience
Senior Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
|
Data Analyst
208
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Manager
206
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Assistant
193
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Officer
184
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Manager
178
salaries
| ₹0 L/yr - ₹0 L/yr |
Flipkart
Amazon
Meesho
LimeRoad
- Home >
- Interviews >
- Myntra Interview Questions >
- Myntra Senior Data Analyst Interview Questions
