TIAA Data Engineer Interview Questions
The questions to prepare for a TIAA Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Use DENSE_RANK and joins to find the second-highest distinct salary in each TIAA department.
TIAAEvaluates your understanding of partitioning strategies and their implications for ETL correctness and scalability.
TIAATests your knowledge of Hive data movement semantics and how they affect performance and outcomes.
TIAAOptimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Capgemini
NomuraFind non-null salary amounts that occur more than once, including their occurrence counts.
TIAAOptimize a PySpark join when one DataFrame is much smaller, focusing on join strategy, shuffle reduction, and practical Spark tuning.
TIAADiscuss how to deploy AI data pipelines on AWS, including orchestration, data quality, and security controls.
TIAAOptimize a Spark join where skewed keys create long-running tasks during a transaction to merchant metadata enrichment step.
TIAASign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your ability to write performant Spark code with good transformations, partitioning, and resource use.
TIAATests your ability to automate data workflows using scripting for reliability and efficiency.
TIAA