Free interview guides
Interview questions by topic
35 topic guides drawn from the same question bank that powers our Interview Prep tool — real questions asked in Indian tech interviews, with answers, not just lists. Pick your stack below, or practice interactively with Interview Prep.
SQL & Databases
SQL interview questions
Joins, window functions, and query-tuning questions asked in almost every data round.
MySQL interview questions
Storage engines, indexing and replication specifics for MySQL-heavy stacks.
PostgreSQL interview questions
MVCC, EXPLAIN plans and Postgres-specific features interviewers probe.
Data Modeling interview questions
Star vs snowflake, SCDs, and normalisation trade-offs.
Data Warehouse interview questions
Kimball vs Inmon, fact/dimension design, and warehouse operations.
Python & Data
Python interview questions
Core language, data structures and the patterns screeners actually test.
Pandas interview questions
GroupBy, merges, and memory-safe dataframe handling.
NumPy interview questions
Vectorisation, broadcasting and array internals.
Statistics interview questions
Distributions, hypothesis testing and the A/B questions analysts get.
Data Engineering & Cloud
PySpark interview questions
Partitions, shuffles, and optimisation scenarios from real DE rounds.
Spark interview questions
Execution model, memory management and cluster tuning.
Databricks interview questions
Delta Lake, Unity Catalog and lakehouse workflow questions.
Kafka interview questions
Partitioning, consumer groups, and exactly-once semantics.
Airflow interview questions
DAG design, backfills, and scheduler behaviour.
ETL interview questions
Pipeline design and data-quality questions for ETL roles.
ETL Testing interview questions
Test strategy, reconciliation and validation scenarios.
dbt interview questions
Models, tests, snapshots and the analytics-engineering workflow.
AWS interview questions
The services and architecture questions data candidates meet.
AWS Glue interview questions
Crawlers, jobs and Glue-specific pipeline design.
Redshift interview questions
Distribution keys, sort keys and warehouse tuning.
BigQuery interview questions
Partitioning, clustering and cost-aware SQL on GCP.
GCP Data Engineer interview questions
Dataflow, Pub/Sub and the GCP DE certification round.
Azure Data Factory interview questions
Pipelines, triggers and integration-runtime questions.
Snowflake interview questions
Micro-partitions, warehouses and time travel.
Hadoop interview questions
HDFS, YARN and the legacy-stack questions that still come up.
Hive interview questions
Partitioning, SerDes and Hive-on-Hadoop specifics.
Scala interview questions
The functional-programming questions Spark-in-Scala shops ask.
BI & Analytics
Platform & Tools
System Design interview questions
Scalability and architecture rounds for data-adjacent roles.
Git interview questions
Branching, rebasing and collaboration workflow questions.
Jenkins interview questions
CI/CD pipeline questions for data platform roles.
SSIS interview questions
Packages, transformations and Microsoft-stack ETL.
Informatica interview questions
Mappings, workflows and enterprise ETL scenarios.