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–30 of 47 results
- AdobeMediumSoftware EngineerFind Top-Funded Villages and Their Top Projects
Tests the ability to write a multi-level SQL aggregation with window functions, exact date filtering, tie handling, and deterministic sorting.
Data Manipulation (SQL/Python)Online Assessmentsqlwindow-functionsaggregation - AdobeMediumSoftware EngineerImplement scalable word count locally
This question evaluates understanding of scalable word-count processing, including tokenization and normalization rules, streaming or external-memory techniques for inputs larger than RAM, and efficient top‑K frequency computation.
Data Manipulation (SQL/Python)Technical Screen - AeoneaMediumSoftware EngineerFill missing values with means
This question evaluates proficiency in missing-data imputation and pandas DataFrame manipulation, testing skills in column-wise aggregation, group-wise operations, and edge-case handling within the Data Manipulation (SQL/Python) domain.
Data Manipulation (SQL/Python)Technical Screen - AffirmMediumSoftware EngineerAnalyze Returning Borrowers Across Two Days of Logs
Process two daily loan activity logs to identify users active on both days with diverse loan types, then score them using a configurable trust policy.
Data Manipulation (SQL/Python)Technical ScreenData ManipulationHash TablePython - AffirmMediumSoftware EngineerImplement 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 - AirbnbMediumSoftware EngineerReview a geospatial Python module
This question evaluates proficiency in geospatial data processing and Python code review, including detection of correctness bugs, numerical stability issues, CRS handling, performance optimization, refactoring, testing strategy, and security considerations when working with CSV/GeoJSON datasets.
Data Manipulation (SQL/Python)Technical Screen - Akuna CapitalMediumSoftware EngineerAnswer SQL MCQs with reasoning
This question evaluates proficiency in SQL query semantics and reasoning about relational operations—specifically INNER, LEFT, and RIGHT JOIN behavior; GROUP BY and HAVING usage; NULL handling in comparisons and aggregates; window functions such as ROW_NUMBER and RANK; and the logical query processing order—within the Data Manipulation (SQL/Python) domain. It is commonly asked to assess the ability to interpret and justify query outcomes versus alternative answers, testing both conceptual understanding of relational theory and practical application of SQL query behavior.
Data Manipulation (SQL/Python)Online Assessment - Akuna CapitalMediumSoftware EngineerEvaluate SQL expressions for zero
This question evaluates understanding of SQL type coercion, boolean semantics, comparison operators, and dialect-specific evaluation behavior (for example, MySQL), focusing on interpreting expressions that may evaluate to zero.
Data Manipulation (SQL/Python)Online Assessment - AmazonMediumSoftware EngineerCompute unique visitors per department from clicks
This question evaluates a candidate's skill in data manipulation and deduplication using SQL/Python, specifically mapping hierarchical product metadata to departments and computing unique user counts without double-counting, and is categorized under Data Manipulation (SQL/Python).
Data Manipulation (SQL/Python)Technical Screen - AmazonMediumSoftware EngineerManipulate time-series with Pandas groupby
This question evaluates proficiency in time-series data manipulation, including timezone-aware datetime parsing and DST handling, groupby and rolling-window aggregations, resampling to fill calendar gaps, and user-level retention and DAU calculations using idiomatic, vectorized Pandas or SQL operations.
Data Manipulation (SQL/Python)Technical Screen - AppleMediumSoftware EngineerExplain Python lists, dicts, and concurrency
Explain Python lists, dicts, and concurrency 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)Technical Screen - Applied IntuitionMediumSoftware EngineerImplement 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 - Bilt RewardsMediumSoftware EngineerWrite SQL to Join Merchants and Triple Restaurant Points
This question evaluates SQL querying and data engineering competencies—specifically JOINs, conditional logic (CASE), ETL staging, data cleaning, indexing, and approximate string matching—within the data manipulation and database domain and emphasizes practical application of SQL for transforming transactional datasets.
Data Manipulation (SQL/Python)Technical Screen - CircleMediumSoftware EngineerWrite PostgreSQL updates with date filters
This question evaluates competency in PostgreSQL data manipulation, covering updates with correct timestamp handling, upserts with conflict resolution, date-range selection using timestamptz, and index design plus performance analysis with EXPLAIN ANALYZE.
Data Manipulation (SQL/Python)Online Assessment - CoinbaseMediumSoftware EngineerCompute 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 EngineerImplement 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 EngineerCompute 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 - DoorDashMediumSoftware EngineerCompute 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 EngineerCompute 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 - IBMMediumSoftware EngineerFind Customers Whose Average Website Resource Usage Exceeds 50 Percent
Practice PostgreSQL aggregation with HAVING, customer-level average resource utilization, strict thresholds, two-decimal rounding, and ascending email output.
Data Manipulation (SQL/Python)Online Assessment - InstacartMediumSoftware EngineerImplement 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 EngineerPivot 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 EngineerPivot 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 - KikoffMediumSoftware EngineerParse CSV and format transactions
This question evaluates a candidate's ability to parse and format structured transactional data, emphasizing CSV parsing, trimming whitespace, numeric formatting to two decimal places, and preserving input row order.
Data Manipulation (SQL/Python)Technical Screen - KneronMediumSoftware EngineerCount IoT devices matching date and threshold
This question evaluates handling of paginated REST APIs, JSON parsing and nested-data filtering, month/year date parsing, and numeric threshold comparisons, reflecting skills in data retrieval and programmatic data manipulation.
Data Manipulation (SQL/Python)Online Assessment - Marshall WaceMediumSoftware EngineerFind 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 - MathWorksMediumSoftware EngineerCalculate cost from orders with SQL
This question evaluates a candidate's ability to perform SQL data manipulation and business-rule calculations, including conditional joins, date-range filtering, and numeric arithmetic for discounts and taxes.
Data Manipulation (SQL/Python)Online Assessment - MetaMediumSoftware EngineerSet 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 EngineerCompute most popular location with weights
This question evaluates a candidate's ability to perform weighted aggregation, data cleaning, tie-breaking logic, and handling of malformed or missing text fields using SQL and/or Python.
Data Manipulation (SQL/Python)Technical Screen - MicrosoftMediumSoftware EngineerCount 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
Adobe
Affirm
Airbnb
Akuna Capital
Amazon
Apple
Applied Intuition
Circle
Coinbase
DoorDash
IBM
Instacart
MathWorks
Meta
Microsoft