It was a 4 part interview process, all either done over the phone or a video call. There was an interview with HR, the department manager, a team, and the president. The process took about 3-4 weeks.
For the HR interview, you are told about the position, and are asked about your salary expectations, along with a few questions to get to know you and your background. Afterwards, they send you an online SQL test that you need to complete in a certain amount of days.
The department manager interview and the team interview consisted of behavioral questions (which feel more insightful and meaningful compared to questions like "what are your strengths and weaknesses" I felt the questions they asked actually helped me present my work style). They also try to see what kind of person you are based on the questions they asked. Everyone was pleasant.
The interview with the president was to see if you are compatible with the company and its culture.
Overall an efficient process and management is consistent with getting back to you in a timely manner.