i
Deloitte
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Referral and was interviewed in Sep 2023. There were 2 interview rounds.
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...
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...
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;
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...
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...
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...
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.
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 ...
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...
I applied via Approached by Company and was interviewed in Dec 2024. There were 3 interview rounds.
Sales data from a leading manufacturer
I was interviewed in Dec 2024.
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
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
I was interviewed in Dec 2024.
Normal aptitude round
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
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
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
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...
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
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...
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.
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
Maxium sub string and reverse a string
I applied via campus placement at Lady Shri Ram College for Women, Delhi
Basic English, Quants and Statistics
Easy, relevant to pandemic
Interview experience
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