Data Engineer Interview Questions

Showing 1–10 of 10 results

• BloombergMedium·Data 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
• JGJain GlobalMedium·Data 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
• NVIDIAMedium·Data 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
• PinterestMedium·Data 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
• PinterestMedium·Data 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
• Point72Hard·Data 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
• RobinhoodHard·Data 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
• ShopifyMedium·Data 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
• TeslaMedium·Data 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
• ZooxMedium·Data 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