System Analyst

How does RabbitMQ differ from Kafka?

Middle+

СБЕР Страхование

Tell about your most difficult project recently. What was its complexity?

Middle

2gis

Task Managers supporting the Acquiring contract have their own Automated System: the Legal Entity Support System. The Legal Entity Support System requires data on acquiring contracts from the Acquiring System. Design this integration solution.

What requirements need to be clarified for starting the development of a money transfer service between users of different banks?

Middle+

СБЕР

What message brokers do you know?

Tell us about your professional experience and projects you have participated in.

Draw a conceptual ER model for an incident accounting system (explosions, floods) and their zones of damage (minor, medium, severe destruction), which objects (buildings, factories, schools) fall into.

Есть таблица заказов с полями: id заказа, id клиента, статус, дата создания. Куда логично повесить индекс?

Why are you a web developer, but looking for a business analyst job?

How do you document requirements so that developers have enough information and everything is clear?

How is PATCH related to caching GET (the problem of cache staleness after changes)?

Do you have experience working with SQL and stored procedures?

How was the business process audit conducted? How was it done specifically?

Tell me about the team structure and your role in it.

Provide a specific example when LEFT JOIN needs to be used.

What is the ratio of business to system analytics in your work?

1. The developer asks you to hide problems that occur in the application processes because discussing them will only make things worse. What are your actions? Timing: 1 minute

What is the main difference between partitions and indexes?

What features and roles have you encountered in system integration design?

Which vacations are not included in the length of service that entitles you to annual leave?