Land your dream data role.
Practice real PySpark interviews.

Real Spark sessions. Real DataFrames. Original interview-style challenges covering joins, windows, aggregation, and data cleanup. Solve in-browser, get instant pass/fail.

243 problems
116 free
127 ad unlock
80 Easy · 101 Med · 59 Hard · 3 Capstone
243 of 243 problems

Total Project Hours

Easy
Aggregation
FREE

Products in a Price Band

Easy
Filtering
FREE

Unique Visitors Per Page

Easy
Aggregations
GroupBy
Meta
Razorpay
FREE

Top Two Categories by Revenue

Easy
Aggregation
Ranking
FREE

Low-Stock Alert

Easy
Filtering
FREE

Insurance Premium with GST

Easy
Arithmetic
Insurance
Acko
FREE

Facebook Page Reach Total

Easy
Aggregation
Social Media
Meta
FREE

Unique Cities per Country

Easy
Aggregation
FREE

Discounted Price Calculator

Easy
Data Cleaning
Arithmetic
FREE

High-Value Orders

Easy
Filtering
Twilio
Ad unlock

Employees Without a Manager

Easy
Filtering
Data Cleaning
FREE

HDFC Credit Card Minimum Due

Easy
Arithmetic
Banking
HDFC Bank
FREE

Uppercase Country Codes

Easy
String Functions
FREE

Amazon Seller Net Revenue

Easy
Arithmetic
E-commerce
Amazon
FREE

CSV Write: With Header

Easy
CSV
Write
Sink
Amazon
Walmart
FREE

Customers Without Orders

Easy
Joins
FREE

Amazon Top-Rated Products

Easy
Filtering
E-commerce
Amazon
FREE

Orders in an Amount Band

Easy
Filtering
FREE

CSV Write: Without Header

Easy
CSV
Write
Sink
Amazon
FREE

Highest-Rated Restaurant

Easy
Ranking
FREE

Read TSV Users by Country

Easy
File I/O
TSV
Aggregation
FREE

Order Total After Shipping

Easy
Arithmetic
FREE

Bulk Order Flag

Easy
Data Cleaning
Filtering
FREE

Average Tip per Driver

Easy
Aggregation
FREE

Read JSON Web Events by Type

Easy
File I/O
JSON
Aggregation
FREE

Free Trial Signups

Easy
Filtering
FREE

Schema Drift: The Extra Column

Easy
Schema
Data Quality
CSV
Databricks
Snowflake
FREE

First Order Per Customer

Easy
Window Functions
Ranking
FREE

Read CSV Out of Stock Products

Easy
File I/O
CSV
Filtering
FREE

Order Total with Discount

Easy
Arithmetic
FREE

JSON Write

Easy
JSON
Write
Sink
Netflix
Spotify
FREE

Bulk Order Lines

Easy
Filtering
FREE

Orders Per User

Easy
GroupBy
Aggregations
Pinterest
Salesforce
FREE

Distinct Payment Methods

Easy
Deduplication
FREE

Inventory Value by Product

Easy
Arithmetic
FREE

Uppercase Long Names

Easy
String Ops
Filtering
LinkedIn
Paytm
FREE

Enrich Orders With User Names

Easy
Joins
TikTok
FREE

Average Delivery Minutes

Easy
Aggregation
FREE

Purchase Events

Easy
Filtering
Amazon
Meta
FREE

Top-Selling Product by Units

Easy
Aggregation
Ranking
FREE

Events By Type

Easy
GroupBy
Aggregations
Salesforce
Twilio
FREE

Instagram Story Completion Rate

Easy
Arithmetic
Product Metrics
Instagram
FREE

Inner Join: Orders with Users

Easy
Joins
Inner Join
Uber
Airbnb
FREE

Signups By Country

Easy
GroupBy
Aggregations
TikTok
Pinterest
Ad unlock

Reviews By Rating

Easy
GroupBy
Aggregations
Netflix
Paytm
Ad unlock

High-Margin Products

Easy
Arithmetic
Filtering
FREE

Indian Users

Easy
Filtering
Databricks
Snowflake
FREE

