What diagrams and charts do you use in analytics and for which processes?
Middle+
207
System Analyst
2738
0
How to implement an idempotent POST so that it is not semantically identical to PUT?
Middle
207
How did you interact with the architect in projects? Describe the process of agreeing on architectural solutions.
Middle
206
Write an SQL query to get the top 10 most popular books.
Middle+
204
How will the query change if you need to count popularity over a month?
Middle+
204
What is the purpose of database normalization?
Middle
203
What does the interaction between the front end and back end look like when confirming? What HTTP method is called and what is the endpoint called?
Middle+
202
Draw a sequence diagram of the interaction between Frontend and Backend when using a promo code
Middle
202
Can you give an example of data anomaly in a denormalized table?
Middle
202
Tell me about a big task you're proud of — whether it's difficult or just interesting.
Middle
202
If during analysis it turns out that there is not enough data for implementation, what should be done?
Middle+
202
What requirements need to be clarified for starting the development of a money transfer service between users of different banks?
Middle+
202
What do the keys allOf, oneOf, anyOf do in OpenAPI? Explain with an example schema with allOf.
Middle
201
What is your experience with Python? Have you written simple scripts with loops or something heavier — pandas, matplotlib?
Middle
201
Have you had experience conducting research, particularly in improving current products or processes?
Middle
201
You mentioned mega services responsible for something. What exactly?
Middle+
201
How have you interacted with a business analyst and in what format did you receive requirements?
Middle
201
Do you know any patterns of microservice architecture design?
Middle+
200
Does Kafka guarantee message read order consistency?
Middle
200
Please clarify how you worked with tasks: from whom they came, in what form?
Middle+
200