I applied through an employee referral. I interviewed at Afiniti
Interview
There were two interviews, one was technical and other was with the director. The question were very basic databases questions and I was asked to write few very simple SQL queries. The interview with director was just a formality. He also asked some very basic databases questions like difference between primary and unique key etc.
Interview questions [1]
Question 1
Difference between primary and unique key. Surrogate key Data warehousing
It was two rounds interview process. Got the offer within 2 weeks. The interview was mainly around Python, SQL, Airflow and Databases. First interview was with direct line Manager and the second was with HOD.
Interview questions [1]
Question 1
Order of SQL query. Optimization of sql query. SCD i,ii,iii. Reverse string in python iteratively. Inner join vs cross join with example.
Thank you for your kind words, weâre pleased you had a positive interview experience and encourage you to explore future opportunities on our careers site: https://www.afiniti.com/careers/
I applied online. I interviewed at Afiniti (Dublin, Dublin) in Feb 2021
Interview
Applied online. HR called back in 2days and discussed about my background, experience etc. Scheduled a call with senior data engineer for technical interview. Included questions around sql python etl. Some hands-on sql queries to be solved during the call. HR came back quickly after the interview with feedback and didn't proceed further to next round.
Interview questions [1]
Question 1
difference between union and full outer join. difference between procedure and function. SCD types.
