J'ai postulé via la recommandation d'un employé. J'ai passé un entretien chez Afiniti
Entretien
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.
Questions d'entretien [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.
Questions d'entretien [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/
J'ai postulé en ligne. J'ai passé un entretien chez Afiniti (Dublin, Dublin) en févr. 2021
Entretien
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.
Questions d'entretien [1]
Question 1
difference between union and full outer join. difference between procedure and function. SCD types.
