System Analyst

What do you do when you have many questions about development?

Tell about a memorable failure of yours and what you learned from it.

Middle

Альфа-Банк

How is synchronous and asynchronous interaction represented on a sequence diagram?

Middle

IT One

-- 1. List clients without orders in the last month. -- Structure: -- customers (customer_id, name, registration_date) -- orders (order_id, customer_id, order_date, amount) SELECT DISTINCT c.customer_id, c.name FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id and o.order_date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month' WHERE o.amount IS NULL -- 2. Calculate the share of each subcategory in the total revenue of the category -- sales (product_id, category, subcategory, revenue, sale_date) -- Result needed: category | subcategory | share_of_category

Describe the ERD for the user settings screen. How should settings be stored — as separate fields or otherwise?

Middle

Теле2

Describe the difference between goal and problem statement.

Are you familiar with API maturity levels (Richardson model)?

Middle

СБЕР

Are you familiar with the C4 Model? At what levels have you worked, including with contractors?

What is an exchange in RabbitMQ?

Middle+

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

Do you have any questions about the project, client, domain, or project stage?

Middle

Лига Цифровой Экономики

Overall, what is important to you in a new project? If there are two offers, what will you consider when choosing?

Why are only some steps numbered (1,2,3,4) on the diagram, while others are not?

What is important in work to stay engaged and not get tired?

Чем отличаются JOIN, LEFT JOIN и RIGHT JOIN?

What attributes are important for the 'Loan' entity at the top level?

Did you interact directly with the client or was everything handled through the PM?

Tell me about the T2 project — product, tasks, stack.

Would working on second-line support be a step back for you, considering your analytical experience?

What architectures have you worked with? How was the decision made to split a monolith into microservices?

Middle

IT One

-- 1. List clients without orders in the last month. -- Structure: -- customers (customer_id, name, registration_date) -- orders (order_id, customer_id, order_date, amount) SELECT DISTINCT c.customer_id, c.name FROM customers c LEFT JOIN orders o ON c.customer_id = o.customer_id and o.order_date >= DATE_TRUNC('month', CURRENT_DATE) - INTERVAL '1 month') WHERE o.amount IS NULL -- 2. Calculate the share of each subcategory in the total revenue of the category -- sales (product_id, category, subcategory, revenue, sale_date) -- Result needed: category | subcategory | share_of_category