Blinkit is hiring for Product Manager Role | Apply Now

Candidates may get tasks like:

Calculate retention rate
Find top-performing users
Analyze revenue trends
Aggregate transaction data
Detect anomalies

No Machine Learning or Data Visualization required.

5. SQL Section

The SQL round is conducted using DuckDB, which supports standard SQL syntax.

Topics to Prepare
SQL Basics
SELECT
WHERE
GROUP BY
HAVING
ORDER BY
SQL Joins
INNER JOIN
LEFT JOIN
RIGHT JOIN
Window Functions
ROW_NUMBER()
RANK()
DENSE_RANK()
Aggregations
COUNT()
SUM()
AVG()
MAX()
MIN()
Example SQL Concepts

Candidates may be asked to:

Find top customers
Calculate conversion percentages
Rank products by sales
Identify repeat users
Analyze cohort retention
SQL Query Example
SELECT
user_id,
COUNT(*) AS total_orders
FROM orders
GROUP BY user_id
ORDER BY total_orders DESC;
Important Test Instructions

Before starting the assessment:

Do:
Use laptop or desktop
Keep charger connected
Use Google Chrome
Close unnecessary tabs
Practice sample tests
Avoid:
Switching browser tabs frequently
Refreshing during coding sections
Unstable internet connections
Time Management Strategy
Suggested Time Split
Section Recommended Time
MCQs 35–40 Minutes
Python 25 Minutes
SQL 20 Minutes
Review 5 Minutes
Best Strategy to Crack the Assessment
1. Solve Easy MCQs Quickly

Do not spend too much time on one question.

2. Practice Pandas Daily

Most candidates lose marks in:

groupby
merge
rolling functions
3. Learn Window Functions in SQL

ROW_NUMBER and RANK are frequently asked.

4. Understand Product Metrics

Many companies focus heavily on:

retention
conversion
funnel metrics
5. Focus on Business Thinking

The test checks decision-making ability, not just coding.