Airtable interview questions

Showing 1–12 of 12 results

• Count business days excluding holidaysMedium

  This problem tests date manipulation skills and the ability to efficiently calculate working day durations while accounting for dynamic holiday schedules.

  AirtableSoftware EngineerCoding & AlgorithmsOnsite
• Design Extensible Undo and Redo for a SpreadsheetMedium

  This problem tests your ability to design a robust Command pattern architecture capable of handling complex state transitions, such as data deletions and dependency-aware recalculations, in a spreadsheet environment.

  AirtableSoftware EngineerSoftware Engineering FundamentalsTechnical Screen
• Design JSON serialization for circular referencesHard

  This question evaluates understanding of deterministic, cross-language JSON serialization and deserialization for object graphs with cycles, including concepts such as cycle detection, stable object identifiers, preservation of shared subobjects, traversal-order determinism, input validation/security, and time/space complexity.

  AirtableSoftware EngineerSystem DesignOnsite
• Design NL-to-Formula assistant for AirtableMedium

  Airtable software-engineer onsite ML system design question: design an assistant that turns natural-language requests into the product's formula language, grounded in the live table schema, and optionally applies them to the base via the Airtable API. It tests LLM orchestration with structured outputs / a typed IR, schema grounding and type checking, ambiguity handling, static + dynamic formula validation, prompt-injection safety, confirmation-gated writes, latency trade-offs, and offline/online evaluation.

  AirtableSoftware EngineerML System DesignOnsite
• Design a lazy-initialized connection poolMedium

  Design a thread-safe, lazily initialized connection pool with a PooledConnection wrapper: reuse idle connections first, cap active connections, define exhaustion (block-with-timeout) and shutdown semantics, and analyze concurrency safety and complexity. A common Airtable software-engineering screen question.

  AirtableSoftware EngineerSystem DesignHR Screen
• Design a scalable search service with shardingMedium

  This question tests the ability to design a distributed search architecture capable of handling high-throughput indexing and low-latency queries across a massive dataset.

  AirtableSoftware EngineerSystem DesignOnsite
• Design an async API with idempotencyMedium

  This question tests the ability to design a distributed asynchronous processing system that ensures idempotency, data consistency, and reliable task execution under high concurrency.

  AirtableSoftware EngineerSystem DesignOnsite
• Diagnose metric anomalies and evaluate new algorithmEasy

  This question tests your ability to systematically investigate a sudden drop in a key product metric and design a robust A/B test to evaluate the impact of a new recommendation algorithm.

  AirtableData ScientistAnalytics & ExperimentationTechnical Screen
• Explain how to make robust HTTP API callsMedium

  This problem tests your understanding of building resilient client-side code that interacts with external HTTP services, focusing on failure handling and operational stability.

  AirtableSoftware EngineerSoftware Engineering FundamentalsOnsite
• Implement BFS serializer and deserializerMedium

  This question evaluates the skill of serializing and deserializing Python object graphs using BFS, including handling primitives, dictionaries, shared subobjects, and circular references while preserving object identity.

  AirtableSoftware EngineerCoding & AlgorithmsOnsite
• Implement a Connection PoolMedium

  This question evaluates a candidate's competence in resource management, object ownership and lifecycle handling, and safe reuse of pooled database connections.

  AirtableSoftware EngineerSoftware Engineering FundamentalsTechnical Screen
• Optimize a dispatcher’s scheduling data structuresEasy

  This question evaluates understanding of algorithmic analysis and data-structure design for memory-constrained scheduling, including efficient lookup and update operations for tables and machines and the selection of placement and migration policies, categorized under Software Engineering Fundamentals.

  AirtableSoftware EngineerSoftware Engineering FundamentalsOnsite