444+ Data Engineering Practice Problems

Master SQL, Python, and data modeling with real interview problems from Meta, Google, Amazon, Netflix, and more.

139

EASY Problems

234

MEDIUM Problems

HARD Problems

Companies

Problem Categories

Hash Table (29)String (27)Stack (5)Array (21)Data Filtering (1)Math (7)Design (5)String Processing (13)Simulation (5)Intervals (4)Hash Table, Streaming (1)Sliding Window (7)Python Fundamentals (1)Aggregation & Windows (47)Aggregation (21)Joins & Deduplication (13)String Manipulation (2)Aggregation & Grouping (1)Aggregation & Filtering (2)Aggregation & Ranking (2)Aggregation & Time-series (4)Joins (2)Time-series & Partitions (8)Aggregation & Subqueries (1)CASE Expression (1)Joins & Aggregation (4)Sorting (7)Aggregation & Joins (5)Aggregation & Subquery (1)Window Functions (12)Joins & Filtering (2)Aggregation, NULL Handling (1)Aggregation, Grouping (1)Aggregation, HAVING Clause (1)Joins, Aggregation (1)Joins, Aggregation, Conditional Logic (2)Aggregation, Ranking (1)CASE Expressions, Aggregation (1)Aggregation, Joins (2)Subquery, Aggregation (1)Conditional Aggregation (1)Loops (1)Dynamic Typing (2)Collections Module (1)Data Engineering (7)Database (26)Decorator (1)Arrays (1)Sweep Line (3)Binary Search (6)Interval (1)Data Analysis (3)BFS (1)Backtracking (4)Heap (3)Tree (3)Graph (7)Greedy (9)Dynamic Programming (12)Matrix (2)String Manipulation & SQL Generation (1)Streaming & Real-Time Analytics (1)Hash Table, Array, Data Analysis (1)Streaming (2)Interval Processing (1)Aggregation & Date Arithmetic (1)Anti-Join & Set Operations (1)Relational Division (1)Window Functions & Time-Series (2)Aggregation & Percentage Calculation (1)Joins & Set Operations (1)Window Functions & Aggregation (1)Date Functions & Aggregation (1)Gaps And Islands (1)Cohort Analysis (1)Aggregation & Conditional Logic (3)Self-Join (1)Data Modeling (1)Subqueries (1)Aggregation & Cohort Analysis (1)Self Join & Date Arithmetic (1)Date Functions (2)Data Transformation & Unpivoting (1)Window Functions, Aggregation, Event Processing (2)Joins, Aggregation, Set Operations (1)Aggregation, Date Functions, NULL Handling, CTEs (1)Joins, Aggregation, Grouping (1)Joins, Aggregation, Cumulative Snapshots (1)Joins, Conditional Aggregation, Date Arithmetic (1)Joins, Conditional Aggregation, LEFT JOIN (1)Aggregation, Conditional Logic (1)Aggregation, Percentage Calculation (2)Window Functions, Gaps and Islands (1)Data Structures & Algorithms (1)API Integration (1)Data Structures (2)Dictionary (1)Linked List (1)Binary Tree (1)Anti Join (1)Aggregation & Data Transformation (1)Window Functions & Time Series (1)Time-series & Event Processing (1)Window Functions, Gaps and Islands, Multi-Join (1)Two Pointers (1)Set (1)Data Warehouse Design (16)OOP (2)String Parsing (2)Implementation (1)Error Handling (1)Closures (1)Regular Expressions (1)

Company-Specific Practice

LeetCode · agoda · airbnb · aircall · amazon · apple · atlassian · bloomberg · bytedance · capital one · chime · cisco · databricks · doordash · exodus point · exoduspoint · facebook · figma · google · hackerrank · harvey nash · hyper · instacart · intuit · linkedin · lyft · meta · microsoft · netflix · nyctimes · open ai · oracle · paypal · pelaton · rivian · robinhood · roblox · salesforce · shaw · shopify · snowflake · spur · square · stripe · techpath · tesla · tiger analytics · tiktok · uber · walmart · zeta · ziprecruiter

Topics Covered

Dynamic TypingSTRING_MANIPULATIONSplitStripabstract classesaggregationaggregationsanti joinanti-joinapi integrationarithmetic expressionsarrayarraysbacktrackingbfsbinary searchbinary treebit manipulationbucketingcardinalitycase expressioncase expressionscase whenclosurescohort analysiscombinatoricscomparisonconditional aggregationconditional filteringconditional logicconditionalscountingcross joincsv parsingcsv processingctectescumulative snapshotsdata aggregationdata analysisdata filteringdata manipulationdata processingdata structuresdata transformationdata validationdatabasedate arithmeticdate functionsdate timedecoratordefensive codingdesigndfsdictionarydimensional modelingdistinctdynamic programmingetlevent modelingevent processingexception handlingfile i/ofilteringfinancial datafrequency analysisfrequency countinggaps and islandsgraphgreedygroup bygroupinggrouping setshash tablehash_tablehaving clauseheaphigher order functionhigher-order functionsimplementationindexingintegerinterval processingintervalsjoinjoinsjsonknapsacklambdaleft joinlinked listlist comprehensionlog processingmathmatrixmedianmoving averagemulti-joinnull handlingoopoptimizationorder by / limitoverflowpaginationpair sumparsingpattern matchingpercentage calculationqueuerankingreal-time analyticsrecursionregular expressionregular expressionsrelational divisionreverse stringself joinsetset operationsshortest pathsimulationsliding windowslowly changing datasortingsqlsql generationstackstatisticsstreamingstringstring aggregationstring concatenationstring functionsstring manipulationstring parsingstring processingsubqueriessubquerysweep linetime seriestime-series analysistop ntreetree traversaltwo pointerstype castingtype handlingunion allunpivotinguser engagementuser funnel analysisvalidationversion parsingwindow functions

Problem Categories

Company-Specific Practice

Topics Covered

All Practice Problems

Start Practicing Now