Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Afiniti (Dublino, Dublino) nel mese di feb 2021
Colloquio
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.
Domande di colloquio [1]
Domanda 1
difference between union and full outer join. difference between procedure and function. SCD types.
Ho sostenuto un colloquio presso Afiniti (Karachi)
Colloquio
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.
Domande di colloquio [1]
Domanda 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/
Ho presentato la mia candidatura tramite segnalazione di un dipendente. Ho sostenuto un colloquio presso Afiniti
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Difference between primary and unique key. Surrogate key Data warehousing