Sr Data Engineer Interview Questions

2,606 sr data engineer interview questions shared by candidates

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
avatar

Senior Data Engineer

Interviewed at TEKsystems

3.6
May 31, 2023

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

Viewing 1131 - 1140 interview questions

Glassdoor has 2,606 interview questions and reports from Sr data engineer interviews. Prepare for your interview. Get hired. Love your job.