1. Technical Round (Snowflake & Data Warehousing)
Snowflake Architecture:
Explain micro-partitions, clustering keys, caching layers.
How do you optimize a slow Snowflake query?
SQL & Snowflake Scripting:
Write SQL for SCD (Slowly Changing Dimensions) Type 1/2.
Use Snowflake Tasks, Streams, Pipes for real-time pipelines.
ETL & Data Loading:
Interview questions [1]
Question 1
1. Technical Round (Snowflake & Data Warehousing)
Snowflake Architecture:
Explain micro-partitions, clustering keys, caching layers.
How do you optimize a slow Snowflake query?
SQL & Snowflake Scripting:
Write SQL for SCD (Slowly Changing Dimensions) Type 1/2.
Use Snowflake Tasks, Streams, Pipes for real-time pipelines.
ETL & Data Loading:
I applied in-person. I interviewed at Cognizant (Chennai)
Interview
all about python,sql and databases and coding quersitons and performance, all about python,sql and databases and coding quersitons and performance, all about python,sql and databases and coding quersitons and performance,
I'm starting the interview process. There is a multiple-choice test and a video interview. I've heard mixed reviews about their interview process, but I'm going in with a positive mindset.
Interview questions [1]
Question 1
Discuss your experience with version control systems in the context of data engineering. How do you manage changes to data pipelines over time?