Myntra for the post of Data Analyst

An old interview experience of Akash Raj

My 16th Data Interview experience

Company: Myntra
Role: Data Analyst

Introduce yourself.

One complex sql query- 2 table are there, Table1(cust_id,Name) Table2(cust_id,Transaction_amt)
Write a query to return the name of customers with 8th highest lifetime purchase.

Achieve the same using python.

ML questions:

What’s the problem in having multi collinearity in data set.
If there is business requirement to keep two corelated features in model, what would you do.
How would you deal with feature of 4 categories and 20% null values.

Some questions based on my project.

Scroll to Top