Data Manipulation (SQL/Python) Interview Questions

Showing 361–390 of 446 results

• SScribdMedium·Software Engineer
  Many-to-Many Schema Design With a Join Table, Composite Primary Key, and Queries

  Design a relational schema modeling a many-to-many relationship between documents and tags using a join table with a composite primary key, index both lookup directions, and write queries handling outer joins and relational division.

  Data Manipulation (SQL/Python)OnsiteSQLDatabase DesignPostgreSQL
• SScribdMedium·Software Engineer
  Most Popular Actors Query When Object IDs Mix Movies and People With Multiple Roles

  A data query question about ranking the most popular actors when an object ID can refer to either a movie or a person, and one person can hold several roles in the same movie. It tests clarifying the popularity metric, filtering to actor credits, deduplicating person and movie pairs, checking object types, and defining a tie policy.

  Data Manipulation (SQL/Python)Onsite
• ShopifyMedium·Data Scientist
  Analyze Pirate Theme Usage Growth Over Time

  This question evaluates a candidate's ability to perform SQL-based data manipulation and time-series analysis, emphasizing joins, aggregation, time-bucketing, and definition of growth metrics to measure feature adoption.

  Data Manipulation (SQL/Python)Technical Screen
• ShopifyMedium·Data Scientist
  Analyze Pirated Theme Usage

  Calculate monthly metrics on unlicensed theme usage and lost revenue by evaluating temporal interval overlaps between installation lifespans and calendar months.

  Data Manipulation (SQL/Python)Technical ScreenSQLPandasInterval Overlap
• ShopifyMedium·Data Scientist
  Analyze Pirated Theme Usage Impact

  This question evaluates a candidate's ability to perform data manipulation and analytics with SQL and Python to detect license compliance, construct month-level time windows, and quantify revenue impact from pirated theme usage.

  Data Manipulation (SQL/Python)Technical Screen
• ShopifyMedium·Data Scientist
  Calculate Week-over-Week Revenue Change Using SQL

  This question evaluates proficiency in SQL time-series aggregation, weekly grouping, and prior-period comparison for calculating percentage changes in revenue.

  Data Manipulation (SQL/Python)Technical Screen
• ShopifyMedium·Data Scientist
  Determine Growth of Pirated Theme Installations Over Years

  This question evaluates proficiency in SQL-based data manipulation and analytics, focusing on computing time-based cohort percentages and conducting year-over-year trend analysis of merchant behavior.

  Data Manipulation (SQL/Python)Onsite
• ShopifyMedium·Data Scientist
  Measure Pirate-Theme Usage and Revenue Growth Over Time

  This question evaluates the ability to design time-based usage metrics and compute monthly revenue through data manipulation using SQL or Python, focusing on aggregating event and transaction records by calendar month.

  Data Manipulation (SQL/Python)Technical Screen
• SnapchatMedium·Data Scientist
  Calculate Average Camera Switches per Session

  Tests the ability to write a PostgreSQL query using window functions (LAG) to compute the average number of specific state transitions per session while accounting for zero-transition sessions and avoiding integer division.

  Data Manipulation (SQL/Python)Technical ScreenSQLPostgreSQLWindow Functions
• SnapchatMedium·Data Scientist
  Compute CTR and metrics with pandas

  This question evaluates proficiency in time-series and event-level data manipulation with pandas, including CTR computation, event denoising and deduplication, sessionization, cohort analysis, temporal joins, and performance-aware vectorized operations within the Data Manipulation (SQL/Python) domain.

  Data Manipulation (SQL/Python)Onsite
• SnapchatMedium·Data Scientist
  Compute User Retention and Analyze Event Data

  This question evaluates a candidate's ability to perform SQL and Python data manipulation for event analytics, including cohort retention, aggregation of distinct purchasing users, median-of-daily-events calculations, and hourly time-series grouping.

  Data Manipulation (SQL/Python)Onsite
• SnapchatMedium·Data Scientist
  Compute same-day acceptance metrics last week

  This question evaluates proficiency in time-based data manipulation, SQL JOINs and aggregations, handling NULLs and missing reference rows, and computing acceptance and percentage metrics with careful UTC date boundary treatment.

  Data Manipulation (SQL/Python)Technical Screen
• SnapchatMedium·Data Scientist
  Count Users Whose First Daily Event Is App Launch

  Write a PostgreSQL query to identify each user's first event per calendar day and aggregate the distinct user count by operating system and device when that first event is an app launch. Tests window functions, tie-breaking logic, and multi-dimensional grouping.

  Data Manipulation (SQL/Python)Technical ScreenSQLPostgreSQLWindow Functions
• SnowflakeMedium·Data Scientist
  Build a cohort dashboard with Streamlit and SQL

  This question evaluates proficiency in cohort analysis using SQL window functions, time-based aggregation, ARPU calculation, and integration of data querying with a Streamlit visualization front end, including handling timezones and data-quality checks.

  Data Manipulation (SQL/Python)Onsite
• SnowflakeMedium·Data Scientist
  Design an analytic warehouse for event data

  This question evaluates a candidate's competency in data warehousing and engineering for analytics, including event-level schema and partitioning, slowly changing dimensions, idempotent ingestion and deduplication, derived metrics modeling, and query performance and cost trade-offs using SQL/Python.

  Data Manipulation (SQL/Python)Onsite
