System Analyst

What would you choose as a userId when designing a database?

What is the difference between WHERE and HAVING in SQL?

Have you worked with caching on the frontend and backend?

How is asynchrony shown in BPMN?

How does BPMN differ from UML?

What is the difference between an access token and a refresh token?

What is the difference between a regular array and an associative array in JSON?

What methods of API authorization do you know?

What message brokers have you worked with?

How to ensure backward compatibility when releasing a new version of a mobile app?

How to determine the number of partitions in Kafka?

After forming and agreeing on requirements, what is next? What should be the result of the analyst's work?

How many partitions are needed for a consumer group?

Am I correct in understanding that you are a full-stack analyst — both business and systems analysis?

Have you worked with Redis? What is it used for and what type of database does it belong to?

What is Kerberos? Have you worked with it?

How to display loops and branching in a sequence diagram? What are frames?

What is a data bus (ESB) as a type of integration?

What types of tokens do you know?

What are the differences between Kafka and RabbitMQ?