DataEngPrep.tech
QuestionsPracticeAI CoachDashboardPacksBlog
ProLogin

Interview Questions

Real questions from top companies Β· easy

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

Write code to calculate the power of a given number in minimum time complexity.

Python/Codingeasy0.2 min read
Expedia
β†’
502

Write code to manually invoke garbage collection in Java

Python/Codingeasy0.2 min read
Walmart
β†’
503

Write code to merge two sorted arrays without using extra space.

Python/Codingeasy0.3 min read
Goldman Sachs
β†’
504

Write code using Java's concurrent API (forEach, forEachEntry, forEachKey)

Python/Codingeasy0.2 min read
JP Morgan
β†’
505

Write pseudo code for an ETL pipeline using Python and Pandas

Python/Codingeasyetlpythonsql0.3 min read
Morgan Stanley
β†’
506

Zigzag Order Traversal of a Binary Tree

Python/Codingeasy0.3 min read
Meesho
β†’
507

Aggregate surface areas and calculate cumulative surface area using the LAG function.

SQLeasy0.2 min read
Deolite
β†’
508

Are you comfortable with the variable pay structure, and what are your expectations for the base salary?

SQLeasy0.5 min read
Nielsen
β†’
509

Building ETL pipelines to capture changes when new records are inserted into source tables?

SQLeasyetlsnowflake0.3 min read
Snowflake
β†’
510

CSV Without Column Names/Schema - how to read

SQLeasyspark0.1 min read
LTIMindtree
β†’
511

Can CASE statements be used in an UPDATE query?

SQLeasy0.2 min read
Fossil Group
β†’
512

Can you chain multiple triggers for a single pipeline?

SQLeasy0.2 min read
Virtusa
β†’
513

Can you provide a use case where Assert Transformations helped maintain data quality?

SQLeasyetl0.3 min read
Virtusa
β†’
514

Can you share an experience where you resolved a conflict within your team?

SQLeasyairflow0.4 min read
Fragma Data Systems
β†’
515

Case statement in SQL - explain

SQLeasysql0.2 min read
LTIMindtree
β†’
516

Compare Redshift, BigQuery, and Snowflake in terms of cost, performance, and scalability.

SQLeasybigquerysnowflake0.5 min read
BCG
β†’
517

Convert row-level records to column records.

SQLeasysparksql0.5 min read
Comcast
β†’
518

Converting SCD0 to SCD3

SQLeasysql0.6 min read
Nagarro
β†’
519

Count occurrences of each character in a string

SQLeasybigquerysnowflakespark0.4 min read
KPMG
β†’
520

Count the number of nulls in each column of a table.

SQLeasybigquerysparksql0.5 min read
Incedo
β†’

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...2425262728...36Next
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