Java

When is it better not to use parallelStream?.

Senior

IT One

List the types of inter-service communication.

What to do if the database is loaded at 99% CPU? How to analyze the incident?

Is it possible to evaluate query performance without executing it?

Tell about your experience working with financial/transactional services.

Tell about your current workplace: how responsibilities have changed, what was the initial functionality, what is now, what does the team look like?

Senior

Wildberries

What is Collections.unmodifiableList() used for and what does it do?

What were you able to influence in the architectural decisions on your last project?

What Spring tools are used for working with streams?

Senior

СБЕР

What are partitioning, replication, sharding?

Senior

СБЕР

Why specifically Transactional Outbox — since it could have been done differently, for example, committing to Kafka only after successful sending?

Middle

ООО ИЦ Ай-теко

Tell me about yourself, what have you been doing in the last 2-3 years?

Senior

Альфа-Банк

-- There are tables with the following structure Employee id (PK) name salary dep_id(FK department.id) Department id (PK) name -- write a query that returns a list of all department names with the maximum salary in each department select d.name, MAX(e.salary) from Department d left join Employee e on e.dep_id = d.id group by d.name

Senior

СБЕР

How does the @Lazy annotation work under the hood?

How does Postgres implement ACID principles by default?

Transform a list of objects with fields k and value into a Map using Stream API so that data is not lost (k can repeat)

What databases have you worked with?

What is the difference between soft and hard references?

Middle+

DNS

What are your red flags — what would you definitely not want to work with?

Why did you leave MegaFon?