Google (Alphabet) Mountain View, CA / New York / Bengaluru / Hyderabad FAANG / BigTech Bengaluru Hyderabad Pune Gurugram System Design Archetype: Global Spanner Multi-Region Replication & Millisecond BigQuery BI Engine
$240k - $360k (₹65L - ₹1.1Cr)
$380k - $580k (₹1.2Cr - ₹2.4Cr)
Production Tech Stack:
BigQuery Cloud Spanner Apache Beam / Dataflow Cloud Pub/Sub Colossus Flume / Borg Dremel
Key Architectural Interview Topics: • Dataflow watermarking, allowed lateness, and session window triggers • Cloud Spanner TrueTime API and Paxos consensus across continental zones • BigQuery dynamic slot reservation vs autoscaling optimization • Petabyte-scale table partitioning and clustering without full scan degradation Scale Challenge: Processing exabytes of search clickstream and YouTube video telemetry with zero data loss under strict SLA deadlines.
Real Interview System Design Prompts (2)
Microsoft (Fabric & Azure Data) Redmond, WA / Sunnyvale / Hyderabad / Bengaluru FAANG / BigTech Hyderabad Bengaluru Noida System Design Archetype: OneLake Direct Lake Zero-ETL Semantic Ingestion & Fabric Capacity Sizing
$220k - $330k (₹55L - ₹90L)
$340k - $500k (₹1.0Cr - ₹1.8Cr)
Production Tech Stack:
Microsoft Fabric Direct Lake Azure Synapse OneLake Delta Lake ADLS Gen2 Azure Data Factory
Key Architectural Interview Topics: • Direct Lake VertiPaq memory mapping over OneLake Delta Parquet files • ADF Managed VNet Integration Runtime security and high-throughput CDC • Fabric Capacity Unit (CU) burst smoothing, throttling, and auto-pause strategies • Multi-tenant Delta transaction log concurrent append conflict resolution Scale Challenge: Unifying disparate enterprise silos into OneLake with sub-second Power BI Direct Lake report execution.
Real Interview System Design Prompts (2) Amazon / AWS Seattle, WA / Arlington, VA / Bengaluru / Hyderabad FAANG / BigTech Bengaluru Hyderabad Chennai Pune System Design Archetype: Global E-Commerce Event Ordering & Redshift Serverless Data Sharing
$230k - $350k (₹60L - ₹95L)
$360k - $540k (₹1.1Cr - ₹2.1Cr)
Production Tech Stack:
Amazon Redshift AWS EMR (Spark) Amazon Kinesis AWS Glue S3 Lake Formation DynamoDB Streams Apache Iceberg
Key Architectural Interview Topics: • Kinesis shard splitting, hot shard mitigation, and enhanced fan-out consumers • AWS Glue auto-scaling DPUs with dynamic catalog partitions • Redshift distribution keys (KEY, ALL, EVEN) and sort key pruning optimization • Lake Formation fine-grained table access control and S3 prefix request distribution Scale Challenge: Ensuring deterministic global package tracking and pricing updates during Prime Day spikes exceeding 150M RPS.
Real Interview System Design Prompts (2) Meta (Facebook) Menlo Park, CA / Seattle / London / Bengaluru FAANG / BigTech Bengaluru Gurugram Hyderabad System Design Archetype: Exabyte Graph Social Telemetry & Scuba Real-Time Slicing Engine
$250k - $380k (₹70L - ₹1.2Cr)
$400k - $620k (₹1.3Cr - ₹2.6Cr)
Production Tech Stack:
Presto / Trino Apache Spark XStream / Scribe RocksDB Hive / Gorilla Scuba PyTorch DataPipes
Key Architectural Interview Topics: • Presto coordinator query planning, dynamic filtering, and worker memory pool spill • Trino split generation across exabyte partition catalogs • Spark shuffle service optimization and z-order indexing on distributed cold storage • High-frequency feature store generation for real-time recommendation rankers Scale Challenge: Querying billions of social connections and live reel view counts in sub-seconds while enforcing user privacy boundaries.
Real Interview System Design Prompts (2) Apple Cupertino, CA / Austin, TX / Bengaluru / Hyderabad FAANG / BigTech System Design Archetype: Private Device Telemetry Ingestion & Differential Privacy Lakehouse
$230k - $340k (₹60L - ₹95L)
$350k - $520k (₹1.1Cr - ₹1.9Cr)
Production Tech Stack:
Apache Spark Apache Iceberg Apache Kafka Cassandra Kubernetes AWS S3 / GCP Trino
Key Architectural Interview Topics: • Differential privacy noise injection and anonymization in telemetry streams • Apache Iceberg metadata compaction and snapshot lifecycle management • Zero-downtime Cassandra cluster migrations and tombstone purging • Spark memory tuning for skew joins on Apple Music search logs Scale Challenge: Collecting analytics from 2 billion active hardware devices without compromising strict user privacy guarantees.
Real Interview System Design Prompts (2) Netflix Los Gatos, CA / Remote / Mumbai FAANG / BigTech System Design Archetype: Global Video Streaming Telemetry & Keystone Real-Time Stream Engine
$260k - $400k (₹75L - ₹1.3Cr)
$420k - $650k (₹1.4Cr - ₹2.8Cr)
Production Tech Stack:
Apache Iceberg (Creators) Apache Flink Apache Kafka (Keystone) AWS S3 Spark Trino Metacat
Key Architectural Interview Topics: • Apache Iceberg manifest file rewrites, partition evolution, and hidden partitioning • Flink checkpointing, RocksDB state backend, and unaligned checkpoints • Keystone stream router failover and multi-region S3 replication • Trino pushdown predicates and dynamic partition pruning over S3 Scale Challenge: Ingesting 1+ trillion events daily to dynamically adjust video bitrates and optimize CDN cache placement worldwide.
Real Interview System Design Prompts (2) Uber San Francisco, CA / Bengaluru / Hyderabad FAANG / BigTech System Design Archetype: Geospatial H3 Geospatial Ingestion & Real-Time Dynamic Surge Pricing
$220k - $340k (₹58L - ₹92L)
$350k - $520k (₹1.1Cr - ₹1.9Cr)
Production Tech Stack:
Apache Hudi (Creators) Apache Flink Kafka (Chaperone) H3 Hexagonal Index Presto Spark Pinot
Key Architectural Interview Topics: • Apache Hudi Copy-on-Write vs Merge-on-Read indexing strategies • H3 geospatial grid indexing for low-latency rider-driver matching queries • Apache Pinot real-time segments and multi-stage query engine • Dynamic surge pricing computation with sliding 60-second window state in Flink Scale Challenge: Calculating hyper-local surge pricing and driver availability across millions of geospatial cells updated every 5 seconds.
Real Interview System Design Prompts (2) Airbnb San Francisco, CA / Remote / Gurugram FAANG / BigTech System Design Archetype: Airflow DAG Orchestration Ecosystem & Minerva Metric Semantic Store
$210k - $330k (₹52L - ₹85L)
$340k - $490k (₹1.0Cr - ₹1.7Cr)
Production Tech Stack:
Apache Airflow (Creators) Apache Spark Minerva (Semantic Layer) Trino Apache Iceberg Druid AWS S3
Key Architectural Interview Topics: • Airflow scheduler internals, dag file parsing loop, and Celery / K8s executors • Minerva unified metric repository: standardizing metrics across batch & streaming • Spark data skew mitigation using salting and broadcast hash joins • Search ranking feature extraction pipeline with strict SLA backfills Scale Challenge: Orchestrating 10,000+ daily Airflow DAGs with zero scheduler lag and consistent business metrics across mobile and web.
Real Interview System Design Prompts (2) Stripe San Francisco, CA / Dublin / Bengaluru / Remote FAANG / BigTech System Design Archetype: Financial Ledger Double-Entry Streaming & Zero-Discrepancy Reconciliation
$240k - $370k (₹65L - ₹1.1Cr)
$390k - $590k (₹1.3Cr - ₹2.3Cr)
Production Tech Stack:
Apache Kafka Flink Presto / Trino Iceberg Scala PostgreSQL AWS S3
Key Architectural Interview Topics: • Exactly-once processing semantics with Kafka transactional producers and 2-phase commit • Double-entry bookkeeping validation in high-throughput streaming pipelines • Deterministic distributed ledger state replication across AWS regions • Presto query acceleration for enterprise merchant financial reporting Scale Challenge: Processing billions in global transactions with zero floating-point errors, zero duplicates, and real-time fraud mitigation.
Real Interview System Design Prompts (2) Databricks San Francisco, CA / Bengaluru / Remote FAANG / BigTech System Design Archetype: Delta Lake Multi-Engine ACID Serialization & Photon Vectorized Execution
$240k - $360k (₹65L - ₹1.1Cr)
$380k - $550k (₹1.2Cr - ₹2.2Cr)
Production Tech Stack:
Apache Spark 4.0 Delta Lake Photon C++ Engine Unity Catalog Scala Rust Vector Search
Key Architectural Interview Topics: • Deep Spark Tungsten off-heap memory layout and binary cache line alignment • Catalyst physical optimizer rules, cost-based optimization, and dynamic code generation • Liquid clustering vs hierarchical Z-Ordering file pruning algorithms • Distributed consensus and multi-cluster Delta transaction log serialization Scale Challenge: Building petabyte-scale multi-tenant execution planning with sub-second metadata operations across thousands of customer clusters.
Real Interview System Design Prompts (2) Snowflake Bozeman, MT / San Mateo, CA / Pune / Bengaluru FAANG / BigTech System Design Archetype: Decoupled Multi-Cluster Compute & Open Iceberg Polaris Catalog
$230k - $340k (₹60L - ₹95L)
$350k - $520k (₹1.1Cr - ₹1.9Cr)
Production Tech Stack:
Apache Iceberg FoundationDB Polaris Catalog Snowpark Python C++ AWS S3 / Azure Blob Search Engine
Key Architectural Interview Topics: • Micro-partition metadata pruning, clustering depths, and search optimization service • Virtual warehouse multi-cluster concurrency scaling and queuing behavior • Iceberg catalog metadata snapshot isolation and Polaris open catalog governance • Zero-copy data sharing architecture across cross-cloud accounts Scale Challenge: Maintaining instant scale-out of isolated virtual warehouses without local disk state while keeping query startup times under 50ms.
Real Interview System Design Prompts (2) Palantir Technologies Denver, CO / New York / Remote FAANG / BigTech Remote / Global Hubs System Design Archetype: Foundry Ontology Data Fabric & Secure Defense-Grade Lineage
$220k - $340k (₹58L - ₹90L)
$350k - $520k (₹1.1Cr - ₹1.9Cr)
Production Tech Stack:
Palantir Foundry Apache Spark Apollo Platform PostgreSQL Kafka Elasticsearch C++
Key Architectural Interview Topics: • Ontology object graph mapping over heterogeneous relational and unstructured stores • Fine-grained classification markings, cell-level security, and audit trails • Deterministic incremental data branch computation in Foundry datasets • Spark job optimization for complex recursive graph traversals Scale Challenge: Integrating messy siloed government and enterprise datasets into a secure, bidirectional semantic ontology in real time.
Real Interview System Design Prompts (2) Salesforce (Data Cloud) San Francisco, CA / Hyderabad / Bengaluru FAANG / BigTech System Design Archetype: Customer Data Platform (CDP) Identity Resolution & Zero-Copy Federation
$210k - $320k (₹50L - ₹82L)
$330k - $480k (₹95L - ₹1.6Cr)
Production Tech Stack:
Salesforce Data Cloud Apache Spark Iceberg / Delta Kafka Trino Tableau Hyper AWS EKS
Key Architectural Interview Topics: • Deterministic and probabilistic identity resolution algorithms for customer entity linking • Zero-copy data sharing federation with Snowflake, BigQuery, and Databricks • Kafka event ingestion pipelines handling millions of customer interactions per minute • High-concurrency query dispatching for real-time marketing segmentation Scale Challenge: Unifying billions of disparate customer profile records and interaction events into a single real-time golden record.
Real Interview System Design Prompts (2) Oracle (Cloud Infrastructure - OCI) Austin, TX / Bengaluru / Hyderabad FAANG / BigTech Bengaluru Hyderabad Noida System Design Archetype: OCI Autonomous Data Warehouse & Exadata RDMA Storage Engine
$190k - $290k (₹45L - ₹75L)
$300k - $450k (₹85L - ₹1.5Cr)
Production Tech Stack:
OCI Autonomous DW Oracle GoldenGate Spark on OCI OCI Streaming (Kafka API) Exadata Object Storage
Key Architectural Interview Topics: • GoldenGate real-time zero-loss CDC capture from Oracle RAC databases • Autonomous Data Warehouse auto-indexing and Exadata Smart Scan offloading • OCI Object Storage multipart upload performance and multi-region replication • Distributed query tuning on Oracle Exadata RDMA fabric Scale Challenge: Migrating mission-critical on-premises Oracle databases to OCI Autonomous Data Warehouse with zero downtime.
Real Interview System Design Prompts (2) Cisco Systems San Jose, CA / Bengaluru / Remote FAANG / BigTech System Design Archetype: Global Network Packet Telemetry & Real-Time Threat Anomaly Detection
$185k - $280k (₹42L - ₹70L)
$290k - $430k (₹80L - ₹1.4Cr)
Production Tech Stack:
Apache Kafka Apache Spark Elasticsearch Cassandra Druid Kubernetes AWS / OpenStack
Key Architectural Interview Topics: • High-throughput NetFlow and IPFIX telemetry ingestion via Kafka • Streaming anomaly detection algorithms on network packet header logs • Elasticsearch cluster sharding and hot-warm-cold lifecycle tiers • Distributed time-series aggregation for enterprise network switches Scale Challenge: Ingesting and indexing 100+ million network telemetry packets per second to identify cybersecurity anomalies in real time.
Real Interview System Design Prompts (2) Adobe (Experience Platform - AEP) San Jose, CA / Noida / Bengaluru FAANG / BigTech System Design Archetype: Experience Data Model (XDM) Lakehouse & Real-Time Profile Activation
$200k - $310k (₹48L - ₹78L)
$310k - $470k (₹90L - ₹1.6Cr)
Production Tech Stack:
Adobe Experience Platform Apache Spark Apache Iceberg Kafka Azure Cosmos DB Kubernetes Delta Lake
Key Architectural Interview Topics: • Experience Data Model (XDM) schema validation and evolution • Sub-50ms customer edge profile lookups from distributed key-value stores • Spark job optimization for segment population calculation over billions of profiles • Streaming audience qualification using stateful Flink / Kafka streams Scale Challenge: Evaluating millions of complex audience segmentation rules against real-time user clickstream events under 100ms.
Real Interview System Design Prompts (2)
NVIDIA Santa Clara, CA / Bengaluru / Pune / Hyderabad FAANG / BigTech Bengaluru Pune Hyderabad System Design Archetype: RAPIDS GPU-Accelerated ETL & Distributed Model Training Data Pipelines
$240k - $370k (₹65L - ₹1.1Cr)
$380k - $570k (₹1.2Cr - ₹2.3Cr)
Production Tech Stack:
RAPIDS cuDF / cuML Apache Spark (Spark-RAPIDS) Ray Triton Inference Server Alluxio NVLink / InfiniBand Kafka
Key Architectural Interview Topics: • Spark-RAPIDS GPU acceleration plugin: offloading joins and shuffles to CUDA cores • GPUDirect Storage (GDS) bypassing CPU memory during high-throughput Parquet reads • Distributed data sharding and DataLoader optimization for multi-node LLM training • Ray Core vs Spark for distributed reinforcement learning data prep Scale Challenge: Feeding thousands of H100/B200 GPU clusters with petabytes of training tokens without causing GPU compute starvation.
Real Interview System Design Prompts (2) Intel Corporation Santa Clara, CA / Bengaluru / Remote FAANG / BigTech System Design Archetype: Semiconductor Silicon Telemetry & Factory Automated Yield Analytics
$180k - $270k (₹40L - ₹68L)
$280k - $420k (₹75L - ₹1.3Cr)
Production Tech Stack:
Apache Spark Apache Kafka Cassandra PostgreSQL Grafana / InfluxDB Kubernetes Python
Key Architectural Interview Topics: • Silicon wafer test telemetry time-series storage and sub-micron defect correlation • Spark streaming for fab machine anomaly detection • Cassandra data modeling for high-write industrial sensor streams • Kafka partition strategies for high-frequency fab tool sensor feeds Scale Challenge: Processing terabytes of real-time wafer fab sensor logs per minute to catch semiconductor manufacturing defects instantly.
Real Interview System Design Prompts (2) AMD Santa Clara, CA / Austin, TX / Bengaluru / Hyderabad FAANG / BigTech System Design Archetype: Silicon Simulation Telemetry Lakehouse & EDA Compute Farms
$180k - $270k (₹40L - ₹68L)
$280k - $420k (₹75L - ₹1.3Cr)
Production Tech Stack:
Apache Spark PostgreSQL Kafka ClickHouse Docker / K8s Python Airflow
Key Architectural Interview Topics: • Electronic Design Automation (EDA) simulation log indexing and regression triage • ClickHouse column storage for high-speed hardware simulation diagnostics • Large-scale distributed task scheduling across hybrid on-prem / cloud compute grids • Spark SQL partition optimization for billion-row hardware test suites Scale Challenge: Analyzing petabytes of chip verification waveforms and test simulations across millions of nightly server farm runs.
Real Interview System Design Prompts (2) ByteDance (TikTok) Singapore / San Jose, CA / London / Remote FAANG / BigTech System Design Archetype: Billion-User Short Video Engagement Stream & Real-Time Recommendation Ranker
$240k - $370k (₹65L - ₹1.1Cr)
$390k - $580k (₹1.2Cr - ₹2.3Cr)
Production Tech Stack:
Apache Flink (World's Largest Cluster) Apache Kafka ByteDance Las (Lakehouse) RocksDB ClickHouse HDFS / Cloud
Key Architectural Interview Topics: • Running massive 100,000-core Flink stateful jobs without checkpoint timeouts • Incremental RocksDB state checkpoints and rapid failover recovery • Real-time feature engineering: calculating user swiping affinity within 20ms • ClickHouse sharding and distributed table optimization for live stream analytics Scale Challenge: Maintaining sub-50ms recommendation feature calculation for over 1 billion active TikTok users simultaneously.
Real Interview System Design Prompts (2) X (formerly Twitter) San Francisco, CA / Austin, TX / Remote FAANG / BigTech System Design Archetype: Global Firehose Stream Fan-Out & Low-Latency Timeline Reconstruction
$220k - $340k (₹58L - ₹92L)
$340k - $500k (₹1.0Cr - ₹1.8Cr)
Production Tech Stack:
Apache Kafka Apache Spark Presto Manhattan (Distributed KV) GCP BigQuery Scala Kubernetes
Key Architectural Interview Topics: • Kafka fan-out partition architecture for celebrity accounts with 100M+ followers • Manhattan distributed key-value store consistency and cache eviction policies • BigQuery cost optimization for multi-tenant internal analytics • Streaming impression counting with hyperloglog cardinality estimation Scale Challenge: Delivering real-time posts from high-follower accounts to hundreds of millions of user home timelines within 1 second.
Real Interview System Design Prompts (2) LinkedIn Sunnyvale, CA / Bengaluru / Dublin FAANG / BigTech System Design Archetype: Apache Kafka Birthplace Architecture & Apache Pinot Real-Time OLAP
$220k - $330k (₹55L - ₹90L)
$340k - $510k (₹1.0Cr - ₹1.8Cr)
Production Tech Stack:
Apache Kafka (Creators) Apache Pinot (Creators) Apache Gobblin Apache Spark Venice KV Hadoop / Azure
Key Architectural Interview Topics: • Kafka partition leadership election, ISR list mechanics, and zero-copy transfer • Apache Pinot star-tree index generation and low-latency slice-and-dice queries • Gobblin distributed data ingestion framework for Kafka-to-Data-Lake pipeline • Venice derived data serving store for high-throughput machine learning rankers Scale Challenge: Powering 'Who Viewed Your Profile' and feed analytics with sub-second latency over hundreds of billions of social graph edges.
Real Interview System Design Prompts (2) Pinterest San Francisco, CA / Remote FAANG / BigTech System Design Archetype: Visual Search Graph & Terabyte-Scale Pin Recommendation Lakehouse
$210k - $320k (₹52L - ₹85L)
$330k - $490k (₹95L - ₹1.6Cr)
Production Tech Stack:
Apache Spark Apache Flink RocksDB AWS S3 StarRocks Airflow Kafka
Key Architectural Interview Topics: • Graph-based visual search feature store pipelines • StarRocks real-time OLAP engine for advertiser campaign analytics • Flink stateful stream processing for real-time pin click-through rate updates • Cost optimization on multi-petabyte AWS S3 storage tiers Scale Challenge: Generating personalized visual discovery feeds for 500M+ monthly users across billions of saved visual pins.
Real Interview System Design Prompts (2) Spotify Stockholm / New York / London / Remote FAANG / BigTech System Design Archetype: Global Music Streaming Royalty Settlement & Scio / Beam Event Pipelines
$210k - $330k (₹52L - ₹86L)
$330k - $490k (₹95L - ₹1.6Cr)
Production Tech Stack:
Scio (Scala on Beam) Google Cloud BigQuery Cloud Bigtable Cloud Pub/Sub PostgreSQL Flyte / Airflow
Key Architectural Interview Topics: • Scio / Beam streaming pipeline design and session windowing for audio track plays • BigQuery cost optimization: query partitioning, clustering, and bi-engine acceleration • Cloud Bigtable row key schema design for user listening history lookups • Streaming track play counting with exact deduplication for artist royalty payments Scale Challenge: Accurately auditing and calculating monthly royalty payouts for millions of artists across 600M+ active listeners.
Real Interview System Design Prompts (2) Showing 24 of 156 companies
Load More Companies (+24) Show All (156)