Top 25
Prep plan
Updated weekly · Last refresh Oct 7

NBCUniversal Advertising Products & Solutions Data Engineer Interview Questions

The questions to prepare for a NBCUniversal Advertising Products & Solutions Data Engineer interview. Questions from real interview reports rank first. Updated daily.

25questions
~4htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 8 questions + 2 drills · ~89 min
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingNBCUniversal Advertising Products & Solutions
RANK vs DENSE_RANK in LeaderboardsEasy

Explain how RANK() and DENSE_RANK() handle ties differently in ordered SQL results such as leaderboards.

Window FunctionsRankingData WranglingNBCUniversal Advertising Products & Solutions
Optimizing Large Analytical SQL QueriesHard

Explain how to diagnose and optimize a slow analytical query on a multi-terabyte event table using SQL-aware tuning strategies.

JoinsData WranglingCTEsNBCUniversal Advertising Products & Solutions
Top Credit Score Applicants by StateMedium
Practice
Practice drill

Identify the highest-credit-score 5% of applicants within each state using percentiles and window ranking.

Window FunctionsJoinsRankingAmerican Credit Acceptance
Window Functions for Top UnitsMedium
Practice
Practice drill

Rank business units within each Genpact client by total billable revenue and return the top two performers.

Window FunctionsJoinsData ManipulationGenpact
More SQL & Data Manipulation questions with a free account
2
Pipelines6 questions · ~52 min
Design an End-to-End Data PipelineMedium

Approach for designing an end-to-end data pipeline from ingestion through transformation, storage, and downstream consumption.

data pipelinedesigningestionNBCUniversal Advertising Products & Solutions
Cloud Platform Experience for PipelinesMedium

Describe practical experience building pipelines on AWS, including orchestration, security, and data quality.

InfrastructureETLData ModelingNBCUniversal Advertising Products & Solutions
Batch vs Streaming Data ProcessingEasy

Compare batch and streaming data processing, including when each fits best in a pipeline.

Stream ProcessingETLBatch ProcessingNBCUniversal Advertising Products & Solutions
More Pipelines questions with a free account

Sign up to see every question

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

Get my prep plan
3
Coding3 questions · ~26 min
Fibonacci in PythonEasy

Assesses ability to implement common algorithms in Python.

Dynamic ProgrammingpythonNBCUniversal Advertising Products & Solutions
Python Star Pattern ScriptEasy

Tests basic programming ability and control flow for data-related scripting.

loopspythonNBCUniversal Advertising Products & Solutions
More Coding questions with a free account
4
Behavioral & Leadership8 questions · ~69 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 25 questions plus 2 hands-on drills to finish this plan.