Top 26
Prep plan
Updated weekly · Last refresh Oct 17

GEP Data Engineer Interview Questions

The questions to prepare for a GEP Data Engineer interview. Questions from real interview reports rank first. Updated daily.

26questions
~4htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 3 questions · ~28 min
Moving Average for Time SeriesEasy
Practice

Calculate each rolling average in a price series using a fixed-size sliding window and running sum.

MathArraysTime SeriesGEP
Analyzing Dataset AnomaliesMedium

Assesses your data investigation workflow for detecting, diagnosing, and interpreting anomalies.

Hash TablesArraysSortingGEP
More Coding questions with a free account
2
SQL & Data Manipulation3 questions + 2 drills · ~48 min
Second Highest Without AggregatesHard
Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsGEP
Handling Missing Values in SQLEasy

Explain how to detect and handle NULL values in SQL using filtering, COALESCE, CASE, and business-aware imputation.

Data WranglingETLCase WhenGEP
SQL vs NoSQL DifferencesEasy

Tests understanding of relational vs non-relational data models and when to use each.

JoinsData WranglingAggregationsGEP
SQL: Top 3 Products Each MonthMedium
Practice
Practice drill

Rank products by monthly sales and return the top three products for each month.

Window FunctionsDate FunctionsJoinsGenpactEmersonGEP
Truncate vs DeleteMedium
Practice
Practice drill

Explain how TRUNCATE and DELETE differ in row removal, transaction behavior, and identity handling.

database managementData Manipulationdata managementCCitiusTechSStandards AustraliaGGentrack

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Pipelines13 questions · ~121 min
Basic Spark Scala Pipeline QuestionsEasy

Basic Spark Scala interview topics for ETL pipelines, covering core transformations, execution model, and data quality checks.

InfrastructureBatch ProcessingData ModelingGEP
Modernize Hadoop to Spark PipelinesEasy

Design a Spark-based batch and streaming pipeline to replace legacy Hadoop jobs and deliver analytics data with sub-3-minute freshness.

InfrastructureToolsBatch ProcessingGEP
Design Real-Time Sensor Event PipelineHard

Design a real-time pipeline for sensor events that transforms data and feeds a UI with low latency.

Stream ProcessingOrchestrationDependenciesGEP
More Pipelines questions with a free account
4
Behavioral & Leadership7 questions · ~65 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 26 questions plus 2 hands-on drills to finish this plan.