Top 28
Prep plan
Updated weekly · Last refresh Oct 17

Safaricom Data Engineer Interview Questions

The questions to prepare for a Safaricom Data Engineer interview. Questions from real interview reports rank first. Updated daily.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 6 questions + 2 drills · ~71 min
Top 10 Customers SQLEasy
Practice

Use SUM, GROUP BY, ORDER BY, and LIMIT to find the top 10 Healthfirst Marketplace customers by purchase total.

RankingGroup ByAggregationsSafaricom
Normalization vs Denormalization TradeoffsMedium

Explain normalization, why it improves data integrity, and when denormalization is a practical performance tradeoff.

schema designperformanceData ModelingSafaricom
SQL Joins and OptimizationMedium

Tests ability to write correct SQL joins and optimize SQL for production workloads.

optimizationSafaricom
Top Customers by Sales RevenueEasy
Practice
Practice drill

Use GROUP BY and SUM to rank the top 10 customers by total revenue from a single sales table.

RankingGroup ByAggregationsHousecall ProEquifaxXYZ
MoM Growth for Active M-PESAMedium
Practice
Practice drill

Calculate monthly M-PESA active users and their month-over-month growth rate using PostgreSQL.

Window FunctionsDate FunctionsJoinsSafaricom
More SQL & Data Manipulation questions with a free account
2
Coding5 questions · ~43 min
Choosing Data Structures at ScaleEasy

Explain which data structures work best for large datasets based on access patterns, memory use, and update costs.

Hash TablesArraysHeapSafaricom
Big Data Algorithms and ConceptsMedium

Evaluates understanding of big data concepts and algorithmic approaches for large-scale processing.

AlgorithmsSafaricom
More Coding 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
Pipelines16 questions · ~137 min
API-Based Data Integration ExperienceEasy

Discuss how you use APIs in data pipelines, including ingestion patterns, validation, and operational monitoring.

ETLData ModelingSafaricom
Patient Data Quality and PrivacyMedium

Approach for protecting sensitive patient data while maintaining high data quality across an analytics pipeline.

ETLData ModelingQualitySafaricom
Handling a Production Pipeline FailureEasy

Describe a real production pipeline failure, how you diagnosed and fixed it, and what changes you made around orchestration, quality, and reruns.

InfrastructureIdempotencyQualitySafaricom
More Pipelines questions with a free account
4
More topics1 question · ~9 min
More questions with a free account
The finish line: interview-readyComplete all 28 questions plus 2 hands-on drills to finish this plan.