Java

How does one determine which index to create to optimize database performance?

Junior — Middle

Самокат

How well do you know SQL?

What is important for an effective daily stand-up? How should it be organized?

Senior

СБЕР

What overhead does Kafka have for idempotent sending? What does Kafka sacrifice in this case?

SELECT FROM A RIGHT JOIN B — how many records will be returned if A has 10 records and B has 100 records?

Please tell about the technology stack you used.

What caused the latency to drop from a second to 300 milliseconds?

What is data normalization in Postgres and why is it needed?

What project did you work on at [company] and why did you leave?

table employee id bigint PK not null employee_name varvhar(100) not null employee_number int4 not null id; employee_name; employee_number 1000; Ivanov; 123 WITH ordered AS ( SELECT employee_number, LAG(employee_number) OVER (ORDER BY employee_number) as prev_number FROM employee ) SELECT prev_number + 1 as missing_number FROM ordered WHERE employee_number - prev_number > 1; 1000; name1; 1 1001; name2; 2 1002; name3; 4 1003; name4; 5 with ordered as () select * from ordered

Middle+

Иннотех

Have you encountered the problem of distributed transactions? Tell us about the Saga pattern.

Senior

СБЕР

Was there a Project Manager role in the team? How did he participate in the process?

Where did the figure 35K come from, and how was it calculated?

Как вы оцениваете эффективность использования story points по сравнению с оценкой в часах?

Have you worked on an Agile methodology project? What meetings were held in the team?

Tell us what you did at your last job and why you decided to leave.

Tell me about your real-world experience with GC optimization — were there pauses lasting tens of seconds, and how did you optimize them?

Senior

VK

What methodologies did you work with?

What happens to working copies during git reset?

Как у вас была устроена коммуникация с аналитиками или product owner?

Senior

СБЕР