Tell me about technically complex things at Magnit. What was interesting there?
Python
Do you have experience with ML models? Have you used LLM tools (Cursor, Claude Code) in your work?
What is a deadlock?
What file permissions exist in Linux? What can be done with them?
What happens in asyncio.gather() if one of the tasks raises an error? How can you prevent exceptions from being lost?
The pen started responding in 3 seconds instead of 80 ms. How would you localize the problem? What is the sequence of actions?
Do you use the Go language in your development?
Tell me about ACID. Especially about transaction isolation levels. Which level did you use?
Tell about the processes, threads, and asynchrony in Python. How do they differ?
How are JOINs performed on the PostgreSQL side? What strategies exist?
Tell about the transaction isolation levels in PostgreSQL and why they are needed.
What is a context manager, why is it needed, and how to create your own?
[name] tell us about the mechanism of asynchrony in Python: what does it look like, where is it good, where is it bad, why was it invented?
Tell about asynchronous processing via Kafka: what data was transmitted, what keys were used, how was the order of processing ensured?
What was the basis for determining the intent and where to redirect the user in your bot?
How does asyncio.create_task() differ from await coroutine? When will a task execute without await?
How long does it take to insert N different strings of length K into a set?
How did you find out that something was breaking or degrading? What did you look at?
CREATE TABLE products ( id SERIAL PRIMARY KEY, category VARCHAR(100) NOT NULL, name VARCHAR(255) NOT NULL, description TEXT, price DECIMAL(10, 2) NOT NULL CHECK (price >= 0) );
System setup and instructions for replacing Pinkman mentions with targetAI.