Data Scientist Interview Questions

Showing 1–14 of 14 results

• AirbnbMedium·Data Scientist
  Describe How You Use SQL in Data Science Work

  This question assesses a candidate's ability to articulate their technical workflow in SQL, focusing on data extraction strategies, quality assurance, and how technical analysis translates into business impact.

  Data Manipulation (SQL/Python)HR ScreenSQLData ScienceAnalytics
• AmazonMedium·Data Scientist
  Build DID panel and compute effects in SQL

  This question evaluates proficiency in panel data construction and causal inference workflows, specifically difference-in-differences estimation, SQL aggregation for user-week metrics, and propensity-score matching implemented in Python.

  Data Manipulation (SQL/Python)HR Screen
• Capital OneMedium·Data Scientist
  Impute missing values without leakage

  This question evaluates proficiency in data imputation, strict train/validation leakage prevention, temporal per-user propagation rules, and categorical aggregation for model-ready features.

  Data Manipulation (SQL/Python)HR Screen
• Capital OneMedium·Data Scientist
  Merge seven tables into one clean DataFrame

  This question evaluates proficiency with pandas-based data manipulation, including multi-table joins, aggregations, dtype enforcement, denormalization, and verification of row/column integrity within the Data Manipulation (SQL/Python) domain for a Data Scientist role.

  Data Manipulation (SQL/Python)HR Screen
• CoinbaseMedium·Data Scientist
  Write SQL and Python for funnels/retention

  This question evaluates SQL and Python data-manipulation skills, including event-to-session joins, temporal window filtering, deduplication, JSON metadata handling, and computation of funnel and retention metrics like daily unique users and conversion rates.

  Data Manipulation (SQL/Python)HR Screen
• DisneyMedium·Data Scientist
  Write complex SQL for streaming funnels

  This question evaluates a candidate's ability to write complex ANSI-SQL for event-level funnel analysis, including temporal windowing, user attribution, multi-stage aggregation, and handling of event schemas.

  Data Manipulation (SQL/Python)HR Screen
• InstacartMedium·Data Scientist
  Explain handling very large datasets

  This question evaluates a candidate's competence in ingesting and processing very large datasets, covering storage formats and partitioning, memory and compute constraints, schema evolution, data quality checks, indexing strategies, tool selection in SQL/Python ecosystems, and code-level performance optimizations.

  Data Manipulation (SQL/Python)HR Screen
• IntuitMedium·Data Scientist
  Compute churn and revenue churn in SQL

  This question evaluates a candidate's ability to compute subscription churn and revenue retention metrics from monthly snapshots, exercising SQL data-manipulation competencies such as handling missing or null MRR values, deduplicating snapshot loads, joining across months, and aggregating MRR changes.

  Data Manipulation (SQL/Python)HR Screen
• IntuitMedium·Data Scientist
  Design an idempotent churn ETL pipeline

  This question evaluates a candidate's competence in designing robust ETL pipelines, covering idempotent processing, handling late-arriving streaming subscription events, SCD Type 2 slowly changing dimensions, incremental backfills, data quality checks, upsert/merge semantics, and metric versioning.

  Data Manipulation (SQL/Python)HR Screen
• MetaMedium·Data Scientist
  Write SQL filtering, grouping, CASE, UNION tasks

  This question evaluates proficiency with SQL filtering, aggregation, conditional logic, and set operations—specifically skills around WHERE filtering, GROUP BY/HAVING, CASE bucketing, FLOOR on aggregates, and UNION versus UNION ALL—within the Data Manipulation (SQL/Python) domain and emphasizes practical application of ANSI SQL.

  Data Manipulation (SQL/Python)HR Screen
• Morgan StanleyMedium·Data Scientist
  Describe Your Analysis and Visualization Toolkit

  Tests your ability to articulate an end-to-end data analysis and visualization workflow clearly and concisely for recruiters and hiring managers, connecting technical tool choices directly to business outcomes.

  Data Manipulation (SQL/Python)HR Screendata-analysissqlpython
• RobloxMedium·Data Scientist
  Write SQL to flag suspect payments and chargebacks

  This question evaluates proficiency with SQL conditional logic (CASE WHEN), JOINs, date/time arithmetic, aggregation, and encoding business rules for flagging suspect payments and chargebacks, and is categorized under Data Manipulation (SQL/Python) for a Data Scientist role.

  Data Manipulation (SQL/Python)HR Screen
• ThumbtackMedium·Data Scientist
  Compute weekly 3-week rolling sums in SQL

  This question evaluates time zone–aware date bucketing, gapless calendar generation, and rolling-window aggregation skills, demonstrating competency in SQL-based data manipulation and temporal reasoning.

  Data Manipulation (SQL/Python)HR Screen
• TikTokMedium·Data Scientist
  Write SQL for 7-day geo-localized revenue dashboard

  This question evaluates SQL skills in time-zone aware local-date aggregation, idempotent event deduplication, cohorting for new versus returning users, calculation of revenue and conversion metrics, and anomaly detection via median-based drop flags.

  Data Manipulation (SQL/Python)HR Screen