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
101

How would you model hierarchical data in a relational database?

General/Otherhardetlsql0.5 min read
Goldman Sachs
β†’
102

Integrating an API with a Database - Steps

General/Otherhardairflowpartition0.6 min read
Verizon
β†’
103

Mapper and Reducer design for solving Two-Sum

System Design/Architecturehardjoinoptimizationpartition3.6 min read
media.net
β†’
104

What are your strengths, and how do they align with the Data Engineer role?

General/Otherhard2 min read
American Express
β†’
105

What is your data volume?

General/Otherhard2 min read
HCL
β†’
106

Count occurrences of elements in a list of tuples using Spark RDDs

Python/Codinghardoptimizationpartitionspark1 min read
Tiger Analytics
β†’
107

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

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

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

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

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

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

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

Python/Codinghardpartitionspark2 min read
Citi
β†’
111

How does your tech stack support scalability and analytics?

Python/Codinghardpartitionspark2 min read
Moonfare
β†’
112

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

Python/Codinghardpythonsql2 min read
Goldman Sachs
β†’
113

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

Python/Codinghardjoinpython2 min read
American Express
β†’
114

Implement a recursive algorithm to find the nth Fibonacci number.

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

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

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

Multiprocessing in Python - explain with example

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

Optimize a function to calculate moving averages of user engagement.

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

Partitioning a Linked List based on a value

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

Programming languages and their application in past projects.

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

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

Python/Codinghardpartition0.5 min read
Microsoft
β†’

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...45678...21Next
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