Top 24
Prep plan
Updated weekly · Last refresh Oct 17

Catalist Data Engineer Interview Questions

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

24questions
~4htotal 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. 5 questions + 1 drill · ~63 min
Professor-Course Cross-Department QueryEasy
Practice

Use joins, inequality filtering, and DISTINCT to find professors teaching courses outside their departments.

JoinssqlCatalist
Second Highest Trader SalaryEasy
Practice

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingCatalist
Employee Counting SQLEasy

Evaluates SQL fundamentals for aggregation and correct counting logic.

sqlCatalist
SQL Joins and Conditional AggregationsHard
Practice
Practice drill

Use multiple joins and conditional aggregation to summarize completed, positive, and total outreach activity by Catalist campaign.

Joinssql queryAggregationsCatalistJ.P. Morgan
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~42 min
Merge Two Sorted ArraysEasy
Practice

Merge two sorted arrays into one sorted array using a two-pointer linear scan.

ArraysSortingTwo PointersCatalist
Explain Time ComplexityEasy
Practice

Implement a linear array-sum solution and explain why its time complexity is O(n).

CodingMathArraysCatalist
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
Pipelines8 questions · ~84 min
Design Real-Time Operations Dashboard PipelineHard

Design a pipeline for a real-time operational dashboard, covering streaming ingestion, modeling, data quality, and dashboard serving.

InfrastructureStream ProcessingQualityCatalist
Data Modeling Tools and ArchitectureEasy

Preferred tools and patterns for data modeling and pipeline architecture in a modern data platform.

InfrastructureToolsData ModelingCatalist
Explain ETL in Data EngineeringEasy

Explain the ETL process, why it matters, and how it fits into a practical data pipeline.

ETLOrchestrationQualityCatalist
More Pipelines questions with a free account
4
Behavioral & Leadership7 questions · ~74 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 24 questions plus 1 hands-on drill to finish this plan.