Hotstar Data Analyst Interview Questions

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

Calculate 30-Day User Retention

Medium

Use CTEs, joins, and date filtering to calculate 30-day retention by signup cohort from login and feature usage data.

Window FunctionsDate FunctionsAggregations

Hotstar

Top Shows by Region

Medium

Tests SQL for ranking and regional aggregation over time windows.

sql queryData Analysis

Hotstar

LEFT vs INNER Join for Sessions

Easy

Tests understanding of join semantics for session-based streaming analytics.

data relationshipsJoins

Hotstar

Partition Aggregation Without Bottlenecks

Hard

Tests query design and performance-aware aggregation across large datasets.

performance optimizationsql

Hotstar

Video Drop-Off SQL Query

Medium

Tests SQL skills for funnel/drop-off analysis in streaming engagement data.

sql query

Hotstar

More SQL & Data Manipulation questions with a free account

A/B Test for Landing Page Layout

Hard

Tests A/B testing methodology, success metrics, and experiment validity.

experiment design

Hotstar

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

Open any question for its full solution and discussion.