Bank ATM Withdrawal Limit

Easy
Filtering
Banking
ICICI Bank
FREE

Repeat Buyers

Easy
Aggregation
FREE

Fill Missing Ages and Cities

Easy
Data Cleaning
Paytm
Google
FREE

Read JSON Attendance Employees by Status

Easy
File I/O
JSON
Aggregation
FREE

Active Subscriptions

Easy
Filtering
FREE

Short Product Codes

Easy
String Functions
Filtering
FREE

Distinct Hotel Cities

Easy
Deduplication
FREE

Left Join: All Orders with User Info

Easy
Joins
Left Join
Uber
Airbnb
FREE

Min / Max Price Per Product

Easy
GroupBy
Aggregations
Flipkart
FREE

Out-of-Stock Products

Easy
Filtering
FREE

Orders in the First Quarter

Easy
Filtering
FREE

Instagram Follower Net Change

Easy
Arithmetic
Social Media
Instagram
FREE

Average Rating Excluding Nulls

Easy
Aggregation
Data Cleaning
FREE

Facebook Group Member Threshold

Easy
Filtering
Social Media
Meta
FREE

Netflix High-Completion Titles

Easy
Filtering
Media
Netflix
FREE

HDFC UPI Cashback Payout

Easy
Arithmetic
Banking
HDFC Bank
FREE

Read CSV Orders by Status

Easy
File I/O
CSV
Aggregation
FREE

Netflix Season Runtime Hours

Easy
Aggregation
Arithmetic
Media
Netflix
FREE

Total Funding per Sector

Easy
Aggregation
FREE

Merge Two Email Lists (Distinct)

Easy
Union
Data Cleaning
LinkedIn
Swiggy
Ad unlock

Total Spend Per User

Easy
GroupBy
Aggregations
Twilio
Meta
FREE

Count Orders by Status

Easy
Aggregation
FREE

Cancelled Orders

Easy
Filtering
Snowflake
FREE

Long Sessions

Easy
Filtering
Adobe
FREE

Amazon Prime Late Deliveries

Easy
Filtering
Logistics
Amazon
FREE

Insurance Approved Claim Total

Easy
Filtering
Aggregation
Insurance
Acko
FREE

SQL: Revenue by City

Easy
SQL
spark.sql
Aggregation
Databricks
Amazon
FREE

Read CSV Users by Country

Easy
File I/O
CSV
Filtering
FREE

Employee Bonus Amount

Easy
Arithmetic
FREE

Rating Points Per Movie

Easy
GroupBy
Aggregations
Snowflake
Databricks
Ad unlock

High Earners

Easy
Filtering
Netflix
Paytm
FREE

Engineering Team

Easy
Filtering
Meta
Paytm
FREE

Count Open Tickets

Easy
Filtering
Aggregation
FREE

Read CSV Average Salary by Department

Medium
File I/O
CSV
Joins
FREE

Parquet Write: Partitioned

Medium
Parquet
Write
Partitioning
Airbnb
Ad unlock

Delta Write: Overwrite to a Gold Path

Medium
Delta
Write
Sink
Databricks
Ad unlock

Top Customer per Region

Medium
Joins
Aggregation
Window Functions
FREE

Delta Merge: Upsert to a New Version

Medium
Delta
Merge
Schema Evolution
Databricks
Snowflake
Ad unlock

Product Revenue Rank

Medium
Aggregation
Window Functions
Ranking
FREE

Read CSV Revenue by Country

Medium
File I/O
CSV
Joins
FREE

Parquet Write: Compression

Medium
Parquet
Write
Compression
Airbnb
Uber
Ad unlock

Second-Highest Order

Medium
Window Functions
Ranking
FREE

Most Returned Product

Medium
Aggregation
Ranking
Ad unlock

Customer Lifetime Value

Medium
Joins
Aggregation
Ad unlock

Semi Join: Users Who Placed Orders

Medium
Joins
Semi Join
Uber
Airbnb
Ad unlock

Read Parquet Payroll by Department

Medium
File I/O
Parquet
Aggregation
FREE

Product First Sale Day

Medium
Aggregation
FREE

