DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies in General/Other

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

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

General/Othermediumetlpartition0.7 min read
AltimetrikInfosys
β†’
3

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

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

What is the difference between OLTP and OLAP?

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

What is the difference between SQL and NoSQL databases?

General/Othermediumjoinsql0.7 min read
AareteDunnhumbyFragma Data Systems
β†’
6

ACID Properties

General/Othereasy0.3 min read
Presidio
β†’
7

APPLY Operator - CROSS APPLY and OUTER APPLY

General/Othermediumjoinsql0.3 min read
Kaseya
β†’
8

About Jira

General/Othereasy0.2 min read
Verizon
β†’
9

Agile Methodologies - sprint planning, standups, retrospectives

General/Othereasy0.3 min read
Nihilent
β†’
10

Agile in project management?

General/Othereasy0.2 min read
Comcast
β†’
11

Agile methodologies used?

General/Othereasy0.2 min read
Citi
β†’
12

An existing job running longer suddenly: how to analyze the issue?

General/Othermediumpartitionspark0.4 min read
Citi
β†’
13

Aptitude Questions - time and work problems

General/Othereasy0.3 min read
McKinsey
β†’
14

Are You Aware of Beam?

General/Othereasyetlspark0.2 min read
Tech Mahindra
β†’
15

Are there any benefits or perks that are particularly important to you?

General/Othereasy0.4 min read
Thoughtworks
β†’
16

Are you open to learning new tools and technologies?

General/Othereasy0.3 min read
Fragma Data Systems
β†’
17

Are you open to relocation or a hybrid work model?

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

Are you willing to relocate to Bangalore?

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

Basic logical or analytical puzzle

General/Othereasy0.2 min read
McKinsey
β†’
20

Build an executive dashboard for reporting.

General/Otherhardsnowflake0.2 min read
Uber
β†’

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