Meta interview questions

Showing 661–666 of 666 results

• Write SQL to infer group-call demandMedium

  This question evaluates SQL-based data manipulation and product-analytics competencies, including temporal sessionization, graph connectivity inference for detecting overlapping 1:1 call loops, deduplication trade-offs (UNION vs UNION ALL), and computation of derived metrics to estimate latent feature demand within the Data Manipulation (SQL/Python) domain. It is commonly asked because it measures practical application of event-time windowing, connected-component reasoning and edge-case handling (e.g., excluding failed connections) for producing daily summary metrics, emphasizing hands-on SQL proficiency over purely conceptual understanding.

  MetaData ScientistData Manipulation (SQL/Python)Technical Screen
• Write SQL/pandas for KPI anomalyMedium

  This question evaluates proficiency with SQL window functions and equivalent pandas operations for KPI anomaly detection, covering baseline computation using same-weekday medians over eight weeks, per-country and per-post_type Likes-per-DAU metrics with deduplication of users for DAU, outage filtering, attribution of declines between new and existing users, and time-series comparisons like friend-request acceptance rates while explicitly handling duplicates, sparse or missing DAU rows, and timezone issues. It is commonly asked in Data Manipulation (SQL/Python) interviews to assess practical data engineering and analytical skills, primarily testing practical application with an underlying need for conceptual understanding of baselining, attribution, and data-quality edge cases.

  MetaData ScientistData Manipulation (SQL/Python)Onsite
• Write advanced SQL for sales support analyticsMedium

  This question evaluates practical SQL data-manipulation skills such as joins, aggregation, window functions, time-based filtering, deduplication, and computation of sales KPIs for rep-level analytics.

  MetaData ScientistData Manipulation (SQL/Python)Technical Screen
• Write dating profile report with final reviewsMedium

  This question evaluates SQL and data-manipulation proficiency, including temporal joins, versioning, time-bounded snapshotting, windowed aggregations, and validation checks for data quality and idempotency.

  MetaData ScientistData Manipulation (SQL/Python)Onsite
• Write queries for follows and bookingsMedium

  This problem tests your ability to manage relational data, handle temporal overlaps for booking availability, and derive insights from social graph-like connections using SQL or data manipulation scripts.

  MetaData EngineerCoding & AlgorithmsTechnical Screen
• [Analytical Reasoning] Comparing Two Newsfeed Ad Insertion MethodsMedium

  Compare independent versus blocked ad insertion in a 100-post feed. Includes expected ads, tail risk, consecutive ad probabilities, longest streaks, product tradeoffs, and A/B test design.

  MetaData ScientistAnalytics & ExperimentationOnsite