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

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

How do you handle data cleanup and lifecycle management in S3?

Cloud/Toolsmediumpartition2 min read
Moonfare
β†’
82

How would you optimize an ADF pipeline for high performance?

Cloud/Toolsmediumpartition1 min read
Persistent Systems
β†’
83

How would you migrate 1TB of data using ADF?

Cloud/Toolsmediumpartition0.8 min read
Virtusa
β†’
84

How would you optimize cost when using AWS for large-scale data processing?

Cloud/Toolsmediumpartition0.7 min read
Wipro
β†’
85

Lambda vs. Glue: Discuss use cases for both services.

Cloud/Toolsmediumetljoinspark0.7 min read
Bitwise
β†’
86

What alternatives to Kinesis would you consider for real-time data ingestion?

Cloud/Toolsmediumpartition0.5 min read
Capco
β†’
87

Calculate a 7-day moving average of orders for each city in the Swiggy database.

General/Othermediumpartitionsparksql2 min read
Swiggy
β†’
88

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

General/Othermediumjoinsparksql2 min read
Wayfair
β†’
89

Data Shuffling Causes and Techniques

General/Othermediumjoinpartitionspark2 min read
Nagarro
β†’
90

Describe a scenario where you had to optimize a slow-running data pipeline.

System Design/Architecturemediumjoinpartition2 min read
Swiggy
β†’
91

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

General/Othermediumjoinpartition0.6 min read
Goldman Sachs
β†’
92

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

General/Othermediumjoinpartitionsql0.3 min read
Deolite
β†’
93

Find All Numbers that Appear at Least Three Times Consecutively

General/Othermediumpartition2 min read
Meesho
β†’
94

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

General/Othermediumjoinsql1 min read
Deolite
β†’
95

Find top 3 products sold based on total quantity.

General/Othermediumsql2 min read
Comcast
β†’
96

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

General/Othermediumsparksqlwindow2 min read
Infosys
β†’
97

How does cluster size impact parallelism limits?

General/Othermediumpartition2 min read
TCS
β†’
98

How would you optimize a slow-running SQL query?

General/Othermediumjoinpartitionsql2 min read
Wipro
β†’
99

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

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

Reverse operation for splitting values back to original format

General/Othermediumetljoinpython2 min read
Pubmatic
β†’

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
Previous1...34567...11Next
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