There is a need to load a large volume of data from an external system into ERP — 5-7 million records per month. Where is it better to record: in the document's tabular part, in the information register, or in the directory?
System Analyst
What models of message transmission and delivery exist?
What is identification, authentication, and authorization? What is the difference?
Do you know the difference between synchronous and asynchronous communication?
Tell me about composite indexes, what is their feature?
What technology stack have you worked with before?
What is a two-tier and three-tier architecture? What are the pros and cons?
What are functional and non-functional requirements in this case?
Tell me how you managed to combine studying and work, did you graduate with a bachelor's degree in 2026?
Расскажи, для чего нужна связь один-к-одному между таблицами, почему нельзя просто объединить данные в одну таблицу (в том числе с точки зрения безопасности)
How to determine which part of the functionality should be moved from a monolith to a separate microservice?
What ways of scaling databases do you know?
Tell me about the configurations you've worked with, and the subsystems involved.
Design a data structure for a banking system: a client can have multiple cards (debit, credit), each linked to an account, and clients can also have accounts without cards. Use three tables.
Tell about a memorable failure of yours and what you learned from it.
What would you like to work with? Preferences for projects, teams, stack?
Write an SQL query to find the average salary for each department in the employees table.
Why are you entering the market now, considering job offers?
Design a fault-tolerant payment processing system architecture so that when the bank gateway fails, users do not see 500 errors, but payments are guaranteed to be processed.
What would a request URL with filtering parameters look like?