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

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

How does Spark's Catalyst Optimizer work? Explain its stages.

Spark/Big Datahardjoinoptimizationspark3 min read
DunnhumbyFragma Data SystemsHashedIn
β†’
42

How do you handle late-arriving data in Spark Structured Streaming?

Spark/Big Datahardsparkwindow0.5 min read
BitwiseIncedoSwiggy
β†’
43

What is the difference between Managed and External tables in Hive/Spark?

Spark/Big Dataeasyspark2 min read
CitiDunnhumbyFragma Data Systems
β†’
44

What is the small-file problem in Spark, and how do you solve it?

Spark/Big Datahardpartitionspark2 min read
Daniel WellingtonIncedoSwiggy
β†’
45

Explain the concept of Broadcast Join in Spark. When should it be used?

Spark/Big Datamediumjoinsparksql2 min read
Delivery HeroDunnhumbyFragma Data Systems
β†’
46

How do you optimize Spark jobs for better performance? Mention at least 5 techniques.

Spark/Big Datahardjoinoptimizationpartition1 min read
Fragma Data SystemsPresidioSwiggy
β†’
47

What is the difference between a list and a tuple in Python?

Python/Codingeasypython2 min read
AccentureDelivery HeroFragma Data Systems
β†’
48

Explain the difference between shallow copy and deep copy in Python.

Python/Codingeasypython2 min read
Delivery HeroDunnhumbyFragma Data Systems
β†’
49

Write a Python function to find the first non-repeating character in a string.

Python/Codingeasypython2 min read
Delivery HeroDunnhumbyFragma Data Systems
β†’
50

What are decorators in Python, and how do they work?

Python/Codingeasypython2 min read
Delivery HeroFragma Data SystemsSwiggy
β†’
51

Explain the difference between args and kwargs in Python.

Python/Codingeasypython1 min read
Delivery HeroFragma Data SystemsSwiggy
β†’
52

How do you ensure smooth communication between data scientists, business teams, and developers?

Behavioraleasy0.7 min read
AccentureYash Technologies
β†’
53

How do you handle conflicts within a team? Provide an example.

Behavioralhard0.7 min read
EPAMJIO
β†’
54

How do you handle disagreements within a team?

Behavioraleasy0.6 min read
ExpediaWarner Bros Discovery
β†’
55

Tell me about a time when you faced a challenging situation at work and how you handled it.

Behavioralmediumairflowpartitionspark0.7 min read
FreechargeWalmart
β†’
56

What challenges did you face, and how did you tackle them?

Behavioralmediumjoinpartitionspark0.6 min read
Delivery HeroGrover
β†’
57

What is the most difficult task you've ever worked on?

Behavioraleasylakehousesparksql0.6 min read
CognizantIncedo
β†’
58

What would you do if a pipeline failed and you couldn't find the reason?

Behavioralmediumpartitionspark0.7 min read
Delivery HeroGrover
β†’
59

Why are you leaving your current company?

Behavioralhard0.6 min read
AareteIncedo
β†’
60

Why do you want to join this company?

Behavioralmediumjoin0.5 min read
AccentureDelivery HeroFragma Data Systems
β†’

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
Previous12345...40Next
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