System Analyst

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 your experience with Python? Have you written simple scripts with loops or something heavier — pandas, matplotlib?

Middle

СБЕР

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

What is idempotency and when is it important? Provide a business scenario.

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

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?

-- 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

Tell us why you decided to change your workplace.

Is the request with the POST method always used for creating a record?

Which HTTP method is used to replace a single letter in the login of a personal account and why?

Why do some choose SQL databases?

How does a large number of records affect the choice of HTTP method?

Which employment format is preferred — TК or ИП?

How does SOAP differ from REST?

What notations do you work with in practice?

Middle

IT One

[Name] asked: in which city do you reside?