Sobes.tech

System Analyst

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?

210

What is identification, authentication, and authorization? What is the difference?

206

Do you know the difference between synchronous and asynchronous communication?

205

What is a two-tier and three-tier architecture? What are the pros and cons?

199

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

199

Tell me how you managed to combine studying and work, did you graduate with a bachelor's degree in 2026?

194

Расскажи, для чего нужна связь один-к-одному между таблицами, почему нельзя просто объединить данные в одну таблицу (в том числе с точки зрения безопасности)

190

How to determine which part of the functionality should be moved from a monolith to a separate microservice?

190

Tell me about the configurations you've worked with, and the subsystems involved.

188

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.

186

Tell about a memorable failure of yours and what you learned from it.

184

What would you like to work with? Preferences for projects, teams, stack?

183

Write an SQL query to find the average salary for each department in the employees table.

183

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.

182
/4