Java

Will you be in Moscow or Saint Petersburg during the registration process?

Middle+

СБЕР

package ru.tbank; @Service public class OrderService { @Autowired private OrderRepository orderRepository; @Autowired private CacheService cacheService; public Order findOrder(Long orderId) { Order order = cacheService.get(orderId); if (order == null) { order = orderRepository.findById(orderId).orElse(null); if (order != null) { cacheService.put(orderId, order); } } return order; } }

Middle+

Т-Банк

How to lock a database record so that no one else can make conflicting changes?

Middle+

Т-Банк

Is Moscow or another location relevant for you?

Middle+

СБЕР

Tell us about your experience: in what major and interesting tasks, especially integration ones, have you participated?

Middle+

Т-Банк

Are you considering registration as an individual entrepreneur?

Middle+

СБЕР

How does the nested @Transactional annotation work if the inner method is in another service?

Middle+

Т-Банк

In what form did the requirements for the tasks come to you?

Middle+

Т-Банк

How actively are you currently considering offers? Are there offers, deadlines, or are you only at the technical stage?

Middle+

СБЕР

What happens if cacheService crashes or Redis returns a timeout, and how to handle it?

Middle+

Т-Банк

Have you had to write unit and integration tests, and how did you do it?

Middle+

Т-Банк

Briefly tell about your work experience.

Middle+

СБЕР

If the cache times out and requests start flooding the database, how can you reduce the load on the database?

Middle+

Т-Банк

Have you worked with PostgreSQL and query optimization?

Middle+

Т-Банк

Provide an example of a large business task or integration that you completed entirely on your own.

Middle+

Т-Банк

What problems can arise when returning a JPA entity from a repository and how to avoid them?

Middle+

Т-Банк

If monitoring shows that the database has started responding slowly, how will you investigate the cause?

Middle+

Т-Банк

What technologies and stack have you most frequently worked with?

Middle+

Т-Банк

How do you analyze execution plans and optimize PostgreSQL queries?

Middle+

Т-Банк

What grade of position are you considering?