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 in General/Other · medium

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

How would you read data from a web API? What steps would you follow after reading the data?

General/Othermediumetlpartition0.7 min read
AltimetrikInfosys
→
2

What is the difference between SQL and NoSQL databases?

General/Othermediumjoinsql0.7 min read
AareteDunnhumbyFragma Data Systems
→
3

Calculate the total number of transactions (units sold) for each product.

General/Othermediumjoinsparksql2 min read
Wayfair
→
4

Describe the concept of data sharding and when to use it.

General/Othermediumjoinpartition0.6 min read
Goldman Sachs
→
5

Fetch the rows with the highest scores for each student in a year.

General/Othermediumjoinpartitionsql0.3 min read
Deolite
→
6

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

General/Othermediumjoinsql1 min read
Deolite
→
7

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

General/Othermediumsparksqlwindow2 min read
Infosys
→
8

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

General/Othermediumairflowpartition0.6 min read
Capco
→
9

Reverse operation for splitting values back to original format

General/Othermediumetljoinpython2 min read
Pubmatic
→
10

Shell commands for renaming a file?

General/Othermediumwindow2 min read
Citi
→

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