Software Development Engineer 2
Design AdClick Aggregator Service
Design an AdClick Aggregator Service with a focus on multiple design approaches, including Lambda vs Kappa architecture, database schema design, entity relationships, indexing, and the choice between SQL and NoSQL databases. Justify your choices with real use cases and address concerns around scaling, fault tolerance, and observability.
This question was asked in
Databricks Software Development Engineer 2 Interview Experience
The Databricks interview process consisted of four rounds, including a hiring manager round focused on behavioral questions, a problem-solving round that involved a unique paths coding question, and a pair programming round that assessed frontend and backend design skills. The final system design round was the most intense, lasting close to 100 minutes and challenging candidates to justify their design choices regarding scalability and architecture. Overall, the interview experience at Databricks was rigorous and demanding, testing various technical and soft skills across diverse topics.