Salesforce Backend Software Engineer -Mid-level/Senior interview questions

The call with the R&D VP: personal question about my work and challenges and how I got over them... The live coding interview: Write Java code for implementing a system with multiple databases representing faculties from different universities, where each student is described in one DB. The system will receive a large amount of data on students' IDs and their faculties and needs to fetch the data from the scattered databases efficiently. The design interview: 1. Design how to add UPDATE/DELETE to a DB that only has INSERT capabilities. 2. Design a system that has 3 data storage instances (DB, S3, and data warehouse), and needs to get an "export all" trigger from the user and then zip all the available user data from the different 3 storage instances and send a URL to the user where they can find the exported data. The director interview: The final interview was meant to be personal as I said, and the main intention of it was to meet me in person and give me the opportunity to explore the office as well. Actually, the 45-minute interview included also a small design question where you need to design a microservice that fetches data from different providers (like Facebook and Twitter..) using API calls and then extracts the data into reports for the customer (actually this is one of the systems of Salesforce called Dataroma)