Top 26
Prep plan
Updated weekly · Last refresh Aug 30

Catalist Data Engineer Interview Questions

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

26questions
~4htotal time
Track your progressSign up free to work through all 26 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 4 questions · ~39 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

Tests ability to analyze algorithm efficiency and communicate tradeoffs.

MathArraysCatalist
Coding Logic QuestionsEasy

Tests foundational coding ability and correctness under straightforward constraints.

Hash TablesArraysStringsCatalist
More Coding questions with a free account
2
SQL & Data Manipulation7 questions + 1 drill · ~78 min
Second Highest Trader SalaryEasy
Practice

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

SubqueriesRankingSortingCatalist
Professor-Course Cross-Department QueryEasy
Practice

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

JoinssqlCatalist
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 queryAggregationsCatalist
More SQL & Data Manipulation 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 · ~78 min
Cleaning Missing Values in PipelinesEasy

Approach for handling missing values in a pipeline with data quality checks and repeatable transformations.

Data WranglingETLQualityCatalist
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
More Pipelines questions with a free account
4
Behavioral & Leadership7 questions · ~68 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 26 questions plus 1 hands-on drill to finish this plan.