GEP Data Engineer Interview Questions
The questions to prepare for a GEP Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Find the second highest salary in each department without using aggregate functions.
GEPExplain how to detect and handle NULL values in SQL using filtering, COALESCE, CASE, and business-aware imputation.
GEPTests understanding of relational vs non-relational data models and when to use each.
GEPFind all GEP employees with the highest or lowest non-null salary using self-joins, CASE expressions, and no subqueries.
GEPAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreCalculate each rolling average in a price series using a fixed-size sliding window and running sum.
GEPAssesses your breadth across common data engineering languages and problem-solving formats.
GEPSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Design a real-time pipeline for sensor events that transforms data and feeds a UI with low latency.
GEPExplain the ETL process, why it matters, and how it fits into a practical data pipeline.
GEPDesign the core pipeline infrastructure for a new project, with attention to orchestration, data quality, idempotency, and future scale.
GEP