Katkat

practice a little every day, paws crossed ♡

Software 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–18 of 18 results

  • AffirmMediumSoftware Engineer
    Implement and debug event filtering in Python

    This question evaluates proficiency in data manipulation and algorithmic reasoning in Python, covering event filtering, stable sorting, deduplication by identifier, timestamp windowing, and analysis of time and space complexity.

    Data Manipulation (SQL/Python)Onsite
  • Applied IntuitionMediumSoftware Engineer
    Implement a nested object validator

    This question evaluates proficiency in nested data validation, schema interpretation, and type checking for hierarchical objects, including handling nulls, arrays, extra fields, and clear error reporting.

    Data Manipulation (SQL/Python)Onsite
  • CoinbaseMediumSoftware Engineer
    Compute delivery metrics and top-K queries

    Compute delivery metrics and top-K queries evaluates SQL or pandas logic, joins, grouping, window functions, null handling, edge cases, and validation in a realistic interview setting. A strong answer states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

    Data Manipulation (SQL/Python)Onsite
  • CoinbaseMediumSoftware Engineer
    Implement filters and cursor pagination

    This question evaluates a candidate's ability to design and implement cursor-based pagination, conjunctive per-field filtering, stable sort key selection, API surface design, and complexity analysis for a database-backed transaction query module.

    Data Manipulation (SQL/Python)Onsite
  • DoorDashMediumSoftware 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
  • DoorDashMediumSoftware 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
  • InstacartMediumSoftware Engineer
    Implement a pivot table transformation

    This question evaluates competency in data transformation and aggregation, specifically pivot operations, time-based grouping, null handling, dimensionality reduction (top‑K/OTHER), scalability for large datasets, and expressing solutions in both Python (pandas or pure) and SQL within the Data Manipulation (SQL/Python) domain.

    Data Manipulation (SQL/Python)Onsite
  • InstacartMediumSoftware Engineer
    Pivot data without date libraries

    This question evaluates a candidate's competency in data manipulation and transformation, specifically pivoting tall datasets into wide views, handling missing metric values, ordering ISO date strings via string operations, and meeting algorithmic efficiency constraints (O(n log n)).

    Data Manipulation (SQL/Python)Onsite
  • InstacartMediumSoftware Engineer
    Pivot transactions by date without date libs

    This question evaluates proficiency in data manipulation, string-based date handling, aggregation and pivot transformations, along with reasoning about data structures, de-duplication and missing-value filling.

    Data Manipulation (SQL/Python)Onsite
  • Marshall WaceMediumSoftware Engineer
    Find users with multi-country successful logins

    This question evaluates proficiency in relational data manipulation, text normalization, aggregation, deduplication, and sorting within the Data Manipulation (SQL/Python) domain, focusing on practical query-writing and data-processing skills.

    Data Manipulation (SQL/Python)Onsite
  • MetaMediumSoftware Engineer
    Set up a Python interview environment

    This question evaluates proficiency in Python development environment setup, including dependency and virtual environment management, secure handling of environment variables for secrets, tooling for rapid feedback, reproducibility practices, and basic service scaffolding.

    Data Manipulation (SQL/Python)Onsite
  • MicrosoftMediumSoftware Engineer
    Count words in a document robustly

    This question evaluates text-processing and algorithmic engineering skills, specifically precise tokenization rule definition, robust handling of Unicode and punctuation, streaming/large-file processing, unit testing for corner cases, and analysis of time and space complexity.

    Data Manipulation (SQL/Python)Onsite
  • MotiveMediumSoftware Engineer
    Fetch and parse JSON from REST API

    A Motive Software Engineer onsite coding exercise: build a small, resilient script from scratch that performs an authenticated HTTP GET against a paginated REST API, parses the JSON, extracts and transforms records, and produces both serialized CSV/JSON output and per-category top-k aggregates. It evaluates HTTP/REST integration, rate-limit and retry handling with backoff, timeouts, malformed-record handling, unit testing, logging, and complexity analysis.

    Data Manipulation (SQL/Python)Onsite
  • NVIDIAMediumSoftware Engineer
    Analyze and debug Python utilities

    This interview question evaluates SQL or pandas logic, joins, grouping, window functions, null handling, edge cases, and validation in a realistic interview setting. A strong answer for Analyze and debug Python utilities states assumptions, handles edge cases, explains trade-offs, and shows how to validate the result clearly.

    Data Manipulation (SQL/Python)Onsite
  • OracleMediumSoftware Engineer
    Parse logs and query by time

    This question evaluates competency in parsing and structuring log lines, interpreting timestamps and time zones, handling malformed input, designing insert/query APIs, reasoning about scalability and indexing, performing time/space complexity analysis, and planning basic tests.

    Data Manipulation (SQL/Python)Onsite
  • OracleMediumSoftware Engineer
    Rank Departments by Student Count

    Tests SQL proficiency in outer joins, aggregation with null handling, and deterministic multi-column sorting.

    Data Manipulation (SQL/Python)Onsitesqlleft-joingroup-by
  • ScribdMediumSoftware 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
  • ScribdMediumSoftware 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