Data Manipulation (SQL/Python) Interview Questions

Showing 121–150 of 446 results

• DRWMedium·Machine Learning Engineer
  Process CSV for portfolio returns and metrics

  This question evaluates a candidate's competency in time-series data manipulation, financial return computation, portfolio analytics, numerical stability, modular software design (clear function boundaries and unit tests), and algorithmic complexity analysis within the Data Manipulation (SQL/Python) domain.

  Data Manipulation (SQL/Python)Online Assessment
• DatabricksHard·Data Scientist
  Find Top-5 Similar Rows

  This question tests the ability to implement a pairwise similarity comparison between rows using a custom distance metric while handling missing data and ranking results.

  Data Manipulation (SQL/Python)Technical ScreenPandasSimilarityData Manipulation
• DatabricksEasy·Data Scientist
  Find top-5 most similar rows across datasets

  This question evaluates understanding and implementation of similarity/distance metrics (e.g., MSE), data preprocessing issues such as handling NULLs and feature scaling, and the ability to perform efficient cross-dataset comparisons and top-k ranking.

  Data Manipulation (SQL/Python)Technical Screen
• DDaveEasy·Machine Learning Engineer
  Parse JSON Accounts into Typed Python Objects and Prepare Features

  This problem tests your ability to sanitize and transform raw JSON account data into a structured format while enforcing strict numerical integrity and data consistency.

  Data Manipulation (SQL/Python)OnsitePythonData CleaningJSON
• DisneyMedium·Data Scientist
  Write complex SQL for streaming funnels

  This question evaluates a candidate's ability to write complex ANSI-SQL for event-level funnel analysis, including temporal windowing, user attribution, multi-stage aggregation, and handling of event schemas.

  Data Manipulation (SQL/Python)HR Screen
• DoorDashMedium·Data Scientist
  Analyze Driver Requests for Food Delivery Orders

  This question evaluates data manipulation and analytical SQL skills in the Data Manipulation (SQL/Python) domain, focusing on window functions for ranking and temporal comparison, joins, and aggregation when analyzing orders and driver requests.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashMedium·Data Scientist
  Calculate Late Delivery Percentage and Top Customers

  This question evaluates data manipulation and aggregation skills for a Data Scientist role, focusing on date handling, computing the percentage of late orders, and ranking customers using SQL or Python.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashEasy·Data Scientist
  Calculate Monthly Restaurant Sales Growth

  This problem tests the ability to aggregate transactional data by month and use window functions to calculate percentage growth between consecutive periods while handling null values.

  Data Manipulation (SQL/Python)Technical ScreenSQLWindow FunctionsAggregation
• DoorDashHard·Data Scientist
  Calculate Order Request Metrics

  This question evaluates SQL and data-manipulation competencies for computing order-level metrics, including aggregations, joins, windowed event sequencing, timestamp/timezone handling, and NULL-aware comparisons.

  Data Manipulation (SQL/Python)Onsite
• DoorDashMedium·Software Engineer
  Compute courier pay with peak-hour rules

  This question evaluates a candidate's data manipulation skills and competency in implementing business rules, including robust error handling, aggregation for per-day totals, minimum-pay enforcement, and time-window (peak-hour) pay adjustments.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashMedium·Software Engineer
  Compute dasher pay from deliveries

  This question evaluates competency in data manipulation, schema design and validation, time-based aggregation, pay-computation logic, and handling of edge cases using SQL or Python.

  Data Manipulation (SQL/Python)Onsite
• DoorDashMedium·Software Engineer
  Compute dasher payout from API data

  This question evaluates a candidate's proficiency in data manipulation and transaction aggregation using SQL or Python, encompassing time-zone-aware timestamp handling, pagination, late or missing events, cancellations and negative adjustments, rounding rules, and itemized breakdowns.

  Data Manipulation (SQL/Python)Onsite
• DoorDashMedium·Data Scientist
  Compute rolling cold-delivery rates with windows

  This question evaluates proficiency with SQL window functions, time-based joins, event deduplication and business-rule implementation for computing rolling metrics over temporal windows.

  Data Manipulation (SQL/Python)Onsite
• DoorDashEasy·Data Scientist
  Find Monthly Top Customers Excluding High-Frequency Users

  This problem tests proficiency in window functions, filtering based on aggregated metrics, and handling ranking logic in SQL.

  Data Manipulation (SQL/Python)Technical ScreenSQLWindow FunctionsData Aggregation
• DoorDashMedium·Data Scientist
  Generate Weekly Revenue and Engagement Summary with Pandas

  This question evaluates proficiency in data manipulation and analytics with Pandas and SQL, covering aggregations, distinct purchase counts, lambda-based user-tier classification, and platform-level conversion-rate computation.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashMedium·Data Scientist
  Model schema and query new-market readiness

  This question evaluates SQL-based data manipulation skills including time-series aggregation, cohort analysis, percentile/median calculations, joins between event and reference tables, and deriving operational KPIs for new-market readiness; it targets the Data Manipulation (SQL/Python) domain for a Data Scientist role.

  Data Manipulation (SQL/Python)Onsite
