Golang

Tell about your latest work experience: company, stack, tasks.

How to add a uniqueness constraint on a combination of two columns in PostgreSQL, where individual values can repeat, but pairs cannot?

What problem can occur with sending events to the message broker and how to solve it?

Middle+

Купер

Did the service simply distribute data from the cache, or did it perform some other logic?

What programming language do you work with? Why did you encounter difficulties with the syntax?

How are blockchain and the CAP theorem related? Is blockchain always available?

Senior

Лига Цифровой Экономики

Task: What will the code output? ```go package main import "fmt" func main() { a := []int{1, 2, 3, 4, 5} b := a[:2] b = append(b, 100) fmt.Println(a, b) } ```

Middle+

МВидео

Is it possible to enable a profiler in production?

Senior

Лига Цифровой Экономики

Which package was used to create mocks?

What other types of indexes exist in PostgreSQL?

Tell me about a complex technical problem that you have managed to solve recently.

Senior

Рамблер

Tell me, why did you decide to look for new projects and what kind of development would you like?

Is there a difference between a non-buffered channel and a buffered channel with size 1?

Middle+

СБЕР

Do you have Russian citizenship, military registration documents? Is IT accreditation important?

Middle+

OZON

What concurrency issues arise when calling Get and Set methods from different goroutines? How can they be resolved?

Tell us about goroutines and how they differ from operating system threads.

What command would you like to see at a new place? Are there preferences for composition, roles?

Is anti-fraud a single large service or part of a larger system? How does it interact with other services?

How does a relational database differ from a non-relational one?

You mentioned you had a service that listens to Kafka and updates the cache in Redis, right?