Celestica Data Engineer Interview Questions
The questions to prepare for a Celestica Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.
CelesticaExplain normalization, why it improves data integrity, and when denormalization is a practical performance tradeoff.
CelesticaExplain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
CelesticaTests relational modeling for inventory tracking, keys, constraints, and queryability across locations.
CelesticaTests understanding of indexing strategies, performance impacts, and maintenance costs.
CelesticaCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIMerge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.
ArtefactTests project ownership, prioritization, and communication by asking you to explain resume work with clear scope, decisions, and impact.
CelesticaTests pipeline design for ingestion, transformation, and reliable loading into relational systems.
CelesticaAssesses your data modeling skills and ability to design a usable schema for real-world data.
CelesticaSign up to see every question
Create a free account to unlock this list and practice real interview questions.