System Analyst

Is SELECT a summing aggregate function?

Have you ever designed a data model from scratch? How do you approach this process?

Why did you leave your previous company?

What is database normalization and why is it needed?

What types of registers are there in 1C?

Middle+

2gis

What stage of job search are you currently at?

Tell about database design — three levels (conceptual, logical, physical). How detailed was the physical level?

What is the desired salary level (minimum and comfortable)?

How does the review of analytical documentation proceed and who will cross-review the only system analyst of the team?

[Name] asked: what types of databases do you know?

Description: We develop a web application that is a web page where you can draw polygons. You can modify a previously saved figure. There are no restrictions on color. There are no restrictions on the number of polygons. There are no restrictions on the placement of figures (they can overlap within the page). Task: 1. Describe the data stored in the database. 2. Suggest REST API methods for interaction between frontend and backend.

The interviewer clarified: they meant a specific task, a small one, that you personally solved. Can you give an example?

What databases do you work with?

What is the largest document you have developed? Tell more about it, preferably according to GOST.

Why is Kafka needed and how does it scale horizontally?

In what case would you suggest storing the state of an object not as a document attribute, but as a separate change history?

Middle+

Альфа-Банк

What HTTP methods are included in REST API?

When does the need for organizing a Consumer Group in Kafka arise?

Which company do you work for and for what reason did you enter the labor market?

How do you use LLM — through chat or via API?