Dataford
Dataford
Top 18
Prep plan
Updated weekly · Last refresh Oct 30

Hotstar Business Analyst Interview Questions

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

18questions
~3htotal time
Track your progressSign up free to work through all 18 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 2 drills · ~81 min
Compare Monthly User Retention CohortsMedium
Practice

Calculate month-1 retention for January vs February signup cohorts using joins, date filtering, and aggregation.

Window FunctionsDate FunctionsAggregationsHotstar
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
Intermediate SQL for Hotstar AnalyticsMedium

Assesses SQL proficiency for analyzing Hotstar engagement and content performance data.

analyticscase studysqlHotstar
Top Shows by RegionMedium
Practice
Practice drill

Write a query to find the top 10 most-watched shows in a specific region over the last 30 days on Hotstar. Use IN as the target region and CURRENTDATE as ...

Date FunctionsJoinssql queryHotstar
Top Viewed Shows Per RegionMedium
Practice
Practice drill

Find the five most viewed Hotstar shows in each region using joins, aggregation, and regional ranking.

Joinssql queryData AnalysisHotstar
More SQL & Data Manipulation questions with a free account
2
Product Sense5 questions · ~43 min
Marketing Impact on Retention FrameworkHard

Tests ability to design end-to-end analysis for long-term retention effects of marketing.

user retentionHotstar
Dashboard for Live Cricket HealthMedium

Tests KPI selection, monitoring design, and operational thinking for live streaming.

product metricsdashboard designHotstar
Success Metrics for Subscription TierMedium

Tests metric design for monetization and engagement outcomes tied to product strategy.

user engagementHotstar
More Product Sense questions with a free account
3
Behavioral & Leadership4 questions · ~35 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~17 min
Increase Engagement for Niche ViewersHard

Assesses your ability to translate OTT user behavior into actionable engagement strategies.

Hotstar
Hotstar OTT Case Study Problem SolvingHard

Evaluates your problem-solving framework for OTT business cases and your validation approach.

Problem SolvingsqlHotstar

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 18 questions plus 2 hands-on drills to finish this plan.