I applied through a staffing agency. The process took 1 day. I interviewed at Rabobank (Melbourne) in May 2021
Interview
I applied for X company whose client is Rabo bank. Rabo bank selected my profile and scheduled interview (through teams).The interview is for half n Hour and 2 members are in the panel (one is technical lead). First they gave brief introduction about the company and explained particular project for which they are recruiting.
Interview questions [1]
Question 1
1. As usual tell me about yourself.
2. roles and responsibilities in the previous project.
3. If you get text file how you connect to power center and load into DWH.
4. What Dimension you used in your project?
5. Types of SCD and difference between SCD1 and SCD2.
6. How you maintained SCD2 in your project.
7. Then they asked a SQL query (many to many relationships).