Home Questions Data Engineer Data Modeling

Data Engineer Data Modeling Interview Questions

Review this list of 12 data modeling data engineer interview questions and answers verified by hiring managers and candidates.

+ Add interview

Product

Engineering

Operations

Design

Marketing

Data

Sales

Finance

Consulting

Security

Add interview

Data Engineer

Asked at Databricks, DoorDash • 2 months ago
Design a database schema for a fitness app.
Data Engineer
Data Modeling
3 answers I was asked this
"user table - with userid, username, email, phonenumber, accountcreateddate exercises table - types of exercises - indoor walk, outdoor walk, running, stairs, cycling, swimming etc - exerciseid, exercisetype date table - date, day, month, year - with dateid Session table - userid, sessiondateid(linked to dateid in date table), exerciseid, distance covered, calories spent, starttime, endtime "
Sreeram reddy B. - "user table - with userid, username, email, phonenumber, accountcreateddate exercises table - types of exercises - indoor walk, outdoor walk, running, stairs, cycling, swimming etc - exerciseid, exercisetype date table - date, day, month, year - with dateid Session table - userid, sessiondateid(linked to dateid in date table), exerciseid, distance covered, calories spent, starttime, endtime "See full answer
Data Engineer
Data Modeling
Asked at Amazon • 5 months ago
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).
Data Engineer
Data Modeling
1 answer I was asked this
"What do all data scientists need to know about how to work with very large datasets? 37 Follow Request Answer More All related (39) Recommended 📷 Corrin Lakeland · Follow , M.S. Data Science, University of St. Thomas, St. Paul (2018)6yData Science consultant and managerUpvoted by[Tom Halloin](https://www.quora"
Hayatu H. - "What do all data scientists need to know about how to work with very large datasets? 37 Follow Request Answer More All related (39) Recommended 📷 Corrin Lakeland · Follow , M.S. Data Science, University of St. Thomas, St. Paul (2018)6yData Science consultant and managerUpvoted by[Tom Halloin](https://www.quora"See full answer
Data Engineer
Data Modeling
Design a data warehouse schema for Instagram.
Data Engineer
Data Modeling
1 answer I was asked this
"Can i get the Linked ID of kajol ? Curious to learn more about data modeling & get some guidance.. Her way of data modeling is Amazing!"
Vinoth V. - "Can i get the Linked ID of kajol ? Curious to learn more about data modeling & get some guidance.. Her way of data modeling is Amazing!"See full answer
Data Engineer
Data Modeling
Design a Data Warehouse Schema for a Ride-Sharing Service
Data Engineer
Data Modeling
3 answers I was asked this
"Firstly, congratulations to both the interviewer and interviewee. This was a great learning experience However, being a Full Stack engineer and I was having the following suggestions around the Data Model - Driver & Approval can be two different tables Approval & Document - Approval can be a tuple of (userid,documentid) - comments against a rejection (marks the document which triggers rejection)In this way we can capture the entire history of approval workflow (initiate/pending/appr"
Nilanjan D. - "Firstly, congratulations to both the interviewer and interviewee. This was a great learning experience However, being a Full Stack engineer and I was having the following suggestions around the Data Model - Driver & Approval can be two different tables Approval & Document - Approval can be a tuple of (userid,documentid) - comments against a rejection (marks the document which triggers rejection)In this way we can capture the entire history of approval workflow (initiate/pending/appr"See full answer
Data Engineer
Data Modeling
Design a data warehouse schema for Amazon.
Data Engineer
Data Modeling
Add answer I was asked this
Data Engineer
Data Modeling

🧠 Want an expert answer to a question? Saving questions lets us know what content to make next.

Design a data warehouse schema for Spotify.
Data Engineer
Data Modeling
Add answer I was asked this
Data Engineer
Data Modeling
Design a Data Warehouse Schema for Stripe
Data Engineer
Data Modeling
Add answer I was asked this
Data Engineer
Data Modeling
Asked at LinkedIn • 3 months ago
Design a data warehouse schema for LinkedIn.
Data Engineer
Data Modeling
Add answer I was asked this
Data Engineer
Data Modeling
Design a Data Warehouse Schema for Customer Support
Data Engineer
Data Modeling
1 answer I was asked this
"not able to understand the accent of the candidate"
Akash A. - "not able to understand the accent of the candidate"See full answer
Data Engineer
Data Modeling
Design a Data Warehouse Schema for Airbnb
Data Engineer
Data Modeling
Add answer I was asked this
Data Engineer
Data Modeling
Design a database schema for a ride sharing app.
Data Engineer
Data Modeling
Add answer I was asked this
Data Engineer
Data Modeling
What is Pyspark?
Data Engineer
Data Modeling
1 answer I was asked this
"na"
Sonveer K. - "na"See full answer
Data Engineer
Data Modeling