Python

How does a generator differ from a regular function?

What are abstract classes used for?

At what stage was the Mediasoft project when you joined: from scratch or already launched?

Why does the mutable default argument value in Python persist between function calls?

How do you feel about working with Django a lot? Are you ready to immerse yourself and learn?

Do you need company support to obtain a work permit?

Are you an SME in your current or previous company?

What income level are you aiming for, and what amount would be comfortable?

What salary level are you expecting to transition to?

What is the time complexity and additional memory of the two-pointer solution?

What was the tech stack on the last project?

What is duck typing?

Table Customers: customer_id (INT), customer_name (VARCHAR), country (VARCHAR), signup_date (DATE) Table Orders: order_id (INT), customer_id (INT), order_date (DATE), order_amount (DECIMAL), status (VARCHAR) Task: Write a query to find the total order amount and the total count of orders for each customer from the 'USA' who has spent a total of more than 500 on 'Completed' orders. Sort the results by total order amount in descending order. Expected Output: customer_name (VARCHAR), total_spent (DECIMAL), total_orders (INT)

What kind of team and project would you like to see, what would you like to see?

Have you had experience working with Django?

Tell us about your recent project and the tasks you worked on.

In which areas of Python development do you consider yourself to be the strongest specialist?

Do you have any questions before ending the interview?

What is the difference between a shallow copy and a deep copy (`copy` and `deepcopy`)?

What business problem was the Ajima service supposed to solve?