data-engineering

Generates data engineering interview questions covering data warehousing, streaming pipelines, and data quality.

23|1|Updated Aug 3, 2026
One-click install
npx skills add https://github.com/yuecao365/OfferCome --skill data-engineering-yuecao365
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-engineering
Source: https://github.com/yuecao365/OfferCome/tree/main/src/lib/mock-interviews/skills/data-engineering
Command: npx skills add https://github.com/yuecao365/OfferCome --skill data-engineering-yuecao365

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Interviewers and mock-interview systems often struggle to produce realistic, scenario-based data engineering questions that go beyond textbook definitions and actually probe a candidate's hands-on experience with data warehouses, pipelines, and data quality incidents. ## Core Features & Use Cases - Topic Coverage: Provides structured question ladders across data warehouse layering, dimensional modeling, offline SQL optimization, real-time Flink pipelines, scheduling and task governance, data quality, lakehouse formats (Iceberg/Hudi/Paimon), metric governance, cost optimization, and CDC data ingestion. - Good vs Bad Question Patterns: Contrasts shallow definitional questions with scenario-based alternatives, including danger signals and expected signals for evaluating candidate answers. - Resume-Based Probing: Supplies follow-up hooks tied to resume claims such as real-time warehouses, performance optimization, and scheduling platforms. - Use Case: When a candidate's resume mentions building a real-time data warehouse with Flink, load this Skill to generate targeted follow-ups on state size, checkpoint intervals, late data handling, and past production incidents. ## Quick Start Load this Skill and ask it to generate interview questions for a candidate whose resume mentions Hive, Spark, and real-time data warehouse experience.

Frequently Asked Questions about data-engineering

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create realistic data engineering interview questions?▼

Anchor every question to data accuracy or pipeline incidents rather than definitions. For example, instead of asking what a zipper table is, ask whether a specific scenario needs one and how to backfill history without it.

What topics should a data warehouse interview cover?▼

Cover ODS/DWD/DWS/ADS layering trade-offs, dimensional modeling with fact granularity and SCD2 zipper tables, SQL optimization for data skew, scheduling with idempotent reruns, data quality rules, and metric governance across teams.

How to evaluate a candidate's Flink real-time pipeline experience?▼

Probe checkpoint intervals, state size and TTL, watermark handling for late data, and how they reconciled real-time metrics against T+1 offline reports. Ask about actual production incidents rather than exactly-once theory.

Should interview questions differ for junior versus senior data engineers?▼

Yes. Junior candidates should face SQL fundamentals like window functions, deduplication, and retention calculations plus basic layering concepts. Senior candidates should face lakehouse migration trade-offs, cost attribution, SLA design, and cross-team metric alignment.

What are red flags in data engineering interview answers?▼

Red flags include reciting layer names without owning specific tables, suggesting adding executors before reading execution plans, claiming real-time data is always correct, and treating metric definitions as purely a business concern.