Data Engineering Interview Arena

Consulting delivery: Databricks and PySpark depth, SQL coding and client-facing project stories.

Azure-heavy: lakehouse, streaming checkpoints, schema drift, security and infrastructure as code.

Data-quality frameworks, incremental loads, SCD patterns and pipeline debugging.

Cloud-agnostic consulting loop with solid SQL and PySpark fundamentals.

Fundamentals first: SQL, warehousing concepts, Spark basics and communication.

Pipeline architecture questions, SCD with PySpark, data quality and stakeholder handling.

Concept-driven with a deep dive into one project; ETL vs ELT, joins, lake vs warehouse.

Deep Spark internals (Catalyst, memory), window-function SQL and design questions.

Engineering-led: real-time pipelines, consistency, schema evolution and production debugging.

Warehousing fundamentals, ETL design, incremental loads, monitoring and big-data concepts.

Migrations, SCD Type 2, skew, partitioning vs bucketing and automation.

Real-time transactions, consistency, PII protection, migration and incident response.

Scale and reliability at retail volumes: fraud streaming, consistency, skew and client communication.

Payments data: SQL windows, exactly-once ideas, quality and regulatory care.

Travel data: booking pipelines, de-duplication, clickstream skew and recommendation design.

Supply-chain data: Azure lakehouse, small files, SCD, global data models and migration.

End-to-end pipelines for travel data: SQL, Spark skew, ingestion design and root-cause analysis.

Large-scale data infrastructure: strong SQL, coding fundamentals, design trade-offs and collaboration under ambiguity.

SQL-heavy loop, data modelling and a bar-raiser round where every answer needs a specific story with metrics.

Fast SQL and Python, product-metric thinking, data modelling and impact-driven behavioral questions.

Senior-heavy: Spark and streaming depth, independent judgment and a culture conversation about freedom and responsibility.

Mobility data: SQL windows, streaming at scale, skew and exactly-once pipelines.

Azure data platform plus SQL windows, CDC, lake design and growth-mindset behavioral questions.

Data modelling, metric quality, Airflow orchestration and a values-driven final interview.

Spark and Delta internals, optimisation depth and customer-facing judgment.

Event pipelines at scale, data quality ownership and strong squad collaboration.

Travel data: SQL and Spark at scale, experimentation data, streaming and quality.

Payments data: correctness, reconciliation, streaming reliability and data protection.

E-commerce data platform: lakehouse, event streams, data contracts and governance.

Fast-moving fintech: SQL and Spark under pressure, quality, compliance and ownership.

Lakehouse and data modelling with a strong values and collaboration interview.

Event data at scale, pragmatic design and strong team and values conversations.

Banking data: governance, privacy, AWS, SQL and customer-impact stories.

Retail scale: lakehouse on Azure, pricing and inventory models, cost awareness.

Financial-services data: SQL rigour, quality, governance and sound judgment.