DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies in System Design/Architecture Β· hard

700+ Easy450+ Medium650+ Hard
All CategoriesBehavioralSpark/Big DataSQLPython/CodingSystem Design/ArchitectureCloud/ToolsGeneral/Othereasymediumhard
41

Describe your work with microservices.

System Design/Architecturehardoptimizationpartitionspark4 min read
Thoughtworks
β†’
42

Design a Data Warehouse for an e-commerce platform.

System Design/Architecturehardoptimizationpartitionsnowflake4 min read
HashedIn
β†’
43

Design a data model for a ride-hailing app.

System Design/Architecturehardoptimizationpartitionspark4 min read
Uber
β†’
44

Design a data model for a ridesharing app

System Design/Architecturehardoptimizationpartitionspark4.1 min read
McKinsey
β†’
45

Design a data model for an e-commerce system tracking orders, shipments, and payments.

System Design/Architecturehardbigqueryoptimizationpartition4 min read
Amazon
β†’
46

Design a data model for capturing watch sessions across multiple devices

System Design/Architecturehardoptimizationpartitionspark4.1 min read
Netflix
β†’
47

Design a data model to track orders, payments, and shipping β€” handle changes in customer address

System Design/Architecturehardoptimizationpartitionspark4 min read
Microsoft
β†’
48

Design a data pipeline for real-time analytics of e-commerce transactions. Ensure to include data ingestion, processing, storage, and visualization components.

System Design/Architecturehardoptimizationpartitionspark4.1 min read
Puma
β†’
49

Design a data pipeline for streaming analytics.

System Design/Architecturehardjoinoptimizationpartition3 min read
Uber
β†’
50

Design a data pipeline from end to end - describe how data would be ingested, processed, stored, and queried.

System Design/Architecturehardjoinlakehouseoptimization2.6 min read
Apple
β†’
51

Design a data pipeline to collect, process, and visualize customer feedback from Adidas stores worldwide.

System Design/Architecturehardjoinoptimizationpartition3.1 min read
Adidas
β†’
52

Design a data pipeline to ingest and process clickstream data in near real-time

System Design/Architecturehardjoinoptimizationpartition3 min read
Microsoft
β†’
53

Design a data pipeline to ingest and process data from multiple sources (e.g., S3, Kinesis) to Redshift using Spark.

System Design/Architecturehardjoinoptimizationpartition2.9 min read
EPAM
β†’
54

Design a data warehouse for 7-11 or 24x7 stores

System Design/Architecturehardjoinoptimizationpartition2.7 min read
McKinsey
β†’
55

Design a data warehouse for a grocery store.

System Design/Architecturehardetljoinoptimization2.6 min read
Comcast
β†’
56

Design a data warehouse schema to track orders, customers, delivery partners, and payments.

System Design/Architecturehardjoinoptimizationpartition2.6 min read
Swiggy
β†’
57

Design a database schema for tracking stock trades in real-time.

System Design/Architecturehardjoinoptimizationpartition2.6 min read
Goldman Sachs
β†’
58

Design a database schema to store customer transactions, including attributes like region, product category, and timestamp.

System Design/Architecturehardjoinoptimizationpartition2.5 min read
Adidas
β†’
59

Design a high-level system for a Netflix-like app.

System Design/Architecturehardjoinoptimizationpartition2.7 min read
Gartner
β†’
60

Design a logging and monitoring solution for a mission-critical data pipeline.

System Design/Architecturehardjoinoptimizationpartition2.7 min read
Swiggy
β†’

Reading isn't practice. Get AI feedback on your answers.

Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.

Try AI Answer Coach β€” FreeStart a Mock Interview
Previous12345...8Next
Categories
All QuestionsSQLSpark / Big DataPython / CodingSystem DesignCloud / ToolsBehavioral
By Company
AmazonGoogleDatabricksSnowflakeMicrosoftNetflixUberTCS
Interview Guides
All GuidesTop SQL QuestionsTop Spark QuestionsTop Python QuestionsTop System DesignSQL Window FunctionsETL QuestionsData Modeling
Products
AI Interview CoachAnswer AnalyzerSQL PlaygroundResume AnalyzerInterview PacksPricing
Company
About UsContact UsAI DisclosureDisclaimerTerms of ServicePrivacy Policy
Β© 2026 DataEngPrep.tech. All rights reserved.
AboutBlogContactDisclaimer