Dataford
Top 50
Company roadmap
Updated weekly · Last refresh Aug 30

Current (NY) Interview Questions

The questions to prepare for Current (NY) interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

50questions
~9htotal 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. 9 questions + 1 drill · ~106 min
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)
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
More SQL & Data Manipulation questions with a free account
2
Coding9 questions · ~96 min
Maximum Depth of Binary TreeEasy
Practice

Problem Given the root of a binary tree, return its maximum depth as an integer. The maximum depth is the number of nodes along the longest path from the ...

RecursionQueueTreesCurrent (NY)
More Coding 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
Pipelines10 questions · ~106 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityCurrent (NY)
More Pipelines questions with a free account
4
Execution9 questions · ~96 min
Quality Under Tight DeadlineMedium

Explain how you protect quality on a fixed-deadline engineering project by managing scope, risks, and release criteria.

Launch PlanningTrade-offsScope ManagementCurrent (NY)
More Execution questions with a free account
5
Metrics3 questions · ~32 min
Calculate Mobile Banking LTVMedium

Tests proficiency in LTV modeling, assumptions, and interpretation for fintech decisions.

KPILTVCohort AnalysisCurrent (NY)
More Metrics questions with a free account
6
System Design4 questions · ~43 min
Real-Time Transaction Management SystemHard

Evaluates your system design for real-time transaction handling and consistency.

real-time systemsCurrent (NY)
More System Design questions with a free account
7
More topics6 questions · ~64 min
Design A/B Test for NotificationsHard

Tests experimental design, metric selection, and guardrails for fintech growth experiments.

experiment designGuardrail Metricsprimary metricsCurrent (NY)
Building Credit Risk ModelsHard

Evaluates your approach to building and validating credit risk models for lending decisions.

risk modelingCurrent (NY)
More questions with a free account
The finish line: interview-readyComplete all 50 questions plus 1 hands-on drill to finish this plan.