Filter interviews by
Snowflake Architecture is a cloud-based data warehousing platform that separates storage and compute for increased scalability and performance.
Snowflake uses a unique architecture with three layers: storage, compute, and services.
Data is stored in Amazon S3 or Microsoft Azure Blob Storage, separate from the compute resources.
Compute resources can be scaled up or down independently of storage, allowing for flexibility a...
Multi-clustering is a feature in Snowflake that allows data to be stored in multiple clusters for improved performance and scalability.
Improves query performance by distributing data across multiple clusters
Increases scalability by allowing more resources to be added as needed
Helps in workload isolation and resource management
Example: Storing customer data in one cluster and product data in another for better performan
Use regular expressions to extract numeric values from an alphanumeric string.
Use regular expression pattern '\d+' to match one or more numeric digits in the string.
Apply the regular expression pattern to the alphanumeric string to extract only the numeric values.
For example, if the input string is 'abc123def456', the output should be ['123', '456'].
Use a subquery to get the 3rd highest value from a table
Use a subquery to select distinct values from the table
Order the distinct values in descending order
Use LIMIT and OFFSET to get the 3rd highest value
I applied via Job Portal and was interviewed before Apr 2021. There was 1 interview round.
Solid principles are a set of design principles for writing maintainable and scalable code in C#.
Single Responsibility Principle (SRP) - a class should have only one reason to change
Open/Closed Principle (OCP) - a class should be open for extension but closed for modification
Liskov Substitution Principle (LSP) - derived classes should be substitutable for their base classes
Interface Segregation Principle (ISP) - client...
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
I appeared for an interview before Jun 2021.
Round duration - 180 minutes
Round difficulty - Easy
It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy
Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...
Find the duplicate number in an array of integers from 0 to (N-2).
Iterate through the array and keep track of the frequency of each number using a hashmap.
Return the number with a frequency greater than 1 as the duplicate number.
Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.
You are provided with a string S
and an array of integers A
of size M
. Your task is to perform M
operations on the string as specified by the indices in array A
...
Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.
Iterate through the array of indices and reverse the substrings accordingly
Ensure the range specified by each index is non-empty
Return the final string after all operations are completed
Round duration - 60 Minutes
Round difficulty - Easy
It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.
Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes
Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role
I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.
To get the second to last element from a SQL table, use the OFFSET-FETCH clause.
Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;
I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.
Fan trap is a situation in which a query involving multiple tables results in a Cartesian product.
Fan trap occurs when a table is connected to multiple tables in a one-to-many relationship.
It can be solved by creating a bridge table or by using aggregate functions.
For example, if a customer table is connected to an orders table and a products table, a fan trap can occur when trying to retrieve information about custome...
Dynamic break in report allows for automatic page breaks based on data.
Define a break field in the report design
Set the break field to trigger a page break when its value changes
Use dynamic break to automatically adjust page breaks based on data
Example: A report on sales by region can use dynamic break to create a new page for each region
Foreach function is used to iterate through an array of strings in a report.
Foreach function is used to loop through each element in an array of strings.
It can be used to display each element in a report.
Example: foreach(string item in stringArray){ Console.WriteLine(item); }
Aggregate awareness is a feature in Business Objects that allows reports to be optimized for performance by using aggregate tables.
Aggregate awareness is used when creating reports in Business Objects
It allows the report to use aggregate tables instead of detailed tables for improved performance
Syntax: AGGR_AWARE( Example: AGGR_AWARE(Product, Sum(Sales), Sales_Fact_Table) The @prompt function syntax is used to display a prompt message to the user and receive input. The syntax is @prompt('message', 'default value') The message is the prompt message to be displayed to the user The default value is optional and will be displayed in the input field The function returns the value entered by the user
I applied via
Naukri.com
and was interviewed before Jun 2021. There
was
1 interview round.
based on 2 interviews
Interview experience
based on 1
review
Rating in categories
₹7
L/yr - ₹25
L/yr
₹2
L/yr - ₹9.5
L/yr
₹4.9
L/yr - ₹18
L/yr
₹4.3
L/yr - ₹14
L/yr
₹2
L/yr - ₹10
L/yr
HCLTech TCS Tata Group Wipro)
Interview Questionnaire
1 Question
Interview Preparation Tips
(1 Question)
Interview Preparation Tips
Tell us how to improve this page.
HCL Group Interviews By Designations
Interview Questions for Popular Designations
HCL Group Snowflake Developer Interview Process
Snowflake Developer Interview Questions from Similar Companies
Fast track your campus placements
HCL Group Snowflake Developer Reviews and Ratings
Explore more salaries
Technical Lead
Software Engineer
Senior Software Engineer
Lead Engineer
Senior Analyst