I applied through a staffing agency. The process took 3 weeks. I interviewed at Flipkart (Bengaluru) in Feb 2020
Interview
Around 50 people were called,and we were asked to sit in different rooms. We were asked to write a SQL test and after that 3 rounds interview.
1st round - SQL , if you are owner of Uber how will your database look like, how to get details for given use cases. eg: users who drove only once etc
2nd : guess estimates, no of black cars in Bangalore
3rd : Manager round : how will you handle pressure, business problems
The process took 5 weeks. I interviewed at Flipkart
Interview
Got call from recruiter and had around 30 minutes if discussion on my background and experience.
Then had 5 rounds of interviews each around 30-40 minutes. Had first two rounds technical and the next 3 rounds managerial at director level.
The first interview was fine but the subsequent rounds were bad. In the 2nd round the interviewer was asking open ended questions and when I answered based on my assumption he was not okay with it. He had very basic knowledge of Python and sql so didn’t really ask any case studies but was asking very general questions.
The managerial rounds were more like, “we know we won’t hire you but we’ll waste your time” type. Their hiring process is not good, if a candidate is not suitable and there is negative feedback then don’t setup next round and tell him upfront. Why waste time? After all rounds they asked me for documents, I uploaded but no response from HR after that. Sick mentality of the HRs and interviewers!!
Interview questions [1]
Question 1
What are the factors based on which you would decide if a customer should be refunded the amount for late delivery?
