System Analyst

How would you store data for correct OEE calculation?

Senior

Aston

How does a JSON parser determine whether it is a simple array or object?

Why is Redis used for caching, and Postgres for transactions?

What is a caching feature and danger in a microservice?

Are you ready to relocate to Tashkent?

What is identification, authentication, and authorization? What is the difference?

Senior

Альфа-Банк

Did you write SQL queries for data marts yourself, or just set the task and let programmers do it?

How will the query change if you need to count popularity over a month?

Middle+

СБЕР

The provider allows sending only 100 SMS per second, and the client has 2 million numbers loaded — how to account for this to prevent system failure?

Who does the task come from and in what format?

Have you applied to Alfa-Bank in the last six months?

Explain the principles of how Kafka and RabbitMQ work, and how they differ.

Middle

IT One

Which microservices should be created when splitting a monolithic online store?

Middle

СБЕР

How to physically implement a one-to-one relationship between two tables?

There is a need to load a large volume of data from an external system into ERP — 5-7 million records per month. Where is it better to record: in the document's tabular part, in the information register, or in the directory?

Middle+

Альфа-Банк

Case 2: There are two independent data layers — product analytics of user sessions, devices, and advertising sources, and transactional backend of the credit pipeline. You need to develop a schema of relations and tables for a database that will allow collecting unit economics across marketing sources, indicating keys, and demonstrate a matching problem — merging the profile of an anonymous user before authorization with their real ID after receiving credit.

Have there been any technical disagreements (e.g., REST vs Message Broker) and how were they resolved?

Are you describing directly in the OpenAPI specification?

Middle

СБЕР

Tell us about your experience creating SQL queries. What are the most complex queries you have written?

Middle

IT One

What does your REST contract artifact look like?