Speed 1 Cargo Interview Experience for SDE-1

Round 1:

• Project discussion, Tech-stack, Use cases
• Given 3 tables, user, invoice, and payments, get invoice and payment details of a particular user. User to invoice hand 1 to many relations. Invoice to Payment has 1 to many relations.
• Convert the above problem to API.. what API to Use, Parameters, etc.
• Authentication, sessions, cookies, JWT tokens.

Round 2:

•  Introduction/projects
•  Authentication vs Authorization.
•  Decorators – Use case
•  RDMS vs NoSQL.
•  ACID Properties
•  Serializability
•  List (is call by reference?? )
•  Find the two largest elements in the array
•  Given a list of files, [.txt,.csv,.pdf]. Need to build a parser to convert file data to the dictionary, given you have different parsers for different file types, What Design patterns do you use? Will you use class or functions?