Training Trains logo

Data Engineering Internship Interview Questions for Freshers (with Answers)

By K. Boopathikumar, CEO & Founder · 16 November 2026 · 8 min read

Data engineers build the pipelines that move and clean data so analysts and models can trust it. Intern interviews focus on SQL, data modelling and how you would build a reliable pipeline.

Pipelines

  • ETL vs ELT? ETL transforms data before loading it into the warehouse. ELT loads raw data first and transforms it inside the warehouse, which modern cloud warehouses make cheap and flexible.
  • Batch vs streaming? Batch processes data in chunks on a schedule (nightly sales). Streaming processes events as they arrive (live fraud checks). Batch is simpler; use streaming only when freshness really matters.
  • What makes a pipeline idempotent? Running it twice for the same day gives the same result, for example by overwriting a date partition instead of appending. This makes reruns safe.
  • What is Airflow used for? Scheduling and monitoring pipelines as DAGs (tasks with dependencies), with retries and alerts.

Modelling and storage

  • Fact vs dimension tables? Facts hold measurable events (orders, amounts); dimensions describe them (customer, product, date). Together they form a star schema.
  • What is a slowly changing dimension? A dimension whose values change over time, such as a customer's city. Type 2 keeps history by adding a new row with start and end dates.
  • Data lake vs data warehouse? A lake stores raw files of any type cheaply; a warehouse stores structured, modelled data for fast queries. A lakehouse combines both.
  • Why use Parquet instead of CSV? Parquet is columnar and compressed, so queries read only needed columns and files are much smaller.
  • What is partitioning? Splitting a table by a column such as date so queries scan only the relevant parts.

Spark, SQL and quality

  • What is Spark good at? Processing data too big for one machine by splitting work across a cluster, with SQL and DataFrame APIs.
  • Transformation vs action in Spark? Transformations (filter, select) build a plan lazily; actions (count, write) run it.
  • How do you remove duplicates keeping the latest record? Use ROW_NUMBER() OVER (PARTITION BY id ORDER BY updated_at DESC) and keep row number 1.
  • How do you check data quality? Tests for nulls, uniqueness, valid ranges and row counts against the source, run on every load, with alerts on failure.

How to answer well in the interview

  • Draw your pipeline: source, ingestion, storage, transformation, serving and monitoring.
  • Talk about failure: what happens if the source is late or sends bad data.
  • Be strong in SQL; it is the most tested skill for data engineering interns.
  • Mention cost, such as scanning less data with partitions; real teams care.

Next steps

Looking for an internship near Erode?

10 days to 6 months, online or at our Erode and Perundurai branches, with a verifiable certificate.

See internships →

More guides