i
Myntra
Filter interviews by
I applied via Job Portal and was interviewed in Apr 2024. There was 1 interview round.
Create a pivot table and sort the data in ascending order.
To create a pivot table, select the data range and go to the 'Insert' tab in Excel.
Choose 'PivotTable' and select the location for the pivot table.
Drag the desired fields to the 'Rows' and 'Values' areas.
To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.
Using lookup with product-based data to find the needed data.
Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data
Identify the key or unique identifier to match the data
Specify the range or table where the data is located
Retrieve the desired data based on the lookup value
What people are saying about Myntra
I applied via Referral and was interviewed in Feb 2021. There were 4 interview rounds.
Myntra interview questions for designations
I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.
I applied via Job Portal
SQL and Python data analysis questions
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
Use string matching techniques like exact match, partial match, or fuzzy matching.
Apply data cleaning and preprocessing techniques to standardize the data before matching.
Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.
Consider using database join...
I applied via Campus Placement and was interviewed in Nov 2024. There were 4 interview rounds.
Questions from arrays and strings and some aptitude questions
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
Open both CSV files in a software like Microsoft Excel.
Copy the data from one CSV file and paste it into the other CSV file.
Save the merged CSV file with a new name.
Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.
Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.
Company culture - I value a positive work environment and the...
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
2 SQL questions asked
I appeared for an interview before Oct 2023.
Some of the top questions asked at the Myntra Data Analyst interview for experienced candidates -
The duration of Myntra Data Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 2 interviews
1 Interview rounds
based on 35 reviews
Rating in categories
Data Analyst
252
salaries
| ₹5 L/yr - ₹19 L/yr |
Manager
207
salaries
| ₹6.5 L/yr - ₹24 L/yr |
Senior Manager
191
salaries
| ₹13.2 L/yr - ₹35.5 L/yr |
Senior Assistant
184
salaries
| ₹1.5 L/yr - ₹5 L/yr |
Associate
183
salaries
| ₹3 L/yr - ₹12 L/yr |
Flipkart
Amazon
Meesho
LimeRoad