System Analyst

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?

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 the RAC system and AI agent work in your product?

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?

What data type will the field isCompleted be?

What are the differences between RabbitMQ and Kafka?

Who was BPMN drawn for?

Middle+

Билайн

What business models and diagrams have you encountered in your work experience?

Middle

Вкусно и точка

Why are you considering a new opportunity now? Why are you leaving [company/industry]?