nference Data Engineer Interview Questions
The questions to prepare for a nference Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Use a hash map to find two array elements that sum to a target in O(n) time.
nferenceFind the first non-repeating character in a string using frequency counting and a second pass in O(n) time.
nferenceExplain how the two pointers technique works on arrays and strings, when to use it, and its common patterns.
nferenceExplain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.
nferenceExplain OLTP vs OLAP designs, including schema shape, workload patterns, and when each is appropriate in a data platform.
nferenceAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreRank 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.
Replit
QuantcastSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Design the core pipeline infrastructure for a new project, with attention to orchestration, data quality, idempotency, and future scale.
nferenceApproach for detecting and mitigating skew in PySpark pipelines using partitioning, join strategies, and runtime monitoring.
nferenceApproach for maintaining data quality and integrity across ETL pipelines.
nference