The process took 4 weeks. I interviewed at Flipkart (Bengaluru)
Interview
I was contacted by HR for this role. After that I had 2 telephonic rounds then they called me to Flipkart office for more rounds. I had to give 5 more rounds. HR told me that the feedback was positive from interviewers and will let me know in next week but I didn't receive the call from them. When I called HR, she said that hiring committee did not select me and they can't take it forward. Utter waste of time. They could have told me in the beginning where they did not find me good. Why did they had to take all the rounds and give false hope that the feedback was positive from interviewers? Also interviewers themselves were not strong technically. Hated the problem solving round cause interviewer was very rude from the start. He was not even listening. The reason they told me does not make sense. They literally wasted time. Very disappointed with Flipkart.
I applied through other source. The process took 1 day. I interviewed at Flipkart (Chennai) in Sept 2025
Interview
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?
Interview questions [1]
Question 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.
I applied through an employee referral. I interviewed at Flipkart
Interview
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)
Interview questions [1]
Question 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
