ERP Consultant

What is SELECT FOR UPDATE? What is it used for, have you worked with this construct?

Tell about transaction isolation levels. Which ones have you worked with, and how do they differ?

How to store enumerable values in a string column of a database using a separator and work conveniently with a collection in code?

What multithreaded collections do you know?

Did you work with Kafka through Spring or directly?

How did you work with testing in Go? Did you work with mocks?

What types of sagas do you know?

What guarantees of message delivery do you know in Kafka?

What is a context in Go? What is it used for, what types are there, and what patterns exist for working with it?

Is there a difference in the order of defining fields in a composite index? For example, there is a composite index (name, surname), but the query only has surname — will the index be used?

What is the slowest delivery guarantee level in Kafka?

What are Virtual Threads? How do they differ from Green Threads? When is it better to use them?

How to implement the Inbox Pattern on the Notification service side to guarantee message processing?

public class Main { public static void main(String[] args) { System.out.println("Hello World"); } } -------------------------------- @SpringBootApplication @RestController @RequestMapping("/tasks") public class Main{ private final List<Task> tasks = new ArrayList<>(); private final AtomicLong idGenerator = new AtomicLong(1); public static void main(String[] args){ SpringApplication.run(Main.class, args); } @PostMapping @ResponseStatus(HttpStatus.CREATED) public Task createTask(@RequestBody CreateTaskRequest request){ Task task = new Task(idGenerator.getAndIncrement(), request.title()); tasks.add(task); return task; } @GetMapping public List<Task> getAllTasks(){ return tasks; } public record CreateTaskRequest(String title){ } public record Task(Long id, String title){ } }

What is the difference between the Executor interface and ExecutorService?

What is exactly-once semantics in Kafka? Does it really provide absolute guarantees?

How was the work with databases carried out in the projects — through ORM or native tools?

Tell us a little about yourself and your experience.

How did you implement the Outbox worker — did you write your own polling or use an infrastructural tool?

What is a servlet? What is a servlet container? Which popular containers do you know?