I applied online. The process took 5 months. I interviewed at DEPT
Interview
I was contacted back on my application for Data Engineering, we had an Interview with the HR Representative, and the interview ended with a positive outlook (Even the HR Person said: I feel very confident in this interview, and I will pass your cv to the hiring manager). This was in June 2022. I received an email today: End of October 2022. They sadly regret to let me know that I was not being selected.
Interview questions [1]
Question 1
How long have you worked with Data? What programming language do you use? Which technologies are you proficient with? How are you as a person?
I applied online. The process took 4 weeks. I interviewed at DEPT (Dublin, Dublin) in Aug 2021
Interview
Interview had 2 Rounds. First one with the HR most of the questions were about getting to know me, the reason for applying to DEPT etc. I was sent a case study to do using Python & PostgreSQL. After 2 weeks I was called up for a Tech Interview. The Technical interview had multiple questions covering DWH Concepts and other things such as ETL/ELT, how the data models were in the projects i had worked on earlier. A week later I was offered the role and my joining date was a month later. Right 2 days before joining, they pulled my offer back with no justifiable reasons. I had rejected other offers for this role and I just got screwed like that.
Interview questions [1]
Question 1
1. Explain the Data flow in the project you worked on. 2. ETL Vs ELT 3. Different types of Schemas.