Dataford
Top 16
Prep plan
Updated weekly · Last refresh Aug 30

Celestica Supply Chain Analyst Interview Questions

The questions to prepare for a Celestica Supply Chain Analyst interview. Questions from real interview reports rank first. Updated weekly.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
Behavioral & LeadershipStart here. 12 questions · ~96 min
From Transactions to Executive ReportMedium

Tests your ability to transform operational data into clear insights for leadership decision-making.

Stakeholder ManagementCommunicationreportingCelestica
Prioritizing Shortages Across LinesHard

Tests your prioritization framework for competing demands and your ability to optimize outcomes under constraints.

PrioritizationCelestica
Quick Decisions with Incomplete DataMedium

Tests your judgment under uncertainty and how you balance speed, risk, and data quality.

Decision Makingsupply chainCelestica
Navigating SAP Inventory ModulesEasy

Tests your hands-on ERP knowledge and comfort working with inventory-related data structures.

saperp systemsCelestica
More Behavioral & Leadership questions with a free account
2
More topics4 questions · ~32 min
Inventory Health MetricsEasy

Tests your understanding of inventory performance measures and how you use them to drive decisions.

kpi hierarchyCelestica
Cleaning Supplier FilesEasy

Tests your data preparation skills to ensure reliable inputs for planning and reporting.

data cleaningData WranglingCelestica
Safety Stock CalculationMedium

Tests your ability to set and tune inventory buffers using demand and supply variability assumptions.

safety stockCelestica
Reconciling Conflicting Inventory SheetsMedium

Tests your ability to reconcile data discrepancies using common tools and structured analysis.

pivot tablesReconciliationExcelCelestica

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Second-Highest Transaction Amount QueryMedium
Practice
Practice drill

Find the second-highest distinct transaction amount using a subquery in PostgreSQL without LIMIT.

SubqueriesRankingsalaryCapgemini FSSBUFreechargeNPCI
Normalize Customer Addresses by RegionHard
Practice
Practice drill

Standardize inconsistent addresses using joins, CTEs, and CASE logic to map each record to a normalized region.

data cleaningData WranglingExcelTelus Digital
Clean Null Campaign MetricsEasy
Practice
Practice drill

Use CASE and COALESCE to standardize missing StackAdapt campaign metrics and count incomplete rows by campaign.

null handlingData WranglingReconciliationStackadaptCvent
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.