DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies in General/Other Β· hard

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

Have you worked on Data Warehousing projects?

General/Otherhardbigqueryetloptimization0.7 min read
AareteDunnhumby
β†’
2

Retrieve the most recent sale_timestamp for each product (Latest Transaction).

General/Otherhardbigquerypartitionsnowflake0.6 min read
PresidioSwiggy
β†’
3

What is the difference between OLTP and OLAP?

General/Otherhardbigqueryetljoin0.7 min read
AareteDunnhumbyFragma Data Systems
β†’
4

Are you open to relocation or a hybrid work model?

General/Otherhard0.3 min read
Wipro
β†’
5

Are you willing to relocate to Bangalore?

General/Otherhard0.3 min read
KPMG
β†’
6

Build an executive dashboard for reporting.

General/Otherhardsnowflake0.2 min read
Uber
β†’
7

Command to Read JSON Data and Options

General/Otherhardspark0.2 min read
LTIMindtree
β†’
8

Compare batch processing and stream processing for financial data.

General/Otherhard0.2 min read
Goldman Sachs
β†’
9

Count occurrences of a specific word in a file

General/Otherhardpythonspark0.2 min read
KPMG
β†’
10

Data Security in BFSI - encryption, IAM, auditing

General/Otherhard0.2 min read
Lumiq
β†’
11

Data Storage and Retrieval Optimization techniques

General/Otherhardoptimizationpartition0.1 min read
Lumiq
β†’
12

Describe the ZS projects you worked on

General/Otherhardetljoinoptimization0.5 min read
Meesho
β†’
13

Describe your approach to the case study.

General/Otherhard0.5 min read
ZS Associates
β†’
14

Describe your preferred work environment and collaboration style.

General/Otherhard0.5 min read
EPAM
β†’
15

Difference between var, val, and def in Scala

General/Otherhardspark0.4 min read
Matrix
β†’
16

Discuss Logical Plan vs Physical Plan

General/Otherhardjoinoptimizationpartition0.2 min read
KPMG
β†’
17

Discuss the nature and volume of data you manage daily

General/Otherhardairflowbigqueryetl0.2 min read
KPMG
β†’
18

Explain your day-to-day responsibilities as a Data Engineer

General/Otherhardairflowetlpython0.2 min read
KPMG
β†’
19

Explain your project and the technologies used so far.

General/Otherhardairflowbigquerysnowflake0.2 min read
Coforge
β†’
20

Explain your recent projects in detail.

General/Otherhardpythonsparksql0.2 min read
Altimetrik
β†’

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
123Next
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