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
181

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

Python/Codinghardpythonsql0.1 min read
Goldman Sachs
β†’
182

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

Python/Codinghardpartitionpythonspark0.2 min read
Goldman Sachs
β†’
183

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

Python/Codinghardjoinpython0.1 min read
American Express
β†’
184

Implement a recursive algorithm to find the nth Fibonacci number.

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

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

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

Modify a word count script to output results in descending frequency order.

Python/Codinghardspark0.5 min read
Impetus
β†’
187

Multiprocessing in Python - explain with example

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

Optimize a function to calculate moving averages of user engagement.

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

Partitioning a Linked List based on a value

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

Priority Queue Problem - task prioritization and dynamic sorting

Python/Codinghardairflow0.5 min read
PayPal
β†’
191

Programming languages and their application in past projects.

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

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

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

TCP Protocol Functionality

Python/Codinghardwindow0.4 min read
ZS Associates
β†’
194

Unix scripting in data engineering?

Python/Codinghardpythonspark0.5 min read
Comcast
β†’
195

What programming languages are you proficient in?

Python/Codinghardairflowbigqueryetl0.3 min read
Thoughtworks
β†’
196

When were lambda expressions introduced in Java?

Python/Codinghardspark0.4 min read
JP Morgan
β†’
197

Write a Python script to parse a large JSON file, filter records based on a condition, and write the result to a database.

Python/Codinghardpythonsql0.4 min read
Goldman Sachs
β†’
198

Write a function to detect anomalies in streaming data using a sliding window.

Python/Codinghardwindow0.4 min read
Disney+ Hotstar
β†’
199

Cloud Architecture - explain

SQLhardjoinoptimizationpartition3.6 min read
Nagarro
β†’
200

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

SQLhardjoinoptimizationpartition3.6 min read
Expedia
β†’

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...89101112...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