Add office photos
i
Deloitte
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Deloitte Snowflake Data Engineer Interview Questions, Process, and Tips
Deloitte Snowflake Data Engineer Interview Experiences
1 interview found
Anonymous
I applied via Referral and was interviewed in Sep 2023. There were 2 interview rounds.
(4 Questions)
- Q1. Explain the architecture & unique characteristics of Snowflake
- Ans.
Snowflake is a cloud-based data warehousing platform with unique features like separation of storage and compute, automatic scaling, and data sharing capabilities.
Snowflake uses a unique architecture with separate layers for storage, compute, and services, allowing for independent scaling of each component.
It uses virtual warehouses to separate compute resources, enabling users to scale up or down based on workload req...
- Q2. Define Time Travel and how it helps .
- Ans.
Time Travel in Snowflake allows users to query historical data as it existed at a specific point in time.
Time Travel in Snowflake enables users to access and query data as it existed at a specific point in the past.
It helps in auditing, compliance, and debugging by allowing users to track changes and view historical data.
Users can specify a timestamp or a statement ID to retrieve data from a specific point in time.
Time...
- Q3. How to set data retention time as 0 .
- Ans.
To set data retention time as 0 in Snowflake, you can use the ALTER TABLE command with the SET option.
Use ALTER TABLE command with SET option to modify the data retention time to 0.
Syntax: ALTER TABLE table_name SET DATA_RETENTION_TIME = 0;
Example: ALTER TABLE sales SET DATA_RETENTION_TIME = 0;
- Q4. Explain Stages and stored procedure.
- Ans.
Stages are logical groupings of tasks in a data pipeline, while stored procedures are precompiled SQL code for repeated use.
Stages are used to organize tasks in a data pipeline, such as extraction, transformation, and loading.
Stored procedures are precompiled SQL code that can be reused multiple times for efficiency.
Stages help in managing and monitoring the flow of data through different processing steps.
Stored proced...
(6 Questions)
- Q1. Why snowflake is better than other cloud datawarehouse?
- Ans.
Snowflake offers unique architecture with separation of storage and compute, automatic scaling, and support for diverse workloads.
Snowflake's architecture separates storage and compute, allowing for independent scaling and cost optimization.
Snowflake automatically handles infrastructure management, reducing the need for manual tuning and maintenance.
Snowflake supports diverse workloads, including data warehousing, data...
- Q2. Migration in Snowflake and the process
- Ans.
Migration in Snowflake involves moving data and objects from one environment to another using various methods.
Use Snowflake's built-in tools like SnowSQL, Snowpipe, and Snowflake Data Migration Service for seamless migration
Consider factors like data volume, complexity, and downtime requirements when planning migration
Test the migration process thoroughly to ensure data integrity and consistency
Monitor the migration pr...
- Q3. Ingestion Part in Snowflake
- Ans.
Ingestion in Snowflake involves loading data into the platform for analysis and processing.
Use Snowflake's COPY INTO command to load data from external sources like S3, Azure Blob Storage, or Google Cloud Storage.
Consider using Snowpipe for continuous data ingestion from streaming sources.
Utilize Snowflake's Snowpark for data ingestion and processing using programming languages like Scala or Java.
- Q4. What are the connectors in Snowflake.
- Ans.
Connectors in Snowflake are used to integrate with various data sources and tools for seamless data loading and querying.
Snowflake JDBC connector for connecting to Snowflake using Java applications
Snowflake ODBC connector for connecting to Snowflake using ODBC-compliant applications
Snowflake Python connector for connecting to Snowflake using Python scripts
Snowflake Spark connector for integrating Snowflake with Apache ...
- Q5. What are the types of security in Snowflake?
- Ans.
Snowflake offers multiple layers of security including network security, data encryption, and access control.
Network security: Snowflake uses Virtual Private Cloud (VPC) peering, IP whitelisting, and multi-factor authentication to secure network communication.
Data encryption: Snowflake encrypts data at rest and in transit using industry-standard encryption algorithms.
Access control: Snowflake provides role-based access...
- Q6. Tough SQL Questions
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Project related discussions
- Q2. Meduim level SQl and DSA
(2 Questions)
- Q1. This was data modelling round
- Q2. Design a uber data model
- Ans.
Uber data model design for efficient storage and retrieval of ride-related information.
Create tables for users, drivers, rides, payments, and ratings
Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.
Establish relationships between tables using foreign keys
Implement indexing for faster query performance
Interview Preparation Tips
Skills evaluated in this interview
tejas jain
I applied via Newspaper Ad and was interviewed in Aug 2024. There were 3 interview rounds.
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
(2 Questions)
- Q1. What is DSA , sorting , difference between array and linked list
- Ans.
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
DSA stands for Data Structures and Algorithms
Sorting is the process of arranging data in a particular order
Arra...
- Q2. Written a SQL query
(2 Questions)
- Q1. Coding question like add numbers
- Q2. Experience on your project
- Ans.
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
Developed predictive models to forecast customer behavior and optimize marketing strategies
Conducted market research to identify trends and opportunities for growth
Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Skills evaluated in this interview
(2 Questions)
- Q1. Power BI Difference between ALL() and ALLSELECTED()
- Ans.
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
ALL() removes all filters from the specified column or table.
ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.
Example: ALL('Table') would remove all filters on the 'Table' in the query context.
Example: ALLSELECTED('Column') would remove filte...
- Q2. Excel Difference between COUNT() and COUNTA()
- Ans.
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
COUNT() counts only cells with numerical values.
COUNTA() counts all non-empty cells, including text and errors.
Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
(2 Questions)
- Q1. Resume based questions like explain the projects that you have done.
- Q2. Sample dataset questions
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
Maxium sub string and reverse a string
Selected
I applied via campus placement at Lady Shri Ram College for Women, Delhi
Basic English, Quants and Statistics
Easy, relevant to pandemic
(1 Question)
- Q1. Python, Tableau, SQL, Stats, ML, all questions easy to medium level
(2 Questions)
- Q1. Behavioural Questions
- Q2. Statistics Case Study
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
(5 Questions)
- Q1. 1. What is columnar storage,parquet,delta? Why it is used
- Ans.
Columnar storage is a data storage format that stores data in columns rather than rows, improving query performance.
Columnar storage stores data in a column-wise manner instead of row-wise.
It improves query performance by reducing the amount of data that needs to be read from disk.
Parquet is a columnar storage file format that is optimized for big data workloads.
It is used in Apache Spark and other big data processing ...
- Q2. 2.list ,tuple,set in python 3.sql groupby and window function ,union
- Q3. 3. Explain detail project architecture
- Ans.
The project architecture involves the design and organization of data pipelines and systems for efficient data processing and storage.
The architecture includes components such as data sources, data processing frameworks, storage systems, and data delivery mechanisms.
It focuses on scalability, reliability, and performance to handle large volumes of data.
Example: A project architecture may involve using Apache Kafka for ...
- Q4. 4. How to connect SQL server to databricks
- Ans.
To connect SQL server to Databricks, use JDBC/ODBC drivers and configure the connection settings.
Install the appropriate JDBC/ODBC driver for SQL server
Configure the connection settings in Databricks
Use the JDBC/ODBC driver to establish the connection
- Q5. Optimisation techniques used
- Ans.
Optimisation techniques used in data engineering
Partitioning data to improve query performance
Using indexing to speed up data retrieval
Implementing caching mechanisms to reduce data access time
Optimizing data storage formats for efficient storage and processing
Parallel processing and distributed computing for faster data processing
Using compression techniques to reduce storage space and improve data transfer
Applying qu...
Interview Preparation Tips
- Spark,
- SQL
- Python
Skills evaluated in this interview
I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Basics of power bi and sql
- Q2. What are joins and types of join
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FULL JOIN...
- Q3. How to add date table in power bi
- Ans.
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
Create a new table in Power BI with a list of dates
Add columns for day, month, year, etc. for additional analysis
Establish relationships between the date table and other tables in the data model
(4 Questions)
- Q1. Sql scenario based question on joins
- Q2. Window function questions
- Q3. Performance tuning
- Q4. Power bi dax question
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed in Jan 2024. There were 4 interview rounds.
(2 Questions)
- Q1. Python pandas SQL Tableau
- Q2. List vs tuple difference
- Ans.
List and tuple are both sequence data types in Python, but the main difference is that lists are mutable while tuples are immutable.
Lists are enclosed in square brackets [], while tuples are enclosed in parentheses ().
Lists can be modified by adding, removing, or changing elements, while tuples cannot be modified once created.
Lists are typically used for collections of similar items, while tuples are used for heterogen...
(1 Question)
- Q1. SQL ,python problem solving
(1 Question)
- Q1. Manager Discussion
(1 Question)
- Q1. Salary discussion
Skills evaluated in this interview
Selected
(1 Question)
- Q1. How good are you with numbers
(1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs
(1 Question)
- Q1. Do you know the role and responsibility of this position
Deloitte Interview FAQs
Tell us how to improve this page.
Deloitte Interviews By Designations
- Deloitte Consultant Interview Questions
- Deloitte Analyst Interview Questions
- Deloitte Senior Consultant Interview Questions
- Deloitte Associate Analyst Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Business Technology Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Snowflake Developer Interview Questions
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
Deloitte Snowflake Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Consultant
32.8k
salaries
|  ₹6.2 L/yr - ₹23 L/yr |
|
Senior Consultant
20.9k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
13.9k
salaries
| ₹3.8 L/yr - ₹12.6 L/yr |
|
Assistant Manager
9.9k
salaries
| ₹7.7 L/yr - ₹24 L/yr |
|
Manager
7k
salaries
| ₹15.7 L/yr - ₹52 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
Calculate your in-hand salary
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Snowflake Data Engineer Interview Questions