Bank Branch Transaction Share

Medium
Aggregation
Arithmetic
Banking
ICICI Bank
Ad unlock

Top 2 Most-Watched Videos Per User

Medium
Window Functions
Top-K
Pinterest
Instacart
FREE

Streaming: Read CSV as Bounded Stream

Medium
Streaming
CSV
readStream
Amazon
Airbnb
FREE

Optimization: Filter Before Joining

Medium
Optimization
Filter Pushdown
Joins
Amazon
Uber
Ad unlock

Salary Share by Department

Medium
Aggregation
Arithmetic
FREE

Read ORC Revenue by Payment Method

Medium
File I/O
ORC
Aggregation
FREE

Streaming: Write to Parquet with Checkpoint

Medium
Streaming
Parquet
writeStream
Amazon
Walmart
FREE

Customers with a Single Order

Medium
Aggregation
Filtering
Ad unlock

Units Sold Per Product

Medium
GroupBy
Aggregations
Google
Snowflake
Ad unlock

Delta Write: Partitioned Append

Medium
Delta
Write
Partitioning
Databricks
Snowflake
Ad unlock

Amazon Seller Rating Rank

Medium
Window Functions
Ranking
E-commerce
Amazon
Ad unlock

Share of Total Sales By Category

Medium
Window Functions
Aggregations
Uber
Adobe
Ad unlock

Department Headcount Above Average

Medium
Aggregation
Filtering
Ad unlock

Delta Schema Evolution: Add a Column

Medium
Delta
Schema Evolution
Merge
Databricks
Ad unlock

Delta Write: Ignore Mode

Medium
Delta
Write
Ignore
Databricks
Ad unlock

Delta Write: Error If Exists

Medium
Delta
Write
ErrorIfExists
Databricks
Ad unlock

Late Delivery Rate

Medium
Filtering
Arithmetic
Ad unlock

Customers Above Region Average

Medium
Joins
Aggregation
Filtering
Ad unlock

Highest-Paid Employee per Department

Medium
Window Functions
Ranking
Ad unlock

Customer Order Sequence

Medium
Window Functions
Ranking
Ad unlock

Monthly Order Count and Revenue

Medium
Aggregation
Ad unlock

Underused Warehouse Stock

Medium
Arithmetic
Filtering
FREE

Streaming: Filter Kafka Messages

Medium
Streaming
Kafka
Filtering
Netflix
Airbnb
FREE

Streaming: Bounded Kafka Replay

Medium
Streaming
Kafka
Micro-batch
Uber
Databricks
FREE

Above-Average Orders

Medium
Aggregation
Filtering
Ad unlock

Average Salary Per Department

Medium
GroupBy
Aggregations
Microsoft
Ad unlock

Join Optimization: Broadcast the Small Dimension

Medium
Joins
Optimization
Broadcast
Uber
Airbnb
Ad unlock

Delta Write: Partitioned Append

Medium
Delta
Write
Partitioning
Databricks
Snowflake
Ad unlock

Streaming: Checkpoint Location

Medium
Streaming
Kafka
Checkpoint
Databricks
Snowflake
FREE

Optimization: Repartition by Partition Key Before Write

Medium
Optimization
Repartition
Parquet
Amazon
Databricks
FREE

First and Last Order

Medium
Aggregation
Ad unlock

Normalise Null Tokens

Medium
Data Quality
Nulls
Cleaning
Spotify
Netflix
FREE

Facebook Friend Request Acceptance

Medium
Aggregation
Arithmetic
Social Media
Meta
Ad unlock

Streaming: Write to Kafka Topic

Medium
Streaming
Kafka
writeStream
Uber
Databricks
FREE

Co-Purchase Pairs

Medium
Joins
Aggregation
Ad unlock

Left Join With Guest Fallback

Medium
Joins
Data Cleaning
Pinterest
LinkedIn
Ad unlock

Optimization: Broadcast Hash Join

Medium
Optimization
Broadcast
Joins
Uber
Airbnb
Ad unlock

Average Order Amount By Category

Medium
GroupBy
Aggregations
Netflix
Swiggy
Ad unlock

