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