System Analyst

What is a Constraint in a database?

Why are both methods (PUT and PATCH) needed if PATCH can be used for full updates?

What other interaction protocols/standards between systems do you know besides REST and SOAP?

What is included in a Word document with requirements (technical specification)?

Why is POST suitable for authorization, and why is GET not suitable?

What HTTP methods are included in REST API?

What is a User Story?

How do you document your work (Excel, Word, Confluence)?

Is caching provided in REST API? Which methods are cached?

What options for asynchronous interaction between systems can you suggest?

What are indexes in a database used for? How do they speed up search?

What is the role and function of a Callback?

Do you have experience working with message brokers? Which ones?

What are the differences between RabbitMQ and Kafka?

How is PATCH related to caching GET (the problem of cache staleness after changes)?

How prepared are you for a situation where the client (government) may suddenly change requirements without justification?

What is a query execution plan in a database? What is it used for?

How exactly did you use OpenAPI, what were the requirements?

What methods of optimizing a microservice under high load can you suggest?

How does vertical scaling differ from horizontal scaling?