Delta Write: Append Mode

Medium
Delta
Write
Sink
Databricks
Ad unlock

Average Fare Per City

Medium
GroupBy
Aggregations
Microsoft
Pinterest
Ad unlock

Optimization: Coalesce Small Files After Selective Filter

Medium
Optimization
Coalesce
Small Files
Databricks
Snowflake
FREE

Read Parquet Products by Category

Medium
File I/O
Parquet
Aggregation
FREE

Delta Write: saveAsTable

Medium
Delta
Write
saveAsTable
Databricks
Snowflake
Ad unlock

Same-Day Multiple Orders

Medium
Aggregation
Filtering
FREE

Insurance Agent Commission Total

Medium
Aggregation
Arithmetic
Insurance
Acko
Ad unlock

First Purchase Category

Medium
Joins
Window Functions
Ranking
Ad unlock

Latest Signup Per Email

Medium
Data Cleaning
Window Functions
LinkedIn
Uber
Ad unlock

Monthly Average Order Value

Medium
Aggregation
Ad unlock

Optimization: Reuse a Cached Intermediate

Medium
Optimization
Cache
Reuse
Databricks
Snowflake
Ad unlock

Duplicate Normalized Emails

Medium
String Functions
Data Cleaning
Aggregation
Ad unlock

Returning Customer Rate

Medium
Aggregation
Arithmetic
FREE

HDFC Fraud Risk Score

Medium
Arithmetic
Filtering
Banking
HDFC Bank
Ad unlock

Read CSV Line Revenue by Product

Medium
File I/O
CSV
Aggregation
FREE

Optimization: Inspect Physical Plan & Broadcast Join

Medium
Optimization
AQE
Explain
Google
Amazon
FREE

Schema Drift: Missing Required Column

Medium
Schema
Data Quality
CSV
Stripe
Databricks
FREE

Facebook Ad Click-Through Rate

Medium
Arithmetic
Filtering
Advertising
Meta
Ad unlock

Region Running Revenue

Medium
Window Functions
FREE

Pivot Events Per User

Medium
Pivot
GroupBy
Zomato
Swiggy
Ad unlock

Supplier Product Count

Medium
Aggregation
FREE

Top 2 Sales Per User

Medium
Window Functions
Top-K
Salesforce
Netflix
FREE

Whales: Users Spending Over 100

Medium
GroupBy
Aggregations
Filtering
Uber
FREE

Read JSON Top Clicked Products

Medium
File I/O
JSON
Filtering
FREE

Anti Join: Orders Without a Matching User

Medium
Joins
Anti Join
Data Quality
Stripe
Databricks
Ad unlock

Instagram Hashtag Format Reach

Medium
Pivoting
Aggregation
Social Media
Instagram
Ad unlock

Netflix Monthly Watch Hours

Medium
Aggregation
Arithmetic
Media
Netflix
Ad unlock

Delta Write: Overwrite Mode

Medium
Delta
Write
Sink
Databricks
Snowflake
Ad unlock

Read JSON Login Days per Employee

Medium
File I/O
JSON
Aggregation
FREE

Delta Write: Custom Options

Medium
Delta
Write
Options
Databricks
Ad unlock

Amazon Category Return Rate

Medium
Aggregation
Arithmetic
E-commerce
Amazon
Ad unlock

Premium Products

Medium
Filtering
Zomato
Twilio
Ad unlock

Instagram Influencer Engagement

Medium
Aggregation
Arithmetic
Social Media
Instagram
Ad unlock

Netflix Top Genre per Region

Medium
Aggregation
Window Functions
Media
Netflix
Ad unlock

Total Distance Per Driver

Medium
GroupBy
Aggregations
Spotify
Uber
Ad unlock

Streaming: Processing Time Trigger

Medium
Streaming
Kafka
Trigger
Databricks
Netflix
FREE

Delta Time Travel: Recover a Deleted Row

Medium
Delta
Time Travel
History
Databricks
Ad unlock

Schema Drift: Reordered Columns

Medium
Schema
CSV
Union
Uber
Airbnb
FREE

Running Order Total Per User

