practice a little every day, paws crossed ♡

Data Engineer Interview Questions

Practice 9403 coding, system design and machine learning questions from 546 companies, sorted by role, topic and interview round. Every question has step-by-step hints, a code runner that supports 8 languages and an AI mentor; members also get the full solution walkthrough.

9403
Questions: 546
Companies: 11
Topics: 8
Languages

Showing 1–15 of 15 results

Akuna CapitalMediumData Engineer
Write February Resource Usage Query
This question tests the ability to join multiple tables, handle date filtering with range conditions, and perform grouped aggregations to calculate average metrics across different resource categories.
Software Engineering FundamentalsOnline AssessmentSQLAggregationJoins
BloombergMediumData Engineer
Implement RotatingFileSink in hierarchy
This question evaluates a candidate's proficiency in Python object-oriented design, file I/O and JSON serialization, concurrency control via locking, context manager protocols, custom exception handling, and adherence to Liskov substitution when implementing a rotating file sink.
Software Engineering FundamentalsTechnical Screen
ByteDanceMediumData Engineer
Choose Components for a Data Warehouse
This question tests the ability to distinguish between distributed data processing frameworks, storage engines, and relational databases, evaluating your understanding of trade-offs in large-scale data infrastructure.
Software Engineering FundamentalsHR ScreenData EngineeringDistributed SystemsData Warehousing
DisneyEasyData Engineer
Prompting an LLM to Migrate a Java Codebase to Python and Clean a Large Database
Explain how you would prompt a large language model to migrate a Java codebase to Python and to help clean a database with tens of thousands of rows. It tests prompt design, verification of generated code and data fixes, data quality measurement, security of AI-assisted work and the handling of sensitive data.
Software Engineering FundamentalsOnsite
Jain GlobalMediumData Engineer
Build a Self-Service Market Data Discovery and Support Layer
This problem tests your ability to design a robust metadata-driven orchestration layer that manages data lineage, access control, and quality monitoring for financial market datasets.
Software Engineering FundamentalsTechnical ScreenSystem DesignData EngineeringMetadata
NVIDIAMediumData Engineer
Data Pipeline Reliability, Backfills, and Spark Optimization
Prepare for a NVIDIA software engineering interview question about data pipeline reliability, backfills, and spark optimization. The prompt highlights practical reasoning, edge cases, trade-offs, and validation criteria without revealing the model answer.
Software Engineering FundamentalsTechnical Screen
NetflixHardData Engineer
Explain concurrency and reliability tradeoffs
This problem tests your understanding of balancing thread-safe resource management in a high-concurrency local environment against the systemic requirements of a distributed data pipeline.
Software Engineering FundamentalsOnsiteConcurrencyDistributed SystemsCaching
PinterestMediumData Engineer
Settle Shared-Expense Debts, Then Reduce the Number of Payments
A coding question about settling shared expenses: turn a list of debts between people into payments that leave everyone even, first with no limit on the number of payments and then with as few payments as possible. It tests net-balance reasoning, matching payers with receivers, heap usage, and judging whether a greedy settlement is truly minimal.
Software Engineering FundamentalsTechnical Screen
PinterestMediumData Engineer
Settle a Group Tab With the Fewest Possible Payments
Turn a list of recorded debts between friends into a list of payments that settles every balance, first with any valid list and then with the fewest payments possible, using net-balance accounting and a backtracking search over who pays whom.
Software Engineering FundamentalsTechnical Screengraphsbacktrackinggreedy
Point72HardData Engineer
Explain Spark Execution and Optimization
This question evaluates a candidate's understanding of the Apache Spark execution model, lazy evaluation, distributed processing (including jobs, stages, tasks, and shuffles), and performance-tuning considerations for batch and streaming pipelines on columnar data lakes.
Software Engineering FundamentalsTechnical Screen
RobinhoodHardData Engineer
Write SQL to analyze CA residency history
This question evaluates a candidate's ability to write SQL for temporal state reconstruction, including correct joins on composite keys, interpreting edit/audit logs, and reasoning about inclusive/exclusive timestamps.
Software Engineering FundamentalsTechnical Screen
ShopifyMediumData Engineer
Use AI Responsibly During SQL Pair Programming
Practice an AI-enabled SQL pair-programming workflow that keeps your reasoning visible. Cover requirement clarification, safe tool boundaries, incremental query design, independent edge-case testing, collaboration, and accountable debugging.
Software Engineering FundamentalsTechnical Screen
TeslaMediumData Engineer
Build a Transaction CSV Cleaning Pipeline
This problem tests your ability to design a robust, deterministic data cleaning pipeline that handles input parsing, data validation, and precision-safe numeric handling.
Software Engineering FundamentalsTechnical ScreenETLData EngineeringValidation
ZooxMediumData Engineer
Design Transaction Data Quality Checks
This question evaluates the ability to design and implement data quality checks for relational transaction and vendor datasets, focusing on integrity constraints, referential integrity, business-rule validation (refund logic), missing/invalid values, and anomaly detection.
Software Engineering FundamentalsTechnical Screen
ZooxMediumData Engineer
Explain seasons and compound interest
This question evaluates quantitative reasoning and basic scientific literacy by testing understanding of Earth's axial tilt and seasonal temperature variation alongside exponential growth and compound interest calculations.
Software Engineering FundamentalsOnsite