System Analyst

How do you gather business requirements?

What is a trigger in a database?

Logical puzzle about a watermelon: a watermelon weighs 10 kg and is 99% liquid, after drying the liquid it becomes 98%. How much does the watermelon weigh now?

Middle

Альфа-Банк

Will you have the opportunity to re-enter the meeting and connect with the settings again?

Middle

Контур

Where is the API version usually registered?

How was the integration between the systems implemented? Describe the technical details.

What are your principles in life?

Do the proposed diagrams conform to BPMN notation?

Middle+

30бит

Design an ER diagram for an online bookstore. Consider that a book can contain multiple works by different authors, a work can be in different books, and there should be a keyword search feature.

Middle

СБЕР

What is idempotency? Which HTTP methods are idempotent?

Have you worked on projects that are used internally within the company, i.e., internal projects?

What were the synchronous and asynchronous integrations? In which cases are each used? What is the danger of synchronous interaction?

What questions would you ask the client 1-1.5 hours before they go on vacation for 3 weeks if there is an urgent feature?

Middle

СБЕР

What types of software architecture do you know?

Middle+

СБЕР

Do I understand correctly that you were a full-stack in analysis — that is, there was no division into system and business analyst, or was there?

CREATE OR ALTER PROCEDURE dif.get_request_to_cancel_not_confirmed_delivery AS BEGIN SET NOCOUNT ON; declare @delivery_id bigint , @request_queue_id bigint , @request_id bigint , @contents varchar(max) select top 1 @delivery_id = od.delivery_id , @request_queue_id = null , @request_id = odr.request_id , @contents = cn.contents from opsapi.request rq join ops.contents cn on cn.contents_uid = rq.contents_uid join dif.ops_delivery_request odr on odr.request_id = rq.request_id join dif.ops_delivery od on od.delivery_id = odr.delivery_id where 1 = 1 and rq.state_code = 200 and rq.scheme_name = 'исх:опс.лк.отмена.слота.ффд' and od.state_code = 257 order by rq.request_id update opsapi.request set state_code = 202 , state_name = opsapi.get_state_name(202) , state_note = null , state_datetime = getdate() , updated_at = getdate() where request_id = @request_id select @request_queue_id request_queue_id, @request_id request_id, @contents contents END GO

What integrations have you had experience with?

Middle

Bell Integrator

Have you ever encountered Keycloak as a component of architecture?

Does the team work based on the Scrum, Kanban, or a mixed model?

The interviewer described a system where the response always has 200 and success=false for errors. How do you feel about this?