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 Β· hard

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

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

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

What is the difference between OLTP and OLAP?

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

Command to Read JSON Data and Options

General/Otherhardspark2 min read
LTIMindtree
β†’
5

Compare batch processing and stream processing for financial data.

General/Otherhard2 min read
Goldman Sachs
β†’
6

Count occurrences of a specific word in a file

General/Otherhardpythonspark2 min read
KPMG
β†’
7

Data Security in BFSI - encryption, IAM, auditing

General/Otherhard2 min read
Lumiq
β†’
8

Data Storage and Retrieval Optimization techniques

General/Otherhardoptimizationpartition2 min read
Lumiq
β†’
9

Describe the ZS projects you worked on

General/Otherhardetljoinoptimization0.5 min read
Meesho
β†’
10

Explain your project and the technologies used so far.

General/Otherhardairflowbigquerysnowflake2 min read
Coforge
β†’
11

Find orders exceeding $1,000 in the last 30 days.

General/Otherhardsqlwindow2 min read
Comcast
β†’
12

Highlight the tools and technologies you've used in your current project

General/Otherhardairflowsnowflakespark2 min read
Nihilent
β†’
13

How do these transformations impact memory usage?

General/Otherhardjoinpartitionspark2 min read
TCS
β†’
14

How would you handle large datasets in a distributed computing environment?

General/Otherhardjoinoptimizationpartition2 min read
Wipro
β†’
15

How would you model customer transaction data for both analytical and operational use cases?

General/Otherhardpartitionsnowflakespark0.5 min read
BCG
β†’
16

How would you model hierarchical data in a relational database?

General/Otherhardetlsql0.5 min read
Goldman Sachs
β†’
17

Integrating an API with a Database - Steps

General/Otherhardairflowpartition0.6 min read
Verizon
β†’
18

Synchronization Mechanisms

General/Otherhard3 min read
ZS Associates
β†’
19

TCP vs UDP Protocol

General/Otherhard2 min read
ZS Associates
β†’
20

Tell us about your technical experience?

General/Otherhardairflowetloptimization2 min read
Aarete
β†’

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