Sobes.tech

System Analyst

Do you have experience designing asynchronous interactions via REST?

247

Name the main types of JOIN operators in SQL language

247

What non-functional requirements do you consider when designing an email sending system?

Middle
246

Where to store access and refresh tokens in a mobile app and on the web?

Middle
246

In which tool do you draw sequence diagrams? How to display multiple scenarios (success, errors, timeout) on one diagram using frames?

Middle
246

Which HTTP method would you use to obtain user data? Why can't confidential data be transmitted via GET?

245

Have you worked with version control systems?

Middle
245

Describe the attribute composition of the main database tables of the library at the top level.

Middle+
245

How does document upload work in the system — where are they uploaded and how are they processed?

Senior
245

What SQL query should be written to list all users who did not place an order throughout the year?

244

What storage systems and message brokers have you worked with? How does Kafka differ from RabbitMQ?

Middle
244

Design a REST API service for a book catalog with filtering by author and title. What method would you choose, and what parameters?

244

Can you give an example of a race condition?

Senior
243

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

243

How do you evaluate your communication skills with the business? Were there difficult situations?

Middle
243

What does Git allow you to do?

Middle
243

Have you used Kafka/RabbitMQ for stream processing in a project? What exactly did you do?

Senior
242

Describe the unhappy flow scenario of OTP authorization (phone or email in one field). What errors are possible, and how to describe them?

Middle+
242
/137