State Street Data Engineer Interview Questions
The questions to prepare for a State Street Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Explain star and snowflake schemas, their tradeoffs, and when to use each in Meta-scale analytics systems.
State StreetTests your ability to tune Redshift SQL performance for large, join-heavy datasets at State Street.
State StreetRewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.
Continental Finance
Capgemini
DISHExtract qualifying market observations by venue and price, then return them in chronological order.
Equifax
DPR Construction
RigUpFilter Wolfspeed Epi production lots by release status and return them in lot-number order.
WolfspeedState StreetApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
State StreetEvaluates your approach to selecting and applying data warehouse technologies for analytics workloads.
State StreetSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your practical tool selection for building reliable data pipelines and transformations.
State StreetTests your ability to make ETL failures observable and recoverable in production environments.
State StreetAssesses practical Python and pandas skills for transforming and analyzing tabular data.
State StreetTests your ability to implement efficient Python-based ETL from S3 to columnar storage for analytics at State Street.
State Street