Flipkart Data Analytics Lead Interview Questions and Answers

Basic SQL questions around windows function

Q1. Guesstimate : Number of lamp posts in Delhi
Ans. 
It is estimated that there are around 2 million lamp posts in Delhi.
• Estimate based on population density and urban infrastructure development

• Consider factors like road length, area covered, and lighting requirements

• Assume an average of 1 lamp post per 100 meters of road

• Take into account different types of areas like residential, commercial, and industrial

• Use satellite imagery or government data for more accurate estima
Answered by AI
Add your answer
Q2. Conversion is down RCA
Add your answer

Conversion is going Down : Deepdive case study

Q1. Why want to join?
Ans. 
I am passionate about using data to drive strategic decisions and improve business outcomes.
• I have a strong background in analytics and data-driven decision making.

• I am excited about the opportunity to work with a talented team and contribute to the success of the organization.

• I believe that my skills and experience align well with the goals of the company.
Answered by AI
Add your answer
Q2. Career aspirations
Add your answer