Dataford
Top 17
Prep plan
Updated weekly · Last refresh Sep 25

Hotstar Product Analyst Interview Questions

The questions to prepare for a Hotstar Product Analyst interview. Questions from real interview reports rank first. Updated daily.

17questions
~3htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 1 drill · ~57 min
Moving Average With Window FunctionsMedium
Practice

Calculate each Hotstar user's 30-day moving average session length with a timestamp-based window function.

Window FunctionsHotstar
Top N Users During Live EventMedium
Practice

Rank the top 3 Hotstar live-event users using joins, conditional aggregation, and ROW_NUMBER().

sql queryHotstar
Optimize Large PostgreSQL Query PerformanceMedium

Explain how to tune slow PostgreSQL queries on multi-million-row tables using indexes, execution plans, joins, and partitioning.

Performance Tuningquery optimizationsqlHotstar
Video Drop-Off SQL QueryMedium
Practice
Practice drill

Identify Hotstar users who watched at least five minutes but stopped before completing a video.

null handlingJoinssql queryHotstar
More SQL & Data Manipulation questions with a free account
2
Product Sense3 questions · ~28 min
Language Expansion DecisionMedium

Evaluates product sense and data-driven decision making for content strategy at Hotstar.

product decisionHotstar
Investigate Sudden DAU DropMedium

Assesses structured troubleshooting for product metrics and data signals.

root cause analysisuser engagementHotstar
More Product Sense questions with a free account
3
Behavioral & Leadership6 questions · ~56 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~28 min
Separate Retention From Short Term EngagementHard

Assess whether a feature drives durable retention gains or only a temporary spike in usage.

RetentionEngagement MetricsHotstar
Experiment Design For Skip IntroMedium

Tests experimental design thinking for product changes and causal measurement.

experiment designuser experienceHotstar
KPIs For New Subscription TierMedium

Assesses KPI selection aligned to monetization outcomes and user value.

KPIsHotstar

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 17 questions plus 1 hands-on drill to finish this plan.