Data Modeling Interview Questions

Review this list of 18 Data Modeling interview questions and answers verified by hiring managers and candidates.

+ Share interview

Hot

Recent

Share interview

Data Engineer Engineering Manager Software Engineer Product Manager Machine Learning Engineer

Design a database schema for a fitness app.
a year ago3 answers
Build a medallion data model for retail data.
5 months ago
Design tables and a processing pipeline to support daily metrics such as unique listeners, play count, total listening time, and top artists by country.
a year ago
Design a data warehouse schema for Instagram. Has video answer
a year ago1 answer
Design a Data Warehouse Schema for a Ride-Sharing Service Has video answer
a year ago3 answers
Get your questions answered
Our question database is made possible by user contributions. What were you asked in your most recent interview?
Share
Create geographic and demographic dashboards for weekly, monthly, and yearly analytics using order data (100M daily records for 5 years) and customer data (1B customers).
2 years ago1 answer
Design a Data Warehouse Schema for Stripe Has video answer
a year ago
Design a data warehouse schema for Spotify. Has video answer
a year ago
Design a data warehouse schema for Amazon. Has video answer
a year ago1 answer
Design a Data Warehouse Schema for Customer Support Has video answer
a year ago1 answer
Design a Data Warehouse Schema for Airbnb Has video answer
a year ago
How would you design the new storage system, especially the partitioning, as volume grows from millions of records to hundreds of millions or billions?
7 months ago
What data models do you need for an advertiser to start a campaign and show ads to users?
6 months ago
What is Pyspark?
2 years ago2 answers
Design a database schema for a ride sharing app.
7 months ago
Given an organizational hierarchy, how would you model it so I can quickly find a person's direct reports and everyone under their department?
a year ago
Define grain of a table.
2 months ago
Design a data warehouse schema for LinkedIn.
a year ago

Showing 1-18 of 18

Popular roles

Data Engineer Engineering Manager Software Engineer Product Manager Machine Learning Engineer

Interviewed recently?

Help improve our question database (and earn karma) by telling us about your experience

+ Share interview experience

Trending companies

Data Modeling Interview Questions

Design a database schema for a fitness app.

Build a medallion data model for retail data.

Design tables and a processing pipeline to support daily metrics such as unique listeners, play count, total listening time, and top artists by country.

Design a data warehouse schema for Instagram. Has video answer

Design a Data Warehouse Schema for a Ride-Sharing Service Has video answer

Create geographic and demographic dashboards for weekly, monthly, and yearly analytics using order data (100M daily records for 5 years) and customer data (1B customers).

Design a Data Warehouse Schema for Stripe Has video answer

Design a data warehouse schema for Spotify. Has video answer

Design a data warehouse schema for Amazon. Has video answer

Design a Data Warehouse Schema for Customer Support Has video answer

Design a Data Warehouse Schema for Airbnb Has video answer

How would you design the new storage system, especially the partitioning, as volume grows from millions of records to hundreds of millions or billions?

What data models do you need for an advertiser to start a campaign and show ads to users?

What is Pyspark?

Design a database schema for a ride sharing app.

Given an organizational hierarchy, how would you model it so I can quickly find a person's direct reports and everyone under their department?

Define grain of a table.

Design a data warehouse schema for LinkedIn.

Explore questions by company

Explore questions by role

Follow Us