Essential cookies keep authentication working. With your permission, we also use analytics cookies to understand and improve the product. Read our Privacy Policy

DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPricingBlog
ProLogin

Interview Questions

Real questions from top companies Β· hard

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

Design a solution to generate unique device names from a list of IoT devices.

Python/Codinghardjoinoptimizationpartition3.6 min read
Expedia
β†’
122

Design an algorithm to merge k sorted lists of video streaming data.

Python/Codinghardjoinoptimizationpartition3.6 min read
Disney+ Hotstar
β†’
123

Difference between Stack vs Queue

Python/Codinghardpython2 min read
ZS Associates
β†’
124

Explain your approach to designing a scalable customer loyalty program data platform.

Python/Codinghardjoinoptimizationpartition3.6 min read
Adidas
β†’
125

Given 1TB of a file, how to check word count?

Python/Codinghardpartitionspark2 min read
Citi
β†’
126

How does your tech stack support scalability and analytics?

Python/Codinghardpartitionspark2 min read
Moonfare
β†’
127

How would you handle memory constraints when processing a large dataset in Python?

Python/Codinghardpythonsql2 min read
Goldman Sachs
β†’
128

How would you process a 10TB dataset on a single machine in Python?

Python/Codinghardpartitionpythonspark2 min read
Goldman Sachs
β†’
129

Implement a Python function to count unique words from a file and write them to another file.

Python/Codinghardjoinpython2 min read
American Express
β†’
130

Implement a recursive algorithm to find the nth Fibonacci number.

Python/Codinghardpartition0.6 min read
Goldman Sachs
β†’
131

Implement an algorithm to find the longest ordered subsequence of vowels in a given string.

Python/Codinghardspark0.6 min read
Expedia
β†’
132

Multiprocessing in Python - explain with example

Python/Codinghardpartitionpythonwindow0.5 min read
NAB
β†’
133

Optimize a function to calculate moving averages of user engagement.

Python/Codinghardoptimizationsparkwindow0.5 min read
Disney+ Hotstar
β†’
134

Partitioning a Linked List based on a value

Python/Codinghardpartitionspark0.6 min read
Walmart
β†’
135

Programming languages and their application in past projects.

Python/Codinghardairflowetlpython0.6 min read
ZS Associates
β†’
136

Solve the Dutch National Flag problem in one pass. How would you handle it?

Python/Codinghardpartition0.5 min read
Microsoft
β†’
137

Cloud Architecture - explain

SQLhardjoinoptimizationpartition3.6 min read
Nagarro
β†’
138

Consolidate hotel reviews and create a dashboard. Design a data model for the reviews.

SQLhardjoinoptimizationpartition3.6 min read
Expedia
β†’
139

Create Spark Session, read CSV, join, and write as table. Provide example code.

SQLhardetljoinoptimization0.3 min read
FedEx Dataworks
β†’
140

Data Warehouse Design from scratch

SQLhardjoinoptimizationpartition3.6 min read
Walmart
β†’

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...56789...22Next
Categories
All QuestionsSQLSpark / Big DataPython / CodingSystem DesignCloud / ToolsBehavioral
By Company
AmazonGoogleDatabricksSnowflakeAWSAzureMicrosoftNetflixUberTCS
Interview Guides
All GuidesTop SQL QuestionsTop Spark QuestionsPySpark QuestionsTop Python QuestionsTop System DesignKafka QuestionsAirflow QuestionsSQL Window FunctionsETL QuestionsData Modeling
Products
AI Interview CoachAnswer AnalyzerSQL PlaygroundResume AnalyzerAnswer Vault PDFsPricing
Company
About & Editorial PolicyContact UsAI DisclosureDisclaimerTerms of ServicePrivacy Policy
Β© 2026 DataEngPrep.tech. All rights reserved.
AboutBlogContactDisclaimer