DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies in Python/Coding Β· medium

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

Write a Python function to check if a string is a palindrome.

Python/Codingmediumjoinpython0.4 min read
CapcoHashedInLTIMindtree
β†’
2

Write a Python function to check if a string is a palindrome.

Python/Codingmediumjoinpython0.4 min read
AltimetrikInfosys
β†’
3

Create a Python program to demonstrate the use of set operations (union, intersection).

Python/Codingmediumjoinpython0.1 min read
American Express
β†’
4

Describe Spark's memory management model. How do you handle heap memory overhead issues?

Python/Codingmediumjoinpartitionspark0.2 min read
American Express
β†’
5

Differentiate SORT BY, ORDER BY, DISTRIBUTE BY, and CLUSTER BY

Python/Codingmediumpartition0.2 min read
Matrix
β†’
6

Extended the solution to determine the nth largest element in an array.

Python/Codingmediumpartition0.2 min read
Expedia
β†’
7

GeoPandas - definition and features

Python/Codingmediumjoin0.1 min read
NAB
β†’
8

Grouping and aggregation functions?

Python/Codingmediumpartitionsnowflakewindow0.2 min read
Snowflake
β†’
9

How many cities does each department operate in? List the top 3 departments in terms of the most number of cities. In case of a tie, order by dept_id.

Python/Codingmediumsql0.2 min read
Freight Tiger
β†’
10

How would you decide between using DISTKEY and SORTKEY?

Python/Codingmediumjoinpartition0.2 min read
Capco
β†’
11

Implement an algorithm to find the longest common prefix among an array of strings.

Python/Codingmediumpartitionspark0.6 min read
Disney+ Hotstar
β†’
12

List customers with more than 5 orders.

Python/Codingmediumjoinpartitionspark0.6 min read
Comcast
β†’
13

List every combination of dept_name, employee_name, and city such that the employee belongs to the department and the same city in which the department is located.

Python/Codingmediumjoin0.6 min read
Freight Tiger
β†’
14

Multithreading and Synchronization in Java - write code to manage synchronized threads

Python/Codingmediumpartition0.5 min read
Walmart
β†’
15

Replace words and perform string operations in Python (replace, vowel removal, word count, pattern check).

Python/Codingmediumjoinpython0.4 min read
Incedo
β†’
16

Reverse a string with special characters preserved.

Python/Codingmediumjoin0.5 min read
EY
β†’
17

Sort and merge arrays

Python/Codingmediumjoinpartitionpython0.4 min read
Pubmatic
β†’
18

Spark Coding: Using explode() Function to flatten nested arrays

Python/Codingmediumjoinpartitionspark0.4 min read
Lumiq
β†’
19

Stuff Function for XML Usages

Python/Codingmediumsql0.4 min read
NAB
β†’
20

What role does the executor heap size play in preventing OOM errors?

Python/Codingmediumpartitionpythonspark0.4 min read
PWC
β†’

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