Golang

What are composite indexes and does the order of columns matter?

How was the team organized? How many people were there, and how were they divided by domains?

Tell about the main data structures in Go.

In which cases does it make sense to use an index?

Tell about working with Docker and Kubernetes: what have you had to do?

Tell us about MVCC (Multi-Version Concurrency Control) in PostgreSQL.

What is meant by load redistribution?

Tell us about the most interesting project/task you have worked on

How was your work with Kafka organized? How did you use consumers, consumer groups?

How did you collect and store data for anti-fraud (where did the data come from, how was it done)?

What is the difference between slices and arrays in Go?

Tell me about the Go scheduler (GMP model)

What is a channel in Go? What are channels used for?

You read events in batches and write to ClickHouse in batches. How does this work with ACK — when do you give the acknowledgment?

Why did you use both Kafka and gRPC simultaneously? Which scenarios used Kafka, and which used gRPC?

If one of the services is unavailable during enrichment (for example, the service with the user's full name/data), what happens? Does the entire Kafka stop?

How should you handle the case when an article exists but had no views today — is it an error or zero?

Tell about optimistic and pessimistic locking. How do they differ?

For a boolean field — should an index be added?

How does Go decide to allocate memory on the stack or heap? Why is this important?