Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 4 settimane. Ho sostenuto un colloquio presso Flipkart nel mese di apr 2021
Colloquio
The process took over 4 weeks. I applied through a friend's referral.
Following were the rounds (for anyone who is preparing):
1. Telephonic round: little over 30 minutes over a phone call assessing overall fitment, more of a screening round. Asked about my projects, my role & experience followed by a case study (Customer churn problem)
2. Problem solving round: Couple of case studies and a math puzzle
3. Data handling: Entirely on SQL, joins, window functions and other simple select statements. You dont need to know all syntaxes you can also write a pseudo codes and explain your process flow. Followed by a database schema round (Had t explain what kind of tables and unique keys in them would i have if i was to create a database for Bengaluru road transport)
4. Analytical solutioning: Similar to problem solving round but more detailed in nature
5. Overall fitment: Cross section of previous round and some behavioral questions
6. HR: 30 minute round. All of them behavioral questions.
Tip: Be very active during all the interview rounds, its okay to make mistakes and give wrong answers but explain what you were thinking and why you thought that might work.
Domande di colloquio [1]
Domanda 1
Difference between unique key and primary key
Difference between left join and left outer join
Case studies on churn, loyalty, offers & recommendation
Ho presentato la mia candidatura tramite un'altra fonte. La procedura ha richiesto un giorno. Ho sostenuto un colloquio presso Flipkart (Chennai) nel mese di set 2025
Colloquio
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?
Domande di colloquio [1]
Domanda 1
Introduce about yourselves and your work history. Questions would be centered around your SQL, Python knowledge and your day to day app usage.
Ho sostenuto un colloquio presso Flipkart (Bengaluru)
Colloquio
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.
Ho presentato la mia candidatura tramite segnalazione di un dipendente. Ho sostenuto un colloquio presso Flipkart
Colloquio
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)
Domande di colloquio [1]
Domanda 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