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.

Asked at Databricks, DoorDash • 8 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
Design a data warehouse schema for Instagram.
Data Engineer
Data Modeling
1 answer I was asked this
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
Asked at Amazon • a year 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 Stripe
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 Amazon.
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
What is Pyspark?
Data Engineer
Data Modeling
2 answers I was asked this
"na"
Sonveer K. - "na"See full answer
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
Asked at LinkedIn • 10 months ago
Design a data warehouse schema for LinkedIn.
Data Engineer
Data Modeling
Add answer I was asked this
Data Engineer
Data Modeling