System Analyst

What types of integrations have you worked with? Experience with synchronous and asynchronous interactions?

What are the two main types of UML diagrams?

What is the difference between validation and verification of requirements?

Write an SQL query: there is a clients table and a blacklist table with an id field. You need to select all clients who are not in the blacklist. Offer several solutions.

How do you communicate requirements for development? Do you use diagrams, texts, prototypes?

How would you implement the Event Sourcing pattern?

What questions do you have about the vacancy and the team?

Practical case: a food ordering app, when creating an order, the internet flickered, the user clicked twice, and two orders were created. What is the reason and how to fix it?

Have you worked with NoSQL databases or caching?

What message brokers have you worked with? Kafka, RabbitMQ?

What technology stack was the MES system built on? Describe the architecture.

What is the difference between identification, authentication, and authorization? What comes first?

Can REST be made asynchronous? Provide examples.

Why can't you use only GET requests to build a system? What are the limitations of GET?

How is integration with hardware and data collection from sensors organized?

What tools have you used for log analysis?

What types of relationships exist on a sequence diagram?

Is there experience in describing integrations? REST, SOAP, Swagger, Postman?

Is it possible to implement deletion using the POST method and why?

Why are relationships between tables used in relational databases?