Python

How is data transferred between separate processes in a system?

Can you explain what recursive queries in databases are and how they work?

What function did OpenCV perform in your project?

What are indexes and what are they used for? When should and shouldn't you create an index?

Middle+

СБЕР

What approaches can be used instead of the JOIN operator to combine tables in SQL?

Can you provide an example of using an anonymous function (lambda) in your code?

Junior — Middle

ООО Корпорация ЗНАКЛига Цифровой Экономики

How can you determine the HTTP request method in an application using FastAPI?

Junior — Middle

СБЕР

How to determine if a specific character (for example, the character A) can be discarded when narrowing the window from the left without losing alphabet coverage?

Intern

Яндекс

Who manages thread switching in the implementation of GIL in Python?

Which team or project are you most interested in working on and why?

Can you give an example of a situation where ignoring a variable or factor that can change leads to a logical error?

How can access to private class members be implemented from outside its definition?

What attracted you to the field of server-side application development?

What are the advantages and possible disadvantages of using FastAPI for web application development?

What potential difficulties may arise when using multiple inheritance in programming?

Junior — Middle

СБЕР

What are the advantages and disadvantages of using magic methods in Python?

Junior — Middle

СБЕР Центр ИИ

How can you identify and stop a hanging Python process with a single action?

What technologies and strategies are used in automatic memory management in garbage collection systems?

When might an optimizer not use an existing index?

What goals and directions for professional growth do you plan for yourself in the future?