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.
Perguntas de entrevista [1]
Pergunta 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/
Outras avaliações de entrevista de vagas de Data Engineer da empresa Afiniti
Candidatei-me por indicação de um funcionário. Fiz uma entrevista na empresa Afiniti.
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 1
Difference between primary and unique key. Surrogate key Data warehousing
Candidatei-me online. Fui entrevistado pela Afiniti (Dublin, Dublin) em fev. de 2021
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 1
difference between union and full outer join. difference between procedure and function. SCD types.