Medium
Window Functions
Aggregations
Salesforce
Snowflake
FREE

Insurance Policy Lapse Rate

Medium
Aggregation
Arithmetic
Insurance
Acko
Ad unlock

Customer Second Order Day

Medium
Window Functions
Ranking
Ad unlock

Product Category Pivot

Medium
Pivoting
Aggregation
FREE

HDFC Loan EMI Burden

Medium
Arithmetic
Filtering
Banking
HDFC Bank
Ad unlock

Rank Players by Score

Medium
Window Functions
Ranking
LinkedIn
Airbnb
FREE

Latest Profile Per User

Medium
Data Cleaning
Window Functions
Razorpay
Spotify
Ad unlock

Shipping Cost Share

Medium
Arithmetic
FREE

Read JSON Review Averages by Product

Medium
File I/O
JSON
Aggregation
FREE

Join + Aggregation: Revenue per City

Medium
Joins
Aggregation
GroupBy
Amazon
Walmart
Ad unlock

Optimization: Column Pruning Before Aggregation

Medium
Optimization
Column Pruning
Aggregation
Airbnb
Netflix
Ad unlock

Monthly Active Customer Growth

Hard
Aggregation
Window Functions
Arithmetic
Ad unlock

Second-Highest Salary per Department

Hard
Window Functions
Ranking
Ad unlock

Streaming: Watermark & Late-Event Deduplication

Hard
Streaming
Watermark
Deduplication
Uber
Stripe
FREE

Optimization: Pre-Aggregate Before a Wide Join

Hard
Optimization
Aggregation
Shuffle
Amazon
Walmart
Ad unlock

Duplicate Transaction Pairs

Hard
Joins
Filtering
Ad unlock

Amazon Seller Monthly Revenue Share

Hard
Aggregation
Window Functions
Arithmetic
Amazon
Ad unlock

Netflix Churn Risk Customers

Hard
Arithmetic
Window Functions
Ranking
Netflix
Ad unlock

Third-Highest Salary per Department

Hard
Window Functions
Ranking
Ad unlock

Top Product per Month

Hard
Aggregation
Window Functions
Ranking
Ad unlock

Customers Missing Cross-Sell

Hard
Joins
Deduplication
Ad unlock

Quarterly Revenue Pivot

Hard
Pivoting
Aggregation
Arithmetic
Ad unlock

Latest Event per User and Type

Hard
Window Functions
Ranking
Deduplication
Ad unlock

Bank Account Overdraft Days

Hard
Window Functions
Aggregation
Banking
ICICI Bank
Ad unlock

Streaming: Complete Output Mode Aggregation

Hard
Streaming
Aggregation
OutputMode
Amazon
Walmart
Ad unlock

Account Balance Over Time

Hard
Window Functions
Aggregations
Pinterest
Instacart
Ad unlock

Consecutive Low-Stock Days

Hard
Window Functions
Aggregation
Filtering
Ad unlock

Repeat Category Purchase

Hard
Aggregation
Deduplication
Ad unlock

Customer First-Order Share

Hard
Window Functions
Joins
Arithmetic
Ad unlock

Repeat Purchase Within 7 Days

Hard
Joins
Filtering
Deduplication
Ad unlock

Insurance Claim Ratio by Policy Type

Hard
Aggregation
Arithmetic
Insurance
Acko
Ad unlock

Cohort Retention

Hard
Window Functions
Aggregation
Ad unlock

Self Join: Orders by the Same User

Hard
Joins
Self Join
Amazon
Uber
Ad unlock

Employee Salary Gap

Hard
Window Functions
Ad unlock

Top Three Products per Category

Hard
Window Functions
Ranking
Aggregation
Ad unlock

Amazon Cross-Category Buyers

Hard
Aggregation
Ranking
E-commerce
Amazon
Ad unlock

Quarantine Corrupt Rows

Hard
Schema
Data Quality
CSV
Databricks
Snowflake
Ad unlock

Product Revenue Change

Hard
Window Functions
Arithmetic
Ad unlock

First Three Orders Revenue

Hard
Window Functions
Aggregation
Ad unlock

Inventory Reorder Priority

