Meta Data Engineer Interview Questions
The questions to prepare for a Meta Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Use a CTE and ROW_NUMBER to keep the latest ingested copy of each Meta event while handling late-arriving data.
MetaUse ROW_NUMBER to return each customer's second most recent Meta Marketplace purchase.
MetaFind the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.
MetaFlatten a deeply nested JSON-like object into path-value pairs using recursion and deterministic key construction.
MetaDeduplicate event records by ID, keeping the latest event per ID and returning results in timestamp order.
MetaFind the first target event ID in an unsorted list using a manual linear scan without native lookup functions.
MetaSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Design a streaming pipeline that can absorb late-arriving events while keeping aggregates correct and downstream tables stable.
MetaDesign an idempotent Meta Ads metrics pipeline that handles retries, replays, and backfills without double counting in batch or streaming paths.
Meta