Top 50 data processing Interview Questions

Find the longest contiguous TikTok Shop product sequence containing at most k distinct products using a sliding window.

data processingSliding WindowoptimizationTikTok ShopAmazon Web Services

Detect robust outliers in Zoox telemetry using a rolling median and MAD with logarithmic updates.

data processinganomaly detectionZooxNVIDIA

Simulate Spark salting to distribute hot keys across partitions and return each partition's record count.

aggregationdata processingArraysDatabricksUltra Tendency

Parse messy Plaid transaction records, normalize fields, and deduplicate valid transactions in one pass.

data cleaningdata processingStringsPlaid

Count each integer and return value-count pairs in order of first appearance.

aggregationdata processingArraysGoogle

Count case-insensitive, punctuation-free word occurrences in a TurboTax file using a join, CTE, and GROUP BY.

data processingIntuit