Flipkart
Indian e-commerce giant tackling massive supply chain and scale problems.
4 Rounds
~18 Days
Hard
The Interview Loop
Recruiter Screen (30 min)
Standard fit check, behavioral questions, and resume overview.
Technical Loop (3-4 Rounds)
Deep dive into domain knowledge, coding, and system design.
Interview Question Bank
Backend Engineer
•
Technical
•
medium
Write a SQL query to find the top 3 selling products in each category for the last month, considering ties in sales volume.
#Window Functions
#Joins
#Aggregations
Machine Learning Engineer
•
Technical
•
medium
Write a SQL query to find the top 3 best-selling products in each category during the Big Billion Days sale, given a 'sales' and a 'products' table.
#Window Functions
#Aggregations
#Joins
Machine Learning Engineer
•
Technical
•
medium
Write a SQL query to calculate the 7-day rolling average of daily sales for each product.
#Window Functions
#Time Series
Product Manager
•
Coding
•
easy
Write a SQL query to find the top 5 categories by GMV in the last 30 days, excluding cancelled orders.
#Data Extraction
#Aggregation
#Filtering
Product Manager
•
Coding
•
hard
Write a SQL query to calculate the month-over-month retention rate of users who made their first purchase in January.
#Cohort Analysis
#Retention
#Advanced SQL
Software Engineer
•
Technical
•
medium
Write a SQL query to find the top 3 highest-selling products in each category.
#SQL
#Window Functions
Difficulty Radar
Based on recent AI-sourced data.
Meet Your Interviewers
The "Standard" Interviewer
Senior EngineerFocuses on core competencies, system constraints, and clear communication.
SimulateUnwritten Rules
Think Out Loud
Always explain your thought process before writing code or drawing architecture.