Design, build, and deploy production-grade software components using Python, SQL, Scala, Java, C++. Ensure all new microservices adhere to SOLID design principles, clean architecture separation of concerns, and comprehensive automated unit/integration test coverage (>85%).

Analyze database query performance, index utilization, and cache hit ratios. Implement multi-level distributed caching (e.g. Redis, Caffeine) and asynchronous queue processing to maintain P99 latency SLAs below 250ms under peak traffic surges.

Package services into lightweight container images using Docker and deploy them across AWS EMR, Databricks, Snowflake, Google BigQuery, Apache Airflow. Author Infrastructure as Code (IaC) templates using Terraform or Helm charts for repeatable multi-region deployments.

Instrument distributed tracing, structured logging, and metric alerts using MLflow, Weights & Biases, Great Expectations, DataDog. Participate in engineering on-call rotations, rapidly mitigating production anomalies and authoring blameless Root Cause Analysis (RCA) documents.

Test Format: Complex SQL analytical window functions, pandas vectorization optimizations, and 2 algorithmic data structure challenges.
Pro-Tip: Pay extreme attention to edge cases: null pointers, integer overflow, empty collections, and time limit exceeded (TLE) constraints on large test inputs (N=10^5).

Primary Topics: Matrix Manipulation, Dynamic Programming, Trees, Binary Search, Priority Queues / Heaps, Hash Tables.
Execution Strategy: Always communicate your thought process aloud before typing code. State the brute-force approach first (O(N^2)), then optimize using space-time tradeoffs (O(N) with Hash Map or Two Pointers), and write production-grade, cleanly formatted code with descriptive variable names.

Expected Design Challenges: Real-Time Streaming Feature Store, Distributed Vector Search Database (RAG Architecture), High-Throughput Clickstream Ingestion Engine with Kafka & ClickHouse.
Design Framework: 1) Clarify functional/non-functional requirements and scale numbers (RPS, DAU, storage). 2) Define API contracts and data models. 3) Draw high-level component diagrams. 4) Deep-dive into bottlenecks: database sharding, replication lag, caching invalidation strategies, and network partition handling (CAP Theorem).

Structure every response using the STAR Method (Situation, Task, Action, Result). Prepare 3 real-world stories showcasing: a time you disagreed with a technical decision and how you resolved it with data, a major production outage you debugged under pressure, and how you mentored junior engineers.