System Analyst

Tell us briefly about yourself — who are you, what have you been doing?

Describe in words the drawn ERD diagram and explain the relationships between entities.

What do you want from work? What do you prefer to do?

What tools have you used to model data structures and processes? What specific diagrams did you draw?

Tell us about the results of a systems analyst's work and how you understand this role in the context of the described company.

Describe step-by-step what happens in the order creation diagram with alternative scenarios.

Why are only some steps numbered (1,2,3,4) on the diagram, while others are not?

How did you optimize SQL queries, and how did the average report time decrease from 11-12 seconds to 9-10?

How did you gather business requirements? What methods did you use?

If this SQL query is run in SQL Developer, will it work or not?

How can free seats for a specific session be determined using the current scheme? Is a separate booking entity needed?

Ask clarifying questions to the client for building an ERD diagram of the ticket booking system (one cinema or a chain, number of halls, session details, user data, etc.)

Comment on the latest conditions for the SQL query — what does WHERE co.operation_date >= DATE_SUB(NOW(), INTERVAL 3 MONTH) mean?

What stages of the development lifecycle do you know? What does a systems analyst do at each stage?

What is the difference between functional and non-functional requirements?

What do you do during the PSI (Acceptance Testing) stage?

Describe step by step what happens in the Order to Delivery Process sequence diagram.

What tasks demotivate you, and what would you prefer not to do?

Why do we need to update the status in our database that the ball is on SAP's side? Why can't SAP update the status itself?