Flipkart Data Engineer Interview Questions & Practice

Flipkart Data Engineering interviews are SQL-heavy with strong Spark and data-modeling rounds — commerce-scale problems like order dedup, rolling GMV metrics and funnel analytics. Practice matching question styles below.

Practice challenges

• Latest Order Per Customer (sql, easy, +50 XP)
• Customers With at Least One Order (sql, easy, +50 XP)
• Customers Who Have Never Placed an Order (sql, easy, +50 XP)
• Total Amount Spent Per Customer (With Zero) (sql, easy, +50 XP)
• E-commerce: Customers Who Placed an Order (IN Subquery) (sql, easy, +50 XP)
• E-commerce: Count Orders Per Customer (sql, easy, +50 XP)
• E-commerce: Customers With No Orders (NOT IN) (sql, easy, +50 XP)
• Retail: Total Amount Spent Per Customer (sql, easy, +50 XP)
• ROW_NUMBER: Assign Unique Rank to Each Employee (sql, easy, +50 XP)
• RANK: Rank Employees by Salary (With Gaps) (sql, easy, +50 XP)
• SUM OVER: Calculate Running Total of Daily Sales (sql, easy, +50 XP)
• LEAD: Show Next Day's Sales Amount (sql, easy, +50 XP)
• ROW_NUMBER: Remove Duplicate Rows and Keep One Per Order (sql, easy, +50 XP)
• Orders: List Orders With Customer Names (INNER JOIN) (sql, easy, +50 XP)
• Customers Who Never Placed an Order (sql, easy, +50 XP)
• Find Average Order Amount for Each Customer (sql, easy, +50 XP)
• Find Customers Who Placed More Than 5 Orders (HAVING) (sql, easy, +50 XP)
• Find the Most Recent Order Date for Each Customer (sql, easy, +50 XP)
• Find Customers Who Spent More Than ₹1000 in Total (HAVING SUM) (sql, easy, +50 XP)
• Find the Customer Who Placed the Most Orders (sql, easy, +50 XP)

What is asked in Flipkart Data Engineer interviews?

Hands-on SQL (window functions, rolling metrics), Spark transformations, data modeling for commerce events, and pipeline troubleshooting scenarios.

Not affiliated with Flipkart. All companies · Free challenges · DE jobs