OpenTable Data Analyst Interview Questions
The questions to prepare for a OpenTable Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Explain how to detect and handle NULL values in SQL using filtering, COALESCE, CASE, and business-aware imputation.
OpenTableExplain INNER JOIN vs LEFT JOIN semantics, NULL behavior, and common pitfalls (filters turning LEFT into INNER) using real analytics examples.
OpenTableCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Build a daily series and compute a 30-day trailing moving average of task bookings using window functions.
TaskRabbit
RBCCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIExplain how you used a KPI and supporting metrics to diagnose a product issue and make a concrete product decision.
OpenTableTests metric selection and understanding of how reservation performance is measured.
OpenTableSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain what drives your interest in data engineering, grounded in user needs and the value created by reliable data systems.
OpenTableAssesses your ability to propose revenue growth levers using analytics and product understanding.
OpenTableTests experimental design, metrics selection, and decision-making for product changes at OpenTable.
OpenTableTests causal reasoning and measurement of marketing effects on reservations for OpenTable venues.
OpenTable