• SnowflakeMedium·Data Scientist
  Query seven-day conversion with windows and dedupe

  This question evaluates proficiency in time-windowed aggregations, event deduplication, and window-function–based user-level analytics across SQL and Pandas workflows.

  Data Manipulation (SQL/Python)Technical Screen
• SpotifyEasy·Machine Learning Engineer
  Query Top Played Tracks Globally And By Country

  Tests writing clean SQL queries with aggregations, window functions, and deterministic tie-breaking to extract top playback metrics globally and per country.

  Data Manipulation (SQL/Python)Technical Screensqlwindow-functionsaggregation
• StripeMedium·Software Engineer
  Compute costs with validation and sorting in Python

  This question evaluates proficiency in data validation, numeric robustness, error handling, aggregation, per-item cost computation and deterministic sorting within Python-based data manipulation tasks, and it belongs to the Data Manipulation (SQL/Python) domain.

  Data Manipulation (SQL/Python)Technical Screen
• StripeMedium·Data Scientist
  Design an idempotent SQL ETL for late data

  This question evaluates practical skills in idempotent ETL design, deduplication by natural keys, handling late-arriving and out-of-order records, upsert/merge strategies, and SQL-based aggregation for daily metrics.

  Data Manipulation (SQL/Python)Technical Screen
• StripeMedium·Data Scientist
  Design metrics and write SQL for a case

  This question evaluates the ability to define time‑bounded, attributable conversion metrics and to implement joins, aggregations, and diagnostic checks in SQL to measure marketing outreach impact.

  Data Manipulation (SQL/Python)Technical Screen
• StripeMedium·Software Engineer
  Design payment-to-invoice matcher with priorities

  This question evaluates parsing and data modeling skills, deterministic matching algorithms with prioritization and tie-breaking, handling monetary values as integer cents, and the ability to design comprehensive test suites for edge cases.

  Data Manipulation (SQL/Python)Technical Screen
• StripeMedium·Software Engineer
  Reconcile Monthly Bank-Account Balances Across Two Datasets

  Implement a reconciliation function that joins internal ledger balances with external bank statements for a target month, categorizing discrepancies while strictly distinguishing between missing records and zero balances.

  Data Manipulation (SQL/Python)Technical ScreenData ManipulationHash TableAccounting
• StripeMedium·Data Scientist
  Write SQL for snapshot features and labels

  This question evaluates proficiency in SQL-based feature engineering for time-series and user-event data, covering snapshotting, temporal joins, deduplication, windowed aggregations, distinct counting, and label construction in the Data Manipulation (SQL/Python) domain.

  Data Manipulation (SQL/Python)Technical Screen
• StripeMedium·Data Scientist
  Write SQL to detect recurring non-subscription users

  This question evaluates a candidate's ability to perform advanced SQL data manipulation and temporal pattern detection in transactional datasets, including attribute-based matching (amount and card fingerprint) and filtering by transaction status.

  Data Manipulation (SQL/Python)Online Assessment
• StripeMedium·Data Scientist
  Write SQL to monitor weekly chargeback spikes

  This question evaluates proficiency in PostgreSQL time-series analytics, specifically aggregations, joins across payments and chargebacks, handling late-arriving events, and calculating per-week metrics such as GMV, active merchants, and chargeback rates.

  Data Manipulation (SQL/Python)Onsite
• TTencentMedium·Data Scientist
  Compute per-player daily cumulative games with windows

  This question evaluates proficiency with SQL window functions, aggregation, date-aware grouping and joins for computing per-player daily counts and running totals, and it falls under Data Manipulation (SQL/Python) for Data Scientist roles, emphasizing practical application rather than purely theoretical concepts.

  Data Manipulation (SQL/Python)Technical Screen
• TeslaMedium·Machine Learning Engineer
  Compute nearest index within threshold after walking distances

  This question evaluates a candidate's proficiency in data manipulation, numerical computing with NumPy, spatial reasoning for Euclidean distance and interpolation along polylines, and designing time- and space-efficient algorithms for large-scale inputs.

  Data Manipulation (SQL/Python)Technical Screen
• TeslaMedium·Machine Learning Engineer
  Implement and vectorize NumPy Conv2D

  This question evaluates understanding of 2D convolution mechanics, multidimensional NumPy array manipulation, and the competency to optimize numerical computations for performance and memory.

  Data Manipulation (SQL/Python)Technical Screen
• TNThe New York TimesEasy·Data Analyst
  Write SQL for content-view analytics

  This question evaluates proficiency in SQL-based data manipulation and analytics, including aggregation, distinct counting, NULL handling, timestamp/hour extraction, device grouping, and row-level ordering, and is situated in the Data Manipulation (SQL/Python) domain.

  Data Manipulation (SQL/Python)Technical Screen
• ThumbtackMedium·Data Scientist
  Compare list/dict; parse JSON/CSV at scale

  This question evaluates understanding of Python data structures (list vs dict), algorithmic time and memory complexity, ordering guarantees in CPython, large-scale parsing and streaming of JSON/CSV, and robust data-cleaning and error-handling strategies.

  Data Manipulation (SQL/Python)Onsite