System Analyst

What happens after a feature is approved?

What do the letters in RACI stand for?

Do you have experience working with SQL and stored procedures?

How does an analyst fit into the Scrum process? Where do the tasks come from?

What is the term for attributing costs to an asset (capitalization)?

Have you worked with task trackers and requirements management systems?

@enduml @startuml usecase @enduml @startuml classDiagram class EventQueue { getNextEvent() putEvent() } abstract class DoctrineMessenger { } class Sending { высратьSMSSendingQueue() } class SendingQueue { +uuid +готовыйшаблон +номертелефона +техническиепараметры } EventQueue --> DoctrineMessenger SendingQueue --> DoctrineMessenger @enduml @startuml deployment node app { component "php-backend" as backend component "nginx-frontend" as frontend } artifact "CRM, основной блок" as CRM artifact "Модуль истории вызовов" as history note right mPLADIT как чертежик end note artifact "EVENT: Очередь пост." as eventQueue artifact "EVENT: Внутренние эвенты" as internalEvents artifact "EVENT: События безоп." as securityEvents artifact "COMMAND: Командная строка" as commandLine note right InMemory end note artifact "COMMAND: Командная строка" as commandLine2 note right Doctrine? end note artifact "QUERY: Вина запросов" as query1 note right InMemory end note artifact "QUERY: Вина запросов" as query2 note right БД? InMemory? end note

What is the key difference between Kafka and RabbitMQ?

What message brokers do you know?

How to make an API call through Swagger UI?

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

Are you familiar with the RACI matrix?

What is the most interesting, and what is the opposite, in working on the project?

What did you enjoy doing on the last project with unified accounting and inventories?

What is the Strangler Fig pattern?

How do you find out what the TrafficType field indicates?

Are you familiar with the main entities of Scrum?

What is used in Jira in the context of Scrum?

Describe the analyst's workflow: how do tasks arise, and what happens next?

How to make Kafka send a message to all subscribers?