The interview process was smooth and pretty efficient.
This consisted in 4 steps:
1. Telephone interview with HR representative to understand the cultural fit, professional background and fit for the role.
2. First video-interview, with HR representative and team- lead,
Questions to address the company and the role. These were mainly standard ones, such as why this company, why this role, talk about your experience and mostly tided to the job descriptions. Most questions were role based, for eg, tell me what you did in the previous role, and other similar to the first interview, such as why this role, why you think you fit the position, ect.
After passing this stage I was handed a 'written assignment': this consisted in a 10 pages paper with 5 tasks, all role related:
a. task was related to understanding how functional databases works and to draw a database diagram with primary keys links
b. write a piece of calculation ( eg. database import limits is 5m rows and file has n products to each day how many days of history can we load before reach the limit)
c. write a small piece of code in java to incorporate balance based on given criterias
d. few questions related to wildcard and ETL model data import.
e. write a professional email to hypothetical user to provide troubleshooting feedback
The time provided to complete the assignment was fair (about one week) and the difficulty was medium ( if you fit the role and has the required experience, then these tasks are are not so hard, I managed to complete it before the deadline ).
3. Second online interview with team lead and a person in the role (TC in this case): in this call we discussed the assignment and covered the questions, the answers provided and why specific answers were given (i believe to confirm you did the assignment and understand the role).
4. Final interview with head of department. This was more informal, with similar generic questions on role, experience and general interests.
Overall the experience was very positive and very comfortable.