Company : Adobe
Role : MTS2
Years of experience: 2.5

Here how it went

Round1(DSA):
Ques1 : 1 DSA question based on searching in infinite array - O(logn) expected TC
Ques2 : Cant remember
Asked about previous expereince and Database internals

Round2 (DSA):
Ques1 : https://leetcode.com/problems/largest-number/description/ -> without .sort() method , expectation was to implement merge sort with custom merging logic
Ques2 : https://leetcode.com/problems/trapping-rain-water-ii/description/

Then was asked 2 SQL queries and past experience

Round3 (LLD):
Was asked to give lld of a car rental system -> expectation was schema design, modular code and in deapth implementation of 2-3 features

After writing the schema was asked 2-3 queries based on the schema written

Round4( Managerial round)
Was asked about past experience along with HLD of current project and challenges faced then one DSA question
Find LCA in N- array tree -> gave eulerian tour approch

Then was asked to design a schema of complex scnerio

Got Call from recuriter that i was selected, will add compensation details soon