Katkat

practice a little every day, paws crossed ♡

Data Engineer Interview Questions

Practice 9403 coding, system design and machine learning questions from 546 companies, sorted by role, topic and interview round. Every question has step-by-step hints, a code runner that supports 8 languages and an AI mentor; members also get the full solution walkthrough.

9403
Questions
546
Companies
11
Topics
8
Languages

Showing 31–45 of 45 results

  • NetflixHardData Engineer
    Implement phrase search and JSON path

    This problem tests your ability to process unstructured text into a searchable index and navigate hierarchical data structures using path patterns.

    Coding & AlgorithmsOnsiteInverted IndexString ProcessingRecursion
  • NextdoorHardData Engineer
    Write SQL for app metrics

    This question evaluates proficiency in SQL-based data engineering, focusing on time-zone-aware timestamp handling, aggregation of event and relationship data, cohort retention analysis, and computation of product metrics like DAU, new users, photo activity, and follower distributions.

    Coding & AlgorithmsTechnical Screen
  • NextdoorHardData Engineer
    Write SQL for basic user metrics

    This question evaluates proficiency in SQL for relational databases, specifically testing aggregation, joins, date/time grouping, and handling tied results when computing user metrics such as total users, peak signup month, and top-followed users.

    Coding & AlgorithmsTechnical Screen
  • Point72HardData Engineer
    Implement Election Report and Banking Pipeline

    This multipart question evaluates data engineering competencies including SQL report design for complex aggregation and ranking, plus PySpark-based ETL and transaction-level analytics.

    Coding & AlgorithmsOnline Assessment
  • Point72HardData Engineer
    Implement Portfolio Trading Optimizer

    This question evaluates algorithmic problem-solving, array processing, input validation via decorators, and the ability to produce concise transaction reports for maximizing non-overlapping buy/sell profits.

    Coding & AlgorithmsTechnical Screen
  • Point72EasyData Engineer
    Solve SQL and PySpark Data Tasks

    This question tests your ability to handle data cleaning, filtering, and aggregation using both SQL and PySpark syntax on a transaction dataset.

    Coding & AlgorithmsOnline AssessmentSQLPySparkData-Cleaning
  • RobinhoodHardData Engineer
    Aggregate user logs into 30-minute sessions

    This question evaluates data engineering competencies in time-series sessionization, datetime parsing and arithmetic, grouping and aggregation, distinct-count computation, and CSV log processing.

    Coding & AlgorithmsTechnical Screen
  • ShopifyEasyData Engineer
    Write SQL for session analytics

    This problem tests your ability to clean event-based log data, perform time-series aggregation, and calculate session-level metrics using SQL window functions.

    Coding & AlgorithmsTechnical ScreenSQLWindow FunctionsData Cleaning
  • StripeMediumData Engineer
    Compute shipping cost with tiered pricing

    Evaluates implementation-level algorithmic logic for tiered pricing, covering per-unit aggregation, interval reasoning, and mixed incremental vs fixed pricing models within the Coding & Algorithms domain and Data Engineering role; abstraction level is practical, implementation-focused business logic and data transformation.

    Coding & AlgorithmsTechnical Screen
  • TemuEasyData Engineer
    Compute User Login Streaks

    Tests the ability to write a SQL query to identify consecutive daily login streaks from raw event logs, requiring date deduplication, window functions, and streak length aggregation.

    Coding & AlgorithmsTechnical ScreenSQLWindow FunctionsTime Series
  • TeslaMediumData Engineer
    Write SQL Data Transformation Queries

    This question tests the ability to handle window functions for running totals and conditional aggregation to transform raw manufacturing logs into formatted monthly production reports.

    Coding & AlgorithmsTechnical ScreenSQLWindow FunctionsAggregation
  • XPengMediumData Engineer
    Build a Least-Recently-Used Store

    This question evaluates understanding of caching and eviction policies and practical proficiency with data structures such as hash tables and ordered collections for tracking and updating recency.

    Coding & AlgorithmsTechnical Screen
  • ZooxMediumData Engineer
    Write SQL revenue and anomaly queries

    This question evaluates SQL proficiency and data engineering competency in revenue aggregation, netting purchases and refunds, joining transaction and vendor tables, and designing data quality and anomaly detection checks.

    Coding & AlgorithmsOnsite
  • ZooxMediumData Engineer
    Write Transaction Analytics SQL Queries

    This question evaluates proficiency in SQL for analytical queries, covering aggregation, time-based filtering, joins between transactions and vendor metadata, and the use of ranking/window functions for top-N calculations.

    Coding & AlgorithmsTechnical Screen
  • xAIMediumData Engineer
    Implement two string utility functions

    This question evaluates proficiency in string manipulation and text processing, including character counting, tokenization by spaces, case-sensitive comparisons, and preserving original word order.

    Coding & AlgorithmsTechnical Screen