Should a systems analyst be able to program?
System Analyst
What fields should be in the promo_codes table?
Are the system's results exported somewhere?
Tell us about your experience designing databases. What documents did you prepare and what did they describe?
Contract descriptions — only in business language or also in OpenAPI (JSON, mandatory, patterns)?
What do you look for when job hunting, what criteria are important?
Write an SQL query to select active promo codes sorted by discount value in descending order.
What is a topic and a partition?
What format did the input tasks come in? What was it? A discussion, a brief description of the initiative, business requirements?
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?
In what form were the task assignments made to developers?
At what point is a task ready for handover to a developer?
Tell us how services interacted between your projects.
Why use gRPC if there is REST? What is its essence?
How detailed were the tasks described to you?
How do you gather business requirements?
What is a trigger in a database?
Logical puzzle about a watermelon: a watermelon weighs 10 kg and is 99% liquid, after drying the liquid it becomes 98%. How much does the watermelon weigh now?
Will you have the opportunity to re-enter the meeting and connect with the settings again?
Where is the API version usually registered?