Solicité el puesto a través de una agencia de empleo. El proceso duró 2 meses. Acudí a una entrevista en Flipkart (Bengaluru) en mar 2014
Entrevista
Very structured process for Analytics there are several rounds
- starting with Aptitude test (moderate difficulty level like entrance exam MAT)
- Problem solving and business understanding round, mostly telephonic ask puzzles
- Data handling round which includes creating data structure and working on excel
- one round have two to three business case to solve
- Hiring manager round on soft aspects like why join and other
Preguntas de entrevista [1]
Pregunta 1
Puzzle- socks puzzle
Business Case - estimate market size of hindi e books
Solicité el puesto por otro medio. El proceso duró 1 día. Acudí a una entrevista en Flipkart (Chennai) en sept 2025
Entrevista
I got the interview call through Instahyre website. The interviewer was patient and friendly. The questions asked were:
1) Introduce about yourselves.
2) What is your exposure to Python and SQL. Rate it in 10.
3)Create dataframe for an app that you commonly use?
4)Write a sql query to fetch top 5 influencers from Chennai in facebook
5)How do you handle data training in python?
6)How do you handle outliers in dataset?
7)What are the assumptions for linear regression in python
8)What is dimension table and fact table? What are the differences?
9)What is the difference between union and union all in sql?
10)What is the difference between delete and truncate statement in sql?
11)What is the default kind of join?
12)What is the difference between primary key and foreign key?
Preguntas de entrevista [1]
Pregunta 1
Introduce about yourselves and your work history. Questions would be centered around your SQL, Python knowledge and your day to day app usage.
Aptitude, Technical Skill, Organisational fit. Started with pen and paper round of aptitude test. After clearing first round, be prepared for some SQL grinding. After that you will have one round of interview process with business questions. Then final round will be cultural fit.
Solicité el puesto a través de la recomendación de un empleado. Acudí a una entrevista en Flipkart
Entrevista
4 rounds
1) probability questions MCQ
2) Technical interview (SQL, Data Engineering) and puzzles
3) Case study - overall
4) case study - Deep dive (expected to answer with the help of Machine Learning)
Preguntas de entrevista [1]
Pregunta 1
1) Create a star schema and SQL questions were framed from that
2) How to define an optimal return window for a product sold in Flipkart