System Analyst

How do you see your further professional development, what do you aspire to?

Is SELECT a summing aggregate function?

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?

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

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

What is SOAP, how does it differ from REST, and where is it used?

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?