I was contacted by an internal recruiter on LinkedIn.

The initial phone screening involved some basic questions about SQL and Python, followed by a technical challenge.

The challenge consists of two SQL queries and two Python-based tasks. It was somewhat difficult and time-consuming.

Next, there was a two-hour technical interview.

The first part asked general Python/SQL and software engineering questions.

The second part involved designing a system for an API with two banking services.

If you don't have experience in large-scale systems, I suggest doing quite a lot of research on the subject.

Hopefully, this review will be helpful to someone.

Differences between multithreading, multiprocessing, and concurrency.

Difference between a SQL and a columnar database.

When to use OOP and when to use functional programming.