Heard about Transactional Outbox? Why is it needed, what problem does it solve?
Java
How do you feel about a salary reduction of 20–30 thousand rubles during a three-month probation period?
What types of locks exist at the database level?
Have you participated in designing the architecture of a working application?
Have you encountered the problem of distributed transactions? Tell us about the Saga pattern.
The company LLC "Romashka" is represented by the tables employee(id, department_id, name, salary) and department (id, name). List the departments where the difference between the maximum and minimum employee salaries is more than 50 thousand.
How does LLM work? What does it operate on?
Explain the written SQL query: what do we retrieve, how do we retrieve it, why do we filter reaction not equal to 0, how do GROUP BY and ORDER BY work? Tell about JOIN types (LEFT, RIGHT, their differences).
Have you worked on an Agile methodology project? What meetings were held in the team?
Why is the singleton scope chosen by default for beans, and why is creating an object considered an expensive operation?
How do you set a pessimistic lock on a JPA repository method without native SQL?
How to implement hashCode() for a Long type (64 bits) to return an int (32 bits)?
Name 2-3 examples of thread-safe collections.
What are the advantages of monolithic architecture?
Tell us about the MegaFon project, what did you do?
Design task: The Like service writes likes to Kafka, and the Dashboard service should calculate the post ratings. How to establish interaction?
Tell me about Stream API: types of operations, the difference between map and flatMap
Tell me about the SAGA pattern, the two types — orchestration and choreography, and how do they differ?
Tell us about yourself, your experience, what tasks you have solved, and why you decided to leave.
What is an aggregate function in SQL?