Top 24
Prep plan
Updated weekly · Last refresh Aug 30

Mediterranean Shipping Data Analyst Interview Questions

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

24questions
~3htotal time
Track your progressSign up free to work through all 24 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 14 questions + 3 drills · ~142 min
Difference Between WHERE and HAVING ClausesEasy

Explain the differences between WHERE and HAVING clauses in SQL and when to use each.

JoinsData WranglingAggregationsMediterranean Shipping
Summarize Shipment Data with AggregatesEasy

Tests core SQL aggregation for operational reporting and metrics creation.

Group ByHavingAggregationsMediterranean Shipping
NULLs, Casting, and CASE VariablesMedium

Tests robust SQL data preparation and feature engineering using CASE and type handling.

Data WranglingCTEsCase WhenMediterranean Shipping
Fundamental SQL ConceptsEasy

Tests baseline SQL knowledge for querying and manipulating relational data.

JoinsGroup ByAggregationsMediterranean Shipping
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

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

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
More SQL & Data Manipulation questions with a free account
2
Pipelines8 questions · ~64 min
ETL for Regular Shipment UpdatesHard

Tests ETL design skills for incremental refreshes in logistics analytics pipelines.

SchedulingETLDependenciesMediterranean Shipping
Manage Pipeline DependenciesMedium

Tests pipeline orchestration and dependency management across multiple data feeds.

SchedulingOrchestrationDependenciesMediterranean Shipping
Ensure Data Quality in Dynamic LogisticsHard

Tests data validation, monitoring, and quality controls for high-velocity shipping data.

IdempotencyData ModelingQualityMediterranean Shipping
More Pipelines questions with a free account

Sign up to see every question

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

Get my prep plan
3
More topics2 questions · ~16 min
Experience in Free TimeEasy

Assesses personal interests and communication during behavioral interviews.

experienceMediterranean Shipping
More questions with a free account
The finish line: interview-readyComplete all 24 questions plus 3 hands-on drills to finish this plan.