MentorPass Data Engineer Interview Questions
The questions to prepare for a MentorPass Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Approach for managing lineage, access control, and governed data usage in an AI pipeline with Unity Catalog.
Conceptual pipeline question on Delta Lake and how it differs from plain Parquet files in data engineering workflows.
Design a streaming pipeline that can absorb late-arriving events while keeping aggregates correct and downstream tables stable.
Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Tests your ability to model historical user state changes for analytics and reporting.
Tests your ability to design physical storage strategies for high-performance queries at massive scale.
Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPCompute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIUse joins and LAG to isolate departments driving a large month-over-month spending variance.
State of California
University of Chicago
The Church of Jesus Christ of Latter-day SaintsSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests performance tuning skills for PySpark joins under skew at scale.
Tests your ability to apply privacy, risk, and security controls to AI data pipelines at MentorPass.