What are your strengths and how do they manifest in your work?
Middle
161
System Analyst
2753
0
Is a linking table needed between users and promo_codes?
Middle
160
Is it correct to attach an index to each column of a large table? What are the features?
Middle
160
What are the functional requirements besides user story and use case?
Middle
160
What criteria do you use when choosing an HTTP method?
Middle
159
Have you worked with SQL? At what level?
Middle
159
select * from a inner join b on a.a=b.b
Middle
159
How do your team conduct grooming sessions?
Middle+
159
What changes are required in the API when adding promo codes?
Middle
158
If you need to filter data by many parameters, how would you implement such an API?
Middle+
158
A system drops events to Kafka with business data, and you need to fetch this data. What will you write in the description?
Middle
158
What is a message broker used for?
Middle
158
Design a solution for a book reservation webpage in a network of bookstores: select city and store, list books with filtering, reserve by phone number, notify via SMS. Describe functional requirements, build an ERD diagram, write an SQL query, and a JSON response.
Middle
158
Tell me more about configuring system prompts for e-chat. Structured, without fluff.
Middle
158
What HTTP response codes would you suggest for this API and when are they used?
Middle
158
Can you sketch a simple example of an OpenAPI specification for an API that returns the risk segment value based on the client ID?
Middle+
158
Besides the idempotency key, what other ways are there to ensure idempotency?
Middle
157
What will be transmitted in the body of the POST request for confirmation?
Middle+
157
If the UUID is valid but the client is not found in the database — what will the API return?
Middle+
157
Tell about your experience designing data models. Have you ever developed a data model from scratch?
Middle
157