Top 50
Prep plan
Updated weekly · Last refresh Oct 17

Current (NY) Data Engineer Interview Questions

The questions to prepare for a Current (NY) Data Engineer interview. Questions from real interview reports rank first. Updated daily.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 15 questions · ~131 min
7-Day Rolling Average Balance QueryMedium
Practice

Calculate each Current user's seven-day rolling average balance while handling dates and missing balance values.

Window FunctionsDate Functionsnull handlingCurrent (NY)
First Failed Then Next Success QueryMedium
Practice

Find each user's first failed transaction and their earliest later successful transaction using ordered transaction analysis.

Window FunctionsLag/LeadDate FunctionsCurrent (NY)
7-Day Rolling Active UsersMedium
Practice

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsCurrent (NY)
More SQL & Data Manipulation questions with a free account
2
Pipelines34 questions · ~298 min
Single Source of Truth for FinanceMedium

Design a finance reporting pipeline that keeps one governed source of truth across ERP, planning, and BI layers.

ToolsData ModelingQualityCurrent (NY)
Build a Reporting Star SchemaHard

Build and maintain a reporting model for dashboards using dimensional design, ELT, data quality checks, and scheduled transformations.

ETLData ModelingQualityCurrent (NY)
Backfill Without Duplicate RecordsHard

Approach for rerunning failed pipeline ranges and correcting data safely with idempotent writes and quality checks.

IdempotencyBackfillingQualityCurrent (NY)
Fraud Detection Batch vs StreamingMedium

Design a fraud pipeline that compares batch, streaming, and hybrid architectures for 120K tx/sec with sub-300 ms decisions and reconciled hourly tables.

Stream ProcessingETLBatch ProcessingCurrent (NY)
More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
More topics1 question · ~9 min
Clean Maintainable Python ETL ScriptsEasy

Tests software engineering practices for reliable data extraction and automation.

Hash TablesArraysSortingCurrent (NY)
The finish line: interview-readyComplete all 50 questions to finish this plan.