Java

What salary expectation are you considering for the offer?

Senior

Wildberries

What alternatives to the Outbox Pattern exist?

Каким образом TreeMap self-adjusts для обеспечения сбалансированности и эффективности работы?

Middle — Middle+

Банк Россия

Why are you currently looking for a job?

Senior

СБЕР

When you perform a regular SELECT, how many queries does the driver send to Postgres? What are these queries and what will be there?

[name] asked: If the topic has 100 partitions and the @KafkaListener annotation specifies concurrency=10, will 90 partitions be idle?

table student id PK name faculty_id table faculty id PK name SELECT f.name, count(*) FROM faculty f JOIN student s ON s.faculty_id = f.id GROUP BY f.id, f.name GROUP BY /*f.id,*/ f.name GROUP BY f.id/*, f.name*/

Middle+

Иннотех

Why is the finalize() method needed?

Senior

СБЕР

Can you explain what ExecutorService is and how it is used to manage threads?

Junior — Middle

СБЕРСБЕР Бизнес

What is the difference between map and flatMap in the Stream API?

What is important in a new workplace — project, tasks, stack, team?

Middle+

Яндекс Маркет

- list the names, with the first column showing the name, - the second column showing the number of visitors with that name, - the third column showing the number of visitors with that name and older than 27 years - sort by name in ascending order (A-Z) SQL code example: ```sql create table customers ( id int, name text, age int ); insert into customers values (1, 'John', 20), (2, 'John', 20), (3, 'John', null), (4, 'John', 37), (5, 'Jane', null), (6, 'Bob', 13), (7, 'Bob', 99); SELECT name, COUNT(*) AS total, COUNT(CASE WHEN age > 27 THEN 1 END) AS older_27 FROM customers GROUP BY name ORDER BY name ASC; ```

Tell about your current project at [company] — what are you doing?

Senior

СБЕР

What is effectively final in Java and where is it used?

Senior

Альфа-Банк

[name] asked: what databases have you worked with? Postgres, Redis — that's clear, but what about non-relational ones like MongoDB or others?

Question 4. What is JIT compilation? - Compiling code into a jar file - Compiling bytecode into machine code during program execution - Compiling JavaScript into machine code for performance optimization - Compiling a project in a git pipeline

Have you ever explained to a client or analyst why a task takes 2 days instead of 10?

Senior

ОТП Банк

Provide an example when it is not necessary to use microservice architecture, and name a couple of reasons.

Senior

Альфа-Банк

How are you generally with DevOps technologies — Kubernetes, CI/CD, and others?

How to display all departments including Accounting? What will be in max_salary for Accounting?

Senior

СБЕР