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
Selected
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
(2 Questions)
- Q1. Big data , Optimization , Python basic , SQL intermediate
- Q2. Find max and min number without sorting Joins related Big data handling Optimization question
(2 Questions)
- Q1. Schema , python , sql
- Q2. Case study sql and python based
Sales data from a leading manufacturer
vinay kn
I was interviewed in Dec 2024.
(6 Questions)
- Q1. What is spark,explain its ecosystem
- Q2. What are transformations, and how many types of transformations exist?
- Q3. Explain about spark job process and its planning
- Q4. What are the concepts of coalesce and repartition in data processing?
- Q5. Explain about oom and driverhead memory
- Q6. What is data skewness
Selected
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Sql order of execution
- Ans.
SQL order of execution determines the sequence in which different clauses are processed in a query.
SQL query is parsed and validated first
Next, the query optimizer creates an execution plan
Execution plan includes steps like table scans, index scans, joins, etc.
Finally, the query is executed and results are returned
- Q2. Sql question on finding highest salary for each employee where employees and department table are given in each department.
Interview Preparation Tips
- SQL
- Python
- Pyspark
I was interviewed in Dec 2024.
Normal aptitude round
(2 Questions)
- Q1. SQL 4 QUESTION 1 BASIC 3 INTERMIDATE
- Q2. DATA WAREHOUSE DETAILS ITS IMP THEY WORK ON THIS SO ASK ALL INFO ABOUT THIS
Interview Preparation Tips
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
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
Deloitte Snowflake Data Engineer Interview Process
based on 1 interview
Interview experience
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
33k
salaries
|  ₹6.2 L/yr - ₹23 L/yr |
|
Senior Consultant
20.7k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
14k
salaries
| ₹3.7 L/yr - ₹12.4 L/yr |
|
Assistant Manager
10k
salaries
| ₹7.8 L/yr - ₹24 L/yr |
|
Manager
7k
salaries
| ₹15.8 L/yr - ₹51 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Snowflake Data Engineer Interview Questions
