Python
Did you work directly with PostgreSQL or through ORM?
Are you working right now?
At what stage was the Mediasoft project when you joined: from scratch or already launched?
What generally happens when creating a variable in Python, what does it have?
Did the ML service perform data enrichment from external sources and run the model internally, or were these functions divided between services?
What is Clean Architecture, what are its main principles, and how does it compare and contrast with other architectural approaches?
Are you satisfied with the proposed further process: send CV and answers by email, then book a short call for preparation?
What is the difference between shallow copy and deep copy?
Tell us about working under very tight deadlines: were you able to complete the task on time and how did you overcome the difficulties?
What databases have you worked with?
What types of VACUUM exist in PostgreSQL and what are they used for?
What is the complexity of searching for an element in a Python list?
How to avoid cache collision between different functions that are called with the same arguments, for example add(2, 3) and multiply(2, 3)?
What are SQL window functions?
What was the added value of your scoring platform, considering that the profile service and ML service performed part of the work?
What is GIL (Global Interpreter Lock) in Python?
How does `dict` work in Python?
Tell us about your experience: on which projects you worked at [company] and [company], what technologies you used, and what you were responsible for?
What are the disadvantages of asynchronous code?
How did the system work before transitioning to event-driven/Kafka: was it REST API on FastAPI?