Real Interview Questions

Which is SCD type 2. What is its behavior?

✅

Scd Data Warehousing Etl

🟢 Easy Conceptual Junior 👤 Interview Asked 10× Aug 2026

If a downstream analyst says a dashboard is slow because a query over your Redshift or a thinner layer is scanning far too much data, how would you diagnose and optimize that end‑to‑end?

✅

Redshift Data Warehousing Performance Tuning

🟡 Medium Conceptual Mid 👤 Data Engineering 🏢 Uber Asked 1× Jul 2026

What about Snowflake? Have you experienced Snowflake as well?

✅

Snowflake Data Warehousing Cloud

🟢 Easy Conceptual Junior 👤 Data Engineering 🏢 Snowflake Asked 1× Jul 2026

What is the difference between a star schema and a snowflake schema? Do you use them?

✅

Star Schema Snowflake Schema Data Warehousing

🟡 Medium Conceptual Mid 👤 Data Engineering 🏢 Amazon Asked 1× Jul 2026

Data is stored as facts and dimensions. What are fact and dimension tables?

✅

Data Warehousing Fact Table Dimension Table

🟢 Easy Conceptual Fresher 👤 Data Engineering 🏢 Microsoft Asked 1× Jul 2026

Shubhi, the question is simple: When a modeler is giving a proposal to someone, should they structure the table and approach with technical rationale? Which platform are you using? In Databricks, if you are giving someone a model that works on finance data and the requirement is to maintain history, from an implementation point of view, what is the underlying architecture of Databricks?

✅

Databricks Data Modeling Data Warehousing History Maintenance

🟡 Medium Conceptual Mid 👤 Data Engineer/ Data Modeler 🏢 Snowflake Asked 1× Jul 2026

How would you implement logic for three ordered tiers (Bronze, Silver, Gold) in a target table?

✅

Data Pipeline Data Warehousing Etl

🟡 Medium Conceptual Junior 👤 Data Engineer 🏢 everesttech Asked 1× Jul 2026

Can you design and implement a system that can extract data from APIs and load it into an S3 bucket or a posted location, given that you have to deal with complex and large data volumes from various API systems, including social media and other API systems?

✅

Api Integration Data Warehousing

🔴 Hard System Design Senior 👤 Lead Data Engineering 🏢 Morgan Stanley Asked 1× Mar 2026