System Analyst

What does COUNT(l.loan_id) AS loan_count mean in an SQL query?

Middle+

СБЕР

Why do you want to leave your current company?

If a REST request takes a minute, is it synchronous or asynchronous?

Are you offered new projects?

If a client requests a specific solution but it's unclear what problem it solves — how do you act?

What questions do you want to ask your future employer?

Tell us about setting up CI/CD and containerization in Docker on the project — what exactly did you do?

Tell about the company, what you do, how the work is organized, how requests are received, do you interact with clients?

What will the catalog service pass to the payment service?

Middle

СБЕР

What factors are important to you when looking for a new place? What is a green flag, and what is a red flag?

What is HAVING in SQL?

Middle+

СБЕР

Tell us about your last/current project: task, team, interaction, and duration.

REST API task: creating an order in a bookstore — method, request body, response, idempotency.

Middle

IT One

Why are they called left and right?

Middle+

Билайн

What criteria should the requirements meet?

What types of financial reporting do you know?

Middle

СБЕР

Draw a diagram in chat like in the first message (textual view).

Why is it necessary to describe the AS IS process?

Какие back-office системы и административные интерфейсы связаны с экосистемой [компания]?

Who was the client on the last project?