Top 21
Prep plan
Updated weekly · Last refresh Aug 30

McKesson Data Analyst Interview Questions

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

21questions
~3htotal time
Track your progressSign up free to work through all 21 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 3 drills · ~70 min
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberMcKesson
Handling Missing Values in SQLEasy

Explain how to detect and handle NULL values in SQL using filtering, COALESCE, CASE, and business-aware imputation.

Data WranglingETLCase WhenMcKesson
LEFT vs INNER JOIN ReportingEasy

Explain how LEFT JOIN vs INNER JOIN changes report completeness, NULL handling, and KPI interpretation in Meta-style reporting.

JoinsData WranglingCase WhenMcKesson
Optimize Slow Shipment Aggregation QueryHard

Tests advanced SQL performance tuning for large shipment datasets in McKesson's supply chain.

performancequery optimizationAggregationsMcKesson
Second Highest Without AggregatesMedium
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsMicron Memory Malaysia Sdn BhdInformaticaExusia
Autonomous vs Manual Drive TimeMedium
Practice
Practice drill

Compute per-vehicle daily autonomous vs manual seconds from state-change logs using LEAD and conditional aggregation.

JoinsData WranglingGroup By
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingBenjamin MooreCommonwealth Bank of AustraliaAbercrombie and Fitch
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership13 questions · ~104 min
Deadline Pressure With Incomplete DataMedium

Tests prioritization under pressure, judgment with incomplete data, and ownership in delivering a decision despite ambiguity.

time managementDealing With AmbiguityPrioritizationMcKesson
More Behavioral & Leadership questions with a free account
3
More topics3 questions · ~24 min
Diagnose a Metric Drop After LaunchMedium

Investigate why a key KPI moved the wrong way after a product change and separate signal from noise.

Lagging IndicatorsLeading IndicatorsDiagnosisMcKesson
Defining and Building Delivery Delay DashboardMedium

Tests requirements gathering, metric definition, and stakeholder alignment for McKesson reporting.

User NeedsrequirementsMcKesson
Distribution Network Efficiency KPIsEasy

Tests KPI selection and operational analytics judgment for McKesson's healthcare supply chain.

KPIefficiencysupply chainMcKesson

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 21 questions plus 3 hands-on drills to finish this plan.