Top 25
Prep plan
Updated weekly · Last refresh Oct 17

Factset Data Engineer Interview Questions

The questions to prepare for a Factset 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. 13 questions + 1 drill · ~136 min
Second Highest Without AggregatesHard
Practice

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

SubqueriesRankingSelf-JoinsFactset
Group By vs Having in ReportingEasy

Explain how GROUP BY forms aggregates and HAVING filters aggregated results in a reporting scenario.

Group ByHavingAggregationsFactset
SQL Query BasicsEasy

Assesses your fundamentals of writing correct SQL queries.

sql queryFactset
Handling Missing DataEasy
Practice
Practice drill

Replace missing sales fields with defined defaults and return a consistently ordered dataset.

missing valuesdata cleaningnull handlingUniversity of MinnesotaThe Home DepotNationwide
More SQL & Data Manipulation questions with a free account
2
Pipelines4 questions · ~39 min
Backfill Without Duplicate RecordsHard

Approach for rerunning failed pipeline ranges and correcting data safely with idempotent writes and quality checks.

IdempotencyBackfillingQualityFactset
Real-Time Dashboard Data PipelineMedium

Design a streaming pipeline that keeps dashboard data fresh and accurate for operational reporting.

InfrastructureStream ProcessingOrchestrationFactset
Explain ETL in Data EngineeringEasy

Explain the ETL process, why it matters, and how it fits into a practical data pipeline.

ETLOrchestrationQualityFactset
More Pipelines questions with a free account
3
Behavioral & Leadership6 questions · ~58 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~19 min
Merging Dictionaries in PythonEasy
Practice

Merge two Macy's catalog dictionaries into a new dictionary, with values from the second dictionary overriding duplicate keys.

Hash TablesArraysStringsFactset
Exception Handling in CodeEasy

Tests your approach to robustness, error propagation, and maintainable failure handling.

RecursionStackFactset

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 25 questions plus 1 hands-on drill to finish this plan.