System Analyst

What exactly do you want to see in the documentation plan and how would you structure it?

What are indexes and what are they used for? How do indexes appear in a database?

Middle+

СБЕР

Describe your process for setting development tasks (API, databases, integrations).

What is the difference between a GET request and a POST request?

Middle+

Билайн

What do sections of a technical assignment contain: business requirements, functional requirements, non-functional requirements?

How can a many-to-many relationship be established in a relational database?

What can be used to create a 'many-to-many' relationship in a relational database?

What tasks were related to Kafka and what was described through integration via the broker?

If we realize that we are a good match, how quickly will you be ready to start?

Why are you not accepting the existing offers anymore? What do you look at first when choosing?

Do I understand correctly that your location is Moscow and citizenship is RF?

Do you need to have the following skills? Choose the competencies that seem mandatory for the position. You can select multiple options. - Confidently manage project management tools (Jira, Confluence, etc.) - Know Agile, Scrum, Kanban, Waterfall methodologies and understand their differences - None of these skills are required for my role - Be able to work with large volumes of data - Be able to model business processes to-be

Why are partitions needed in Kafka and how do they work?

What is caching?

Do you calmly develop FT (functional-technical requirements) without comments from development?

Situation: Release war! What are your actions? Tomorrow, a large-scale advertising campaign for a new credit product with influencers on the CPA platform is launching, and the advance payment has already been made. It turns out that the developers have not had time to implement full server-side (S2S) event verification with AppsFlyer. The CPO demands to implement sending the credit approval event directly from the client (from the Flutter app) to 'somehow optimize the campaign.' The analyst is categorically against it: sending financial events from the client in fintech is a direct road to fraud (hackers can easily forge requests) and guaranteed chaos in the DWH. The company's stance on such risks is vaguely outlined in regulations: 'minimize risks but achieve business goals.' CPO's interests: Launch the campaign on time at any cost. If the release is delayed, a huge budget will be wasted, and the KPI for attracting new borrowers for the quarter will be missed. Ready to go for a 'temporary workaround,' promising to rewrite it in the next sprint (which, as everyone knows, rarely happens). FSA's interests: Protect data architecture and prevent the company's money from being lost due to fake conversions. The analyst understands that if bots inflate budgets by millions due to a security hole, he will be responsible for incorrect data and losses. He demands to postpone the start or change the tracking mechanism. Timing: 5 minutes.

Are there any proposals on hand now? Will there be a need for processing?

Are you familiar with the Offline First approach?

Middle

Wildberries

How does basic authorization (Basic Auth) work?

Middle

СБЕР

Do you use UML sequence diagrams or only Activity Diagrams?