C#

What are MVC, MVP, MVVM? How do they differ?

Middle+

Тензор

What types of indexes have you used in PostgreSQL? Why is GIN index used for full-text search instead of B-tree?

What amount of tasks did you usually perform in a day at your previous job?

Tell about your experience optimizing complex SQL queries and working with execution plans. Was there a case where you managed to speed up a query 2-3 times?

Middle

OZON

Have you worked with the CQRS architectural pattern?

How does an abstract class differ from a regular class?

Middle+

Тензор

What are transaction isolation levels?

What will be outputted in a task with virtual methods? Which method has more ticks and why?

Can you explain in detail the mechanism of execution and operation of the Task object in the system?

What is the complexity of searching for blocked items in a List inside a loop over products, and how can it be optimized?

Middle

Альфа-Банк

If a pod in Kubernetes crashes after successfully booking a hotel but before saving the booking ID, how to restore consistency?

Middle+

OZON

Can you explain what is meant by a topic in Kafka system?

What is the essence of the GC generations concept (0, 1, 2)? What do we optimize?

Explain how the function call process works itself and in what cases it can be useful.

Can you tell more about the architecture: is there a big monolith or a modular monolith?

Middle

Ozon Fresh

What synchronization primitives do you know?

How does the enterprise service bus (ESB) differ from message queues/brokers like Kafka?

Can you compare service communication via gRPC and traditional HTTP interaction? Pros and cons of each approach.

What is the role of three-tier architecture and why is it used in system development?

What is the purpose of window functions in SQL and how do they differ from regular aggregate functions?