System Analyst

Which DBMSs have you worked with, which ones have you used more or less, and at what level?

What is idempotency? How to achieve idempotency of a request in our case?

Middle+

СБЕР

Are you willing to consider a hybrid work format (with visits to the client)?

If there are three records in the first table and three in the second, how many records will be returned by a left join?

Middle+

Билайн

What technology stack have you worked with before?

Senior

Альфа-Банк

How does Bit.Finance differ from ERP?

Middle+

2gis

Did you do the testing yourself or did a tester do it?

Tell about yourself and your recent work experience.

Middle

СБЕР

To select clients from the Customers table who have at least one order in the Orders table, which query will do this correctly? SELECT * FROM Customers WHERE id = (SELECT customer_id FROM Orders); SELECT * FROM Customers c JOIN Orders o ON c.id = o.customer_id; SELECT * FROM Customers, Orders WHERE Customers.id = Orders.id; SELECT * FROM Customers WHERE id IN (SELECT customer_id FROM Orders);

Middle

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

You mentioned mega services responsible for something. What exactly?

Middle+

СБЕР

How to solve the interaction problem of 100 microservices? What is an API Gateway and what does it do?

What does the HAVING operator do?

Middle

Bell Integrator

Have you used Requirements Yogi in Confluence?

Tell us about yourself, what have you worked on, what are you considering now, why are you looking?

Tell about your experience with integrations. Provide examples.

Middle

2gis

Have you worked with C4 before?

According to which standard did you describe the REST API? How to make POST idempotent?

Middle

СБЕР

Is there anything to add regarding the project? Would you like to highlight anything additionally?

Task: you are a marketplace analyst for selling tables. You need to implement a backend for a detailed information page for a specific table. What integration would you use and what should the analytics contain for the developer and tester?

Middle+

СБЕР

What architectural components should a guitar tuning system consist of?