DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies Β· hard

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

Describe your work with microservices.

System Design/Architecturehardoptimizationpartitionspark4 min read
Thoughtworks
β†’
562

Design a Data Warehouse for an e-commerce platform.

System Design/Architecturehardoptimizationpartitionsnowflake4 min read
HashedIn
β†’
563

Design a data model for a ride-hailing app.

System Design/Architecturehardoptimizationpartitionspark4 min read
Uber
β†’
564

Design a data model for a ridesharing app

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

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

System Design/Architecturehardbigqueryoptimizationpartition4 min read
Amazon
β†’
566

Design a data model for capturing watch sessions across multiple devices

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

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

System Design/Architecturehardoptimizationpartitionspark4 min read
Microsoft
β†’
568

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
β†’
569

Design a data pipeline for streaming analytics.

System Design/Architecturehardjoinoptimizationpartition3 min read
Uber
β†’
570

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
β†’
571

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

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

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

System Design/Architecturehardjoinoptimizationpartition3 min read
Microsoft
β†’
573

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
β†’
574

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

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

Design a data warehouse for a grocery store.

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

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

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

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

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

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

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

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

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

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
Previous1...2728293031...34Next
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