Do you have experience designing asynchronous interactions via REST?
System Analyst
Name the main types of JOIN operators in SQL language
What non-functional requirements do you consider when designing an email sending system?
Where to store access and refresh tokens in a mobile app and on the web?
In which tool do you draw sequence diagrams? How to display multiple scenarios (success, errors, timeout) on one diagram using frames?
Which HTTP method would you use to obtain user data? Why can't confidential data be transmitted via GET?
Is audit the recording of a sequence of events that occurred in the system?
Are you there? Are you available?
Have you worked with version control systems?
Describe the attribute composition of the main database tables of the library at the top level.
How does document upload work in the system — where are they uploaded and how are they processed?
What SQL query should be written to list all users who did not place an order throughout the year?
What storage systems and message brokers have you worked with? How does Kafka differ from RabbitMQ?
Design a REST API service for a book catalog with filtering by author and title. What method would you choose, and what parameters?
Can you give an example of a race condition?
What is the main problem in structuring requirements in this case? - No clear performance metrics - Requirements should be clearly separated for easier analysis and implementation - Data analysis does not consider all scenarios - Encryption methods are not defined - Security requirements are not highlighted separately - No structure for styling requirements
How do you evaluate your communication skills with the business? Were there difficult situations?
What does Git allow you to do?
Have you used Kafka/RabbitMQ for stream processing in a project? What exactly did you do?
Describe the unhappy flow scenario of OTP authorization (phone or email in one field). What errors are possible, and how to describe them?