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

Celestica Business Analyst Interview Questions

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

17questions
~2htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 3 questions + 3 drills · ~54 min
Validating Data Integrity Across ERPsMedium

Tests your data validation, reconciliation, and reporting accuracy practices across systems.

Reconciliationdata integrityerp systemsCelestica
Excel and Word Technical TestMedium

Evaluates practical proficiency with Excel-based analysis and structured documentation.

technical skillsExcelCelestica
Excel Proficiency for AnalysisMedium

Assesses hands-on Excel capability for analysis, reporting, and decision support.

ExcelskillsCelestica
Second-Highest Transaction Amount QueryMedium
Practice
Practice drill

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

SubqueriesRankingsalaryCapgemini FSSBUFreechargeNPCI
Deduplicate Shipment Events for Lead TimeMedium
Practice
Practice drill

Use CTEs and ROW_NUMBER to remove duplicate shipment events, fill missing created times, and compute shipment lead time in days.

null handlingReconciliationdata integrityAnduril
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
2
Behavioral & Leadership11 questions · ~88 min
Working Through Team ConflictMedium

Assesses conflict resolution, communication, and ownership when collaborating with a difficult teammate under delivery pressure.

Conflict ResolutionteamworkcollaborationCelestica
Taking Initiative on a Financial GapEasy

Tests initiative and ownership by asking for a concrete example of proactively solving a problem with measurable business impact.

Influence Without AuthorityLeadershipOwnershipCelestica
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Why Celestica and EMS DifferentiationMedium

Tests your motivation and your ability to articulate Celestica's differentiation in electronics manufacturing.

Business ModelCompetitive AnalysismotivationCelestica
Prioritizing Analysis Under Time PressureHard

Tests your triage, analytical prioritization, and ability to produce actionable insights quickly.

Data AnalysisExecutionPrioritizationCelestica
Applying Supply Chain Trends DailyMedium

Tests how you connect market and supply chain signals to practical business analysis work at Celestica.

Market TrendsBusiness Acumensupply chainCelestica

Sign up to see every question

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

Get my prep plan
The finish line: interview-readyComplete all 17 questions plus 3 hands-on drills to finish this plan.