• DoorDashMedium·Data Scientist
  Solve multi-part SQL with sliding windows

  This question evaluates a candidate's practical SQL data-manipulation skills, including time-based rolling aggregates, distinct counts and deduplication, multi-table joins, revenue aggregation and ranking, and session/streak computations within the Data Manipulation (SQL/Python) domain.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashMedium·Data Scientist
  Write SQL for deliveries analytics

  This question evaluates SQL data manipulation and analytics skills—specifically aggregation, conditional counting, time-window filtering, joins, and handling of nulls and zero-count periods.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashMedium·Data Scientist
  Write SQL for percent and window changes

  This question evaluates proficiency with advanced SQL techniques—specifically the use of CTEs and multiple window functions, row-level versus aggregated conditionals, time-windowed aggregations, generation of unit-day series including zero-order days, and correct handling of missing exposure labels for percent and change calculations.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashMedium·Data Scientist
  Write SQL to backtest refund policy

  This question evaluates advanced SQL data-manipulation and analytics competency, including time-based lateness calculations, window functions (PERCENT_RANK and rolling/partitioned windows), CTEs and joins, aggregation, and monetary-field handling for a policy-simulation scenario.

  Data Manipulation (SQL/Python)Technical Screen
• DoorDashMedium·Data Scientist
  Write complex SQL on DoorDash data

  This question evaluates proficiency in complex SQL querying and data manipulation, including joins across tables, time-based filtering, window functions, null and edge-case handling, aggregations, and integrating promotion and order-event data.

  Data Manipulation (SQL/Python)Onsite
• EYMedium·Data Scientist
  Architect cloud data ingestion patterns

  This question evaluates a candidate's ability to design end-to-end cloud data ingestion and serving architectures, including streaming and batch patterns, CDC/event sourcing/micro-batch trade-offs, partitioning and compaction strategies, idempotency, schema evolution, PII tokenization, cost controls, and incident simulation for chaos testing.

  Data Manipulation (SQL/Python)Technical Screen
• EYMedium·Data Scientist
  Design logical model and consumption

  This question evaluates understanding of logical data modeling, ERD-level design with keys and cardinalities, slowly changing dimensions, normalization versus denormalization trade-offs, and strategies for exposing curated datasets and read paths for analytics and regulatory consumers, indicating competency in data modeling and data delivery.

  Data Manipulation (SQL/Python)Technical Screen
• EYMedium·Data Scientist
  Map sources to functional dataset with SQL

  This question evaluates competency in SQL-based data manipulation and data engineering concepts, including handling late-arriving data and deduplication to the latest ingested record, joining and filtering for enrichment and KYC status, and computing exposure metrics such as gross/net notional, limit utilization, and breach flags.

  Data Manipulation (SQL/Python)Technical Screen
• ExpediaMedium·Data Scientist
  Audit and onboard unfamiliar datasets safely

  This question evaluates a data scientist's competency in dataset discovery, schema and key verification, profiling for distributions/missingness/timezones/currencies, duplicate and join-inflation detection, event-sequence validation, accurate metric computation, and the design of data-quality tests/data contracts within SQL/Python workflows.

  Data Manipulation (SQL/Python)Onsite
• ExperianMedium·Data Scientist
  Compare Spark RDDs, DataFrames, and SQL Performance Gains

  This question evaluates understanding of Spark abstractions (RDDs, DataFrames, Spark SQL), lazy evaluation, memory management, query optimization, and developer ergonomics within the Data Manipulation (SQL/Python) domain of distributed data processing.

  Data Manipulation (SQL/Python)Technical Screen
• ExperianMedium·Data Scientist
  Compare Spark RDDs, DataFrames, and Spark SQL Benefits

  This question evaluates understanding of Apache Spark core abstractions (RDDs, DataFrames, Spark SQL), execution model concepts such as lazy evaluation and optimizer-driven execution, and operational competency with managed cloud cluster job submission and monitoring, categorized under Data Manipulation (SQL/Python) for a Data Scientist role.

  Data Manipulation (SQL/Python)Technical Screen
• FMFannie MaeMedium·Data Scientist
  Assess SQL joins, unions, windows, dedup, and pandas

  This question evaluates proficiency in SQL and pandas data-manipulation techniques, including aggregations with NULL semantics, various join types, set operations and deduplication, window functions, and reconciling normalized and denormalized sources.

  Data Manipulation (SQL/Python)Technical Screen
• FMFannie MaeMedium·Data Scientist
  Understand SQL Aggregations and Joins: Key Differences Explained

  This question evaluates a candidate's competency in SQL aggregations (COUNT, SUM, AVG, MIN, MAX), join semantics (INNER, LEFT, RIGHT, FULL OUTER), set operations (UNION vs UNION ALL), window functions, view versus table trade-offs, duplicate detection and removal, query optimization techniques, and pandas DataFrame operations (merge, join, concat) within the Data Manipulation (SQL/Python) domain. It is commonly asked because it assesses both conceptual understanding (function purposes and join semantics) and practical application (writing efficient queries, deduplicating data, and translating patterns between SQL and pandas), thereby probing correctness and performance reasoning.

  Data Manipulation (SQL/Python)Onsite
• Fetch RewardsMedium·Data Scientist
  Write SQL to verify quarterly sales decline

  This question evaluates proficiency in SQL aggregation, time-series period-over-period comparison, same-store cohort analysis, correct grain handling, and treatment of returns, testing data manipulation and analytical SQL skills in the Data Manipulation (SQL/Python) domain.

  Data Manipulation (SQL/Python)Technical Screen