Catalyst Labs Data Engineer Interview Questions
The questions to prepare for a Catalyst Labs Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Design a pipeline for a real-time operational dashboard, covering streaming ingestion, modeling, data quality, and dashboard serving.
Catalyst LabsApproach for maintaining data quality and integrity across ETL pipelines.
Catalyst LabsStructured approach to diagnose failures in an ETL integration, from source extraction through orchestration, data quality, and idempotent recovery.
Catalyst LabsTests system design for throughput, parallelism, and reliability in large-scale data processing.
Catalyst LabsExplain how structured and unstructured data differ in format, storage, and how easily they can be queried with SQL.
Catalyst LabsTests ability to diagnose bottlenecks and apply indexing, query rewriting, and execution-plan driven tuning.
Catalyst LabsTests understanding of data modeling best practices for reliable, maintainable systems.
Catalyst LabsUse PostgreSQL window functions to rank Devoteam cohort users and calculate cumulative revenue within each signup cohort.
DevoteamCatalyst LabsFind the second highest salary in each department without using aggregate functions.
Credit GenieDevoteam
Cisco Restaurant + BarUse a self-join to find all direct employees reporting to one Health Catalyst manager.
Health Catalyst
CatalistCatalyst LabsSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests prioritization under pressure across multiple projects, including trade-off judgment, stakeholder communication, and ownership of outcomes.
Catalyst Labs