Today I'm interviewing Jitesh again on a data engineering and data modeling question around designing a schema for a ride sharing company like Uber or Lyft.
Here's the question we're tackling: https://www.interviewquery.com/questions/ride-sharing-app-schema
Want to be featured in the next mock interview video? Apply here: https://airtable.com/shrdQrwKK7xxGLm6l
👉 Subscribe to my data science channel: https://bit.ly/2xYkyUM
🔥 Get 10% off data engineer interview prep: https://www.interviewquery.com/pricing?via=jay
❓ Check out our new SQL interview course: https://www.interviewquery.com/learning-paths/sql-interview
🔑 Get professional coaching from Jitesh here: https://www.interviewquery.com/coaching?utm_source=youtube&utm_medium=social
🐦 Follow us on Twitter: https://twitter.com/interview_query
Are you a hiring manager looking to build data infrastructure with top-tier data engineers? Let Outsearch.ai take care of filtering out candidates while you focus on other things that matter: https://www.outsearch.ai/?utm_source=youtube&utm_medium=video&utm_campaign=outsearch_promotion&utm_content=uber_data_engineer_interview
Video Breakdown:
00:30 - Clarifying questions about the backend and functionality
2:28 - Initial design and solution for latency
11:18 - How would you design for analytics
19:15 - What does the schema look like all together?
22:34 - What's the benefit of a partition?
More from Jay:
Read my personal blog: https://datastream.substack.com/
Follow me on LinkedIn: https://www.linkedin.com/in/jay-feng-ab66b049/