Tell us about your experience working with Go: did you develop services in Go yourself or mainly work with existing ones? What fixes did you make?
Python
Tell about your experience deploying and configuring CI/CD.
How to solve the same problem without Redis and without increasing the service memory: how to pre-process analytical data using PostgreSQL?
What does asyncio.gather do and after how long will it return a result if two async functions run for 5 and 15 seconds respectively, but only contain CPU-bound calculations without await?
How to speed up filtering analytical data by days without indexes, by pre-creating a table using PostgreSQL?
Do you see any difficulties working with external marketplace API limitations, such as rate limit and HTTP 429? Are you comfortable working in such an environment?
What methods of optimizing SELECT queries in PostgreSQL do you know besides indexes?
LeetCode #? — The client complains about a slow sales analytics endpoint: a complex SQL with multiple JOINs and calculations that can take over a minute. A data freshness delay of 5–10 minutes is acceptable. What is the simplest solution you would suggest?
Tell us about the team and services you have developed, maintained, and supported.
How comfortable are you working with PostgreSQL and raw SQL instead of ORM, such as SQLAlchemy?