System Analyst

Tell us about your professional experience and projects you have participated in.

Draw a conceptual ER model for an incident accounting system (explosions, floods) and their zones of damage (minor, medium, severe destruction), which objects (buildings, factories, schools) fall into.

Есть таблица заказов с полями: id заказа, id клиента, статус, дата создания. Куда логично повесить индекс?

How is PATCH related to caching GET (the problem of cache staleness after changes)?

Do you have experience working with SQL and stored procedures?

How was the business process audit conducted? How was it done specifically?

Provide a specific example when LEFT JOIN needs to be used.

What is the ratio of business to system analytics in your work?

1. The developer asks you to hide problems that occur in the application processes because discussing them will only make things worse. What are your actions? Timing: 1 minute

What is the main difference between partitions and indexes?

Which vacations are not included in the length of service that entitles you to annual leave?

What did you do before working in analytics?

How would you depict errors and alternative scenarios in a Sequence Diagram?

Tell me about improvements in accounting. Share the most complex case.

Do you perform testing of external APIs to ensure that the specification matches reality? Do you create end-to-end scenarios in Postman?

Do you use standard HTTP statuses or do you have custom ones? How do you feel about a situation where the response has a status 200, but contains an error inside?

What are functional and non-functional requirements in this case?

Senior

Альфа-Банк

How is parallel accounting conducted in ERP for profit tax? How does it differ from accounting?

What was the trigger that made you enter the market?

What do you want from work? What do you prefer to do?