DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

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

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

Find the names of managers who have at least 7 employees directly reporting to them.

General/Othermediumjoinsql0.1 min read
Deolite
β†’
22

Find top 3 products sold based on total quantity.

General/Othermediumsql0.2 min read
Comcast
β†’
23

Given exchange rates for USD to INR with timestamps: Find the ticket price in rupees for various dates. Use the latest exchange rate based on the timestamp for each date.

General/Othermediumjoinsparkwindow0.2 min read
Expedia
β†’
24

Given the data with id, name, and department, how would you calculate how many employees are in each department?

General/Othermediumsparksqlwindow0.1 min read
Infosys
β†’
25

Graph Databases - explain

General/Othermedium0.2 min read
Nagarro
β†’
26

Handling node failures

General/Othermediumpartitionspark0.2 min read
media.net
β†’
27

How can technology improve private equity investments?

General/Othermedium0.2 min read
Moonfare
β†’
28

How does Z ORDERING enhance data retrieval performance?

General/Othermediumpartition0.2 min read
Puma
β†’
29

How does cluster size impact parallelism limits?

General/Othermediumpartition0.2 min read
TCS
β†’
30

How would you optimize a slow-running SQL query?

General/Othermediumjoinpartitionsql0.2 min read
Wipro
β†’
31

How would you implement custom alarms for data delays or job failures?

General/Othermediumairflowpartition0.6 min read
Capco
β†’
32

Identify the top 5 customers with the highest purchases in the last quarter.

General/Othermediumbigquerypartitionsnowflake0.5 min read
Aarete
β†’
33

Match countries in a pairwise format

General/Othermediumjoinpartitionpython0.3 min read
KPMG
β†’
34

Reverse operation for splitting values back to original format

General/Othermediumetljoinpython0.1 min read
Pubmatic
β†’
35

Shell commands for renaming a file?

General/Othermediumwindow0.1 min read
Citi
β†’
36

Solve Minimum Remove to Make Valid Parentheses.

General/Othermediumjoinpython0.3 min read
Disney+ Hotstar
β†’
37

Steps to Verify Source and Target Data Match After Load

General/Othermediumjoinpartition0.2 min read
Verizon
β†’
38

WAQ for Desired Output (Node Parent Relationship)

General/Othermediumjoin0.3 min read
TCS
β†’
39

What are the benefits of the COPY command's MANIFEST option?

General/Othermediumpartition0.2 min read
Capco
β†’
40

What steps do you take to troubleshoot a slow-running Spark job?

General/Othermediumjoinpartitionspark0.2 min read
Dunnhumby
β†’

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
Previous123Next
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