System Analyst
Tell me about the HTTP DELETE method
WildberriesWhat were the other analysts connected for?
Are government projects not intimidating for you? We have a government customer.
Are you familiar with API maturity levels (Richardson model)?
СБЕРWhat level of SQL do you know? SELECT, JOIN, window functions?
Why are they called left and right?
Are you referring to observability, such as logging and monitoring?
How is interaction organized between teams when a task involves multiple services or circuits?
Clarification: search by contract number, not by ID
How was the problem of multiple services requiring access to a single entity solved? How was consistency ensured during temporary desynchronization?
ВТБWhat do you consider the most important question when interviewing a client?
Have you worked with interface prototypes? Have you written technical specifications for frontends linked to Figma?
How were the agreements between the systems that communicate via Kafka arranged?
СБЕРHave you ever had a client add new requirements and comments during a demo — how did you handle it?
Лига Цифровой ЭкономикиDescribe the algorithm for retrieving a specific page from the database with filtering and sorting.
СБЕРWhat error handling mechanisms do you incorporate in integrations?
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.
СБЕРWhat statuses would you assign to the SMS messages themselves?
What happens if an attribute is not passed or null/0 is passed in PUT and PATCH requests?
What is the difference between a window function and an aggregate function in SQL?
СБЕР