PNY Data Engineer Interview Questions
The questions to prepare for a PNY Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Explain the differences between WHERE and HAVING clauses in SQL and when to use each.
PNYAssesses your ability to write advanced SQL for real data problems.
PNYAssesses understanding of database triggers and appropriate use cases.
PNYRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Quantcast
ReplitCalculate the longest consecutive login streak for each user using window functions and date manipulations.
Chime
Salesforce
ECSA structured approach to debugging production data pipelines, with focus on orchestration, data quality, idempotency, and safe backfills.
PNYTests Spark performance tuning and your ability to implement a non-trivial PySpark query.
PNYEvaluates your engineering judgment and performance optimization skills.
PNYSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests your core Python coding ability relevant to data engineering tasks.
PNYTests your ability to explain object-oriented concepts and apply them to real code.
PNY