I was reached out to by a recruiter and had an initial phone conversation with them.

1st Technical Interview: I was able to answer 4 SQL and 5 Python questions in the allotted time. For SQL, focus on percent calculations (everything else is everyday SQL). For Python, practice easy LeetCode problems or similar ones found on Glassdoor. The turnaround time was awesome; I found out I passed within an hour of interviewing.

Virtual Onsite: This round was more difficult and asked questions related to Data Engineering. My advice is to understand how to work as a Data Engineer. Practicing with LeetCode and refreshing SQL will only get you so far.

Also, you don't have to be perfect with your answers. Just explain your thought process and collaborate with the interviewers; they are there to help. Even if you get something wrong, explain your logic. Then, confirm why there might be a better solution if you aren't 100% confident yours is optimal.

Can't remember most, or had to sign an NDA for on-site questions. Expect some behavioral and product sense questions.