Michael Page Data Engineer Interview Questions
The questions to prepare for a Michael Page Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Explain the differences between WHERE and HAVING clauses in SQL and when to use each.
Michael PageExplain how INNER JOIN and LEFT JOIN differ, and when to use each for matched-only versus all-left-row analysis.
Michael PageTests SQL query structuring for time-based aggregation and metric rollups.
Michael PageRewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.
Continental Finance
Capgemini
DISHAnswer two SQL data-manipulation questions and one Python question using the supplied users, posts, and comments data.
RedditSummarize SQL concepts by interview round, including rounds without SQL topics and average planned depth.
EXL ServiceFilter strings by length, prefix, and required character using a Python list comprehension.
Michael PageTests Python performance and memory optimization techniques for large in-memory data structures.
Michael PageAssesses your ability to apply best practices in Python and SQL within a data stack.
Michael PageTests understanding of Python data structures and practical tradeoffs.
Michael PageSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests practical approach to text cleaning and data quality improvements for downstream analytics.
Michael Page