System Analyst

Have you conducted interviews with clients? How did you prepare?

Is REST synchronous or asynchronous interaction?

What is the difference between callback and webhook?

Where do you keep documentation?

What documentation do you collect to hand over a task to development? A full list.

Are you familiar with working with Postman? What do you use it for?

Do you really want to be a systems analyst, considering you have performed functions of Team Lead, Project Manager, and Product Owner?

Tell us about yourself and your experience as a systems analyst

What types of relationships do you know and how to implement a many-to-many relationship?

What is the difference between SELECT COUNT(*) and SELECT COUNT(column) FROM table?

Have there been conflicts in requirements among stakeholders? How were they resolved?

What experience do you have with SQL? JOIN, window functions, aggregate functions? Do you write the queries yourself or through developers?

What is the C4 Model and what levels does it consist of?

Provide examples of normalized and non-normalized data from practice

Name the 4 main properties of transactions (ACID)

Do you update documentation after feature implementation or project completion?

What are the two main types of UML diagrams?

Tell us about your experience working at Mars and the projects you have been involved in.

What types of integrations have you worked with? Experience with synchronous and asynchronous interactions?

What is the difference between validation and verification of requirements?