System Analyst

What is the one-to-many relationship between a legal entity and a contract called?

What is the fundamental difference between REST integration and message brokers?

Which type of integration would you choose for this scenario and why? 5000 requests per day load.

What non-functional requirements can be considered for REST integration?

What sections of the technical assignment would you specify for REST integration and what would you write there?

Task Managers supporting the Acquiring contract have their own Automated System: the Legal Entity Support System. The Legal Entity Support System requires data on acquiring contracts from the Acquiring System. Design this integration solution.

Load: 3 RPS and 5000 requests per day. How to handle the case when the contract is not found or the acquiring is unavailable?

What notations do you mainly work with?

Clarification: search by contract number, not by ID

How do you join a legal entity table with a contract table? What can be used to select contracts by legal entity?

Describe the GET request contract for searching for a contract.

What integrations do you know? If you haven't worked with them personally, what other types might exist theoretically?

How would you redesign the integration if it was found that: the contract number is not unique (50-100 duplicates), acquiring is slow, and search takes 3-5 minutes?

Write an SQL query to select all contract attributes with number 123 from the contract table.

What are the alternative scenarios and failures that can occur across the entire integration chain?

Design an ER diagram: a legal entity has many contracts, a contract has many retail outlets.

Explain the mechanism of connection through primary and foreign keys between the entity and contract tables.

The query takes a very long time to execute. What can be done to make it faster?