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 weekly.
Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.
State StreetTests your operational resilience practices for keeping State Street pipelines running despite upstream failures.
State StreetTests your ability to architect scalable ingestion pipelines using AWS services for State Street data flows.
State StreetExplain star and snowflake schemas, their tradeoffs, and when to use each in Meta-scale analytics systems.
State StreetTests your understanding of dimensional modeling and change tracking strategies for analytics at State Street.
State StreetTests your ability to tune Redshift SQL performance for large, join-heavy datasets at State Street.
State StreetFilter Wolfspeed Epi production lots by release status and return them in lot-number order.
WolfspeedState StreetFind the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.
eClinicalWorks
Informatica
Spectraforce TechnologiesAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your ability to implement efficient Python-based ETL from S3 to columnar storage for analytics at State Street.
State StreetAssesses practical Python and pandas skills for transforming and analyzing tabular data.
State Street