Unknown Interview Questions (With Answers)

256 Questions asked

Sep 2026 First seen

Oct 2026 Last seen

256 Unique questions

🥧 Difficulty mix

How hard are these questions?

Easy 69 (27%)Medium 181 (71%)Hard 6 (2%)

📊 Question type

Breakdown by interview phase

🔥 12-week activity

When candidates are asked these

Last 12 weeks →

🏷️ Top topics

Where these questions cluster

Sql 41

Spark 38

Python 24

Etl 19

Data Pipeline 19

Snowflake 18

Window Functions 12

Data Engineering 10

👤 Experience level mix

What seniority these are asked at

Fresher (0-1yr) 36Junior (1-3yr) 110Mid (3-6yr) 104Senior (6+yr) 6

📝 Recent questions

Latest 10 asked by candidates

🟢 Easy ✅

You have a driver and executors. What is the role of each in Spark?

Spark Driver Executor

Conceptual · Asked 1× · Oct 2026

🟡 Medium ✅

Can you write a SQL query or a Python script to find all duplicate rows in a tickets table?

Sql Duplicate Detection Python

Coding · Asked 1× · Oct 2026

🟡 Medium ✅

Given a table with columns ID, student, name, and email, how would you handle duplicate names?

Sql Duplicate Handling Data Quality

Conceptual · Asked 1× · Oct 2026

🟢 Easy ✅

What is the difference between COUNT(*) and COUNT(email) in SQL?

Sql Aggregation Count

Conceptual · Asked 1× · Oct 2026

🟡 Medium ✅

What is the difference between ROW_NUMBER, DENSE_RANK, and RANK window functions?

Window Functions Sql Ranking Functions

Conceptual · Asked 1× · Oct 2026

🟡 Medium ✅

You mentioned building scalable data pipelines on Azure Data Factory or Azure Synapse. Can you describe a pipeline you built, including its sources, transformations, and overall purpose?

Azure Data Factory Azure Synapse Data Pipeline

Conceptual · Asked 1× · Oct 2026

🟡 Medium ✅

What does that data pipeline do? What were its sources, transformations, and target? How did you use Snowflake for fact and dimension tables?

Data Pipeline Snowflake Etl

Conceptual · Asked 1× · Oct 2026

🟡 Medium ✅

You mentioned storing data in ATL. Can you explain what ATL is and why you chose it?

Azure Table Storage Data Storage Azure

Conceptual · Asked 1× · Oct 2026

🟡 Medium ✅

What file formats did you use for raw data ingestion, and why did you choose JSON over Parquet for the raw layer?

File Formats Raw Layer Json

Conceptual · Asked 1× · Oct 2026

🟢 Easy ✅

Can you tell me the difference between narrow and wide transformations?

Spark Transformations

Conceptual · Asked 1× · Oct 2026

🎤 Want these answered in real-time during your interview?

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500