Hard
Arithmetic
Window Functions
Ranking
Ad unlock

Bank Branch Fraud Rate Ranking

Hard
Aggregation
Window Functions
Ranking
HDFC Bank
Ad unlock

Top 3 Test Scores Per Student

Hard
Window Functions
Top-K
Stripe
Twilio
Ad unlock

Consecutive Login Streak

Hard
Window Functions
Aggregation
Ad unlock

Product Monthly Revenue Share

Hard
Aggregation
Window Functions
Arithmetic
Ad unlock

Facebook Ad Spend Efficiency

Hard
Arithmetic
Window Functions
Ranking
Meta
Ad unlock

Month-Over-Month Growth

Hard
Window Functions
Swiggy
Stripe
Ad unlock

Streaming: Watermarked Tumbling Window Aggregation

Hard
Streaming
Watermark
Aggregation
Databricks
Uber
FREE

Optimization: Salt Skewed Join Keys

Hard
Optimization
Skew
Salting
Amazon
Walmart
Ad unlock

Insurance Agent Commission Ranking

Hard
Window Functions
Ranking
Arithmetic
Acko
Ad unlock

Delta Write: Upsert to a Table

Hard
Delta
Write
Merge
Databricks
Snowflake
Ad unlock

Instagram Reel Completion Drops

Hard
Window Functions
Arithmetic
Social Media
Instagram
Ad unlock

Schema Drift: Mixed Date Formats

Hard
Schema
Dates
Data Quality
Amazon
Walmart
Ad unlock

SCD Type 2: Build History from a Snapshot

Hard
SCD2
Slowly Changing Dimension
History
Snowflake
Databricks
Ad unlock

Category Revenue Share

Hard
Aggregation
Arithmetic
Ad unlock

Optimization: Aggregate Before Joining

Hard
Optimization
Pre-Aggregation
Shuffle
Amazon
Walmart
Ad unlock

Streaming: ForeachBatch Processing

Hard
Streaming
Kafka
foreachBatch
Databricks
Uber
Ad unlock

Netflix Profile Monthly Growth

Hard
Aggregation
Window Functions
Arithmetic
Netflix
Ad unlock

Top Three Spender Share

Hard
Aggregation
Window Functions
Arithmetic
Ad unlock

SCD Type 2: Expire Old Rows and Insert New Versions

Hard
SCD2
Slowly Changing Dimension
Merge
Snowflake
Ad unlock

Top Two Products per Customer

Hard
Aggregation
Window Functions
Ranking
Ad unlock

Streaming: Join Stream with Static Dimension

Hard
Streaming
Kafka
Join
Uber
Airbnb
Ad unlock

Instagram Top Creator per Niche

Hard
Window Functions
Ranking
Social Media
Instagram
Ad unlock

Top Two Spenders per Month

Hard
Aggregation
Window Functions
Ranking
Ad unlock

Ledger Reconciliation

Hard
Joins
Aggregation
Data Cleaning
Ad unlock

Three-Way Join: Orders, Users, Products

Hard
Joins
Multi Join
Amazon
Airbnb
Ad unlock

Manager Salary Gap

Hard
Joins
Arithmetic
Ad unlock

Amazon Return-Adjusted Seller Rank

Hard
Arithmetic
Window Functions
Ranking
Amazon
Ad unlock

Order Gap Analysis

Hard
Window Functions
Ad unlock

HDFC Merchant Spend Share

Hard
Aggregation
Arithmetic
Banking
HDFC Bank
Ad unlock

Month-over-Month Retention

Hard
Joins
Aggregation
Ad unlock

Capstone: E-commerce Lakehouse (Bronze/Silver/Gold)

Capstone
Capstone
Lakehouse
E-commerce
Databricks
Amazon
Ad unlock

Capstone: Bank Lakehouse (Bronze/Silver/Gold)

Capstone
Capstone
Lakehouse
Banking
Databricks
JPMorgan Chase
Ad unlock

Capstone: Insurance Lakehouse (Bronze/Silver/Gold)

Capstone
Capstone
Lakehouse
Insurance
Databricks
Allstate
Ad unlock