System Analyst

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.

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?

What is a consumer group in Kafka and how is it related to partitions?

Middle

IT One

What directions or fields of activity of the company would you be interested in considering?

How was API versioning and contract management controlled?

How tolerant are you to working in an office format for the first 2-3 months?

Қиын сұраулардың дұрыс жұмыс істеп тұрғанын қалай түсінуге болады, олар жай ғана ұзақ жұмыс істейді?

Have you had experience starting projects from scratch?

When do you choose REST, and when SOAP?

Middle

СБЕР

Can security professionals be stakeholders?

What other integration methods do you know besides REST? Tell me about gRPC.

What is your level of proficiency with UML diagrams (ER, Sequence, State)?

Middle

IT One

In what case is BPMN really needed, and in what case is it redundant?

Do you configure roles in the system?

Tell me about Camunda, how was it used on the project?