Job interview experience of Myntra for the post of Data Analyst

My 16th Data Interview experience

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.

Date:22/05/21
For Linkedin Post Please Click Here