Factset Data Engineer Interview Questions
The questions to prepare for a Factset Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Find the second highest salary in each department without using aggregate functions.
FactsetExplain the differences between WHERE and HAVING clauses in SQL and when to use each.
FactsetExplain how GROUP BY forms aggregates and HAVING filters aggregated results in a reporting scenario.
FactsetCompute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.
Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIExplain the ETL process, why it matters, and how it fits into a practical data pipeline.
FactsetDesign a streaming pipeline that keeps dashboard data fresh and accurate for operational reporting.
FactsetApproach for rerunning failed pipeline ranges and correcting data safely with idempotent writes and quality checks.
FactsetMerge two Macy's catalog dictionaries into a new dictionary, with values from the second dictionary overriding duplicate keys.
FactsetTests your approach to robustness, error propagation, and maintainable failure handling.
FactsetSign up to see every question
Create a free account to unlock this list and practice real interview questions.