Data modeling question, basic concepts of SDLC, concepts like CI/CD approach. SQL group by vs having, a basic sql script. Coding question involving a Hash table.
Perguntas de entrevista de Senior Associate Data Engineer
9 Perguntas de entrevista compartilhadas pelos candidatos | senior associate data engineer
They asked basic to moderate python and SQL
Technical and Project related questions
architecture
what are window functions, explain rank and dense rank explain joins and no of outputs for each join for a given table, where vs having clause second highest salary for each department partition vs bucketing, when to choose each, python code to remove duplicate from a list list vs tuple vs dict. py thon code to find combinations from list [2,3,5] where sum is 8.
Why do you want to join PWC when u have other offers ?
In the given array, move all 0's to the end of it while maintaining the relative order of the non-zero elements.
spark cluster confuguration to process 1 TB of file 2. quetions on data modelling 3.GCP related quetions 4 How do you implement logging 5.SMB join in hive along with this few scenario based quetions and some architecture related quetions on cloud and kubernetes
Behavioral questions like why Amgen, tell me about the mission of Amgen, how would you resolve a conflict, how would you go about learning a new concept/skill.
Exibindo 1 a 10 perguntas de entrevista
Veja perguntas de entrevista para vagas semelhantes
Database ArchitectSql Database EngineerSenior Data Warehouse ArchitectSenior Sql DeveloperBusiness Objects Developer AnalystSenior Database EngineerSenior Sql Database AdministratorData Warehouse Etl DeveloperAssociate Data AnalystSenior Oracle Database AdministratorData Warehouse ArchitectBusiness Objects DeveloperBusiness Intelligence DeveloperSenior Data ArchitectBusiness Objects Data Integrator Data Services EtlSql Database AdministratorSenior Etl DeveloperPower Bi ConsultantBusiness Intelligence Engineer