Data warehousing concepts, basic ETL optimization, questions without depth
Sr Data Engineer Interview Questions
2,447 sr data engineer interview questions shared by candidates
Business or Domain knowledge expected from the project
Interview was scenerio based. He asked about my overall experience and then we had detail discussion on my past projects. Difference b/w star schema vs snowflake. And what was implemented and how was implemented in my project. Data profiling Data Mart ELT VS ETL and what are the advantages of ELT over ETL. TYPE 2 vs Type 3 SCD What is denormalization? Denormalization is stored in snowflake or star schema? Which is loaded first dimension or fact? In ETL Project is there any key column used? What was the purpose of that. 2 sql queries…rank vs dense rank and any other way of ranking in sql. 1 query for group vs analytical function
If you have to choose one value from equinor which you will choose and why
designing a simple data pipeline. They are mostly into modernization projects (moving from old technologies to cloud based ones)
General questions related to Microservices, Big data, leadership etc.
1. SQL performance tuning 2. Past experiences
1 - SQL 1 - Python
Array manipulation based questions
What is a high order function ? Have I had used Schema registry ?
Viewing 1061 - 1070 interview questions
See Interview Questions for Similar Jobs
Data EngineeringSenior Data EngineerBig Data EngineerSenior Big Data EngineerData EngineerSenior Data ConsultantLead Data EngineerData ScientistsData Scientist IiiPrincipal Data EngineerData Mining EngineerBigdata EngineerSr Data AnalystEtl Data Stage DeveloperSr Database EngineerDatabase Administrator IiSenior Data Stage DeveloperEtl Informatica Developer