Upload Button Icon Add office photos

Filter interviews by

HCL Group Snowflake Developer Interview Questions, Process, and Tips

Updated 18 Oct 2024

Top HCL Group Snowflake Developer Interview Questions and Answers

HCL Group Snowflake Developer Interview Experiences

2 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Explain Snowflake Architecture
  • Ans. 

    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...

  • Answered by AI
  • Q2. What is Multi-clustering
  • Ans. 

    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

  • Answered by AI
  • Q3. 2 SQL scenario questions

Snowflake Developer Interview Questions & Answers

user image Sasi Rekha Kandukuri

posted on 12 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. In alphanumeric string get only numeric values
  • Ans. 

    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'].

  • Answered by AI
  • Q2. Get the 3rd highest value from a table
  • Ans. 

    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

  • Answered by AI

Skills evaluated in this interview

Snowflake Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. While creating a custom role which role should have the access to ... read more
asked in Cognizant
Q2. What feature in Snowflake's architecture and pricing model set is ... read more
asked in TCS
Q3. in bulk loading what is the size data gets loaded
asked in Infosys
Q4. How snowflake differs from industry competetors? What is the extr ... read more
asked in TCS
Q5. What is varient data type

Interview questions from similar companies

I applied via Job Portal and was interviewed before Apr 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Solid principles in c#
  • Ans. 

    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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - good company for freshers as well as beginners

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I appeared for an interview before Jun 2021.

Round 1 - Coding Test 

(2 Questions)

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

  • Q1. 

    Find the Duplicate Number Problem Statement

    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...

  • Ans. 

    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.

  • Answered by AI
  • Q2. 

    Reverse String Operations Problem Statement

    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...

  • Ans. 

    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

  • Answered by AI
Round 2 - Video Call 

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.

Interview Preparation Tips

Eligibility criterianaAccenture interview preparation:Topics to prepare for the interview - Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes

Application resume tips for other job seekers

Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you get the second to last element from a SQL table?
  • Ans. 

    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;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

I applied via Company Website and was interviewed in Oct 2018. There was 0 interview round.

Interview Preparation Tips

General Tips: This interview was a technical one but was majorly a stress test. It lasted for about 1 hour 10 minutes. The interviewer wanted to test both my knowledge and communication skills. Most of the questions asked to me were related to my B.Tech curriculum i.e. computer science related topics. He stressed a lot on the basics related to my project topic. Luckily I was able to answer most of the questions correctly. I tried to answer each question with examples and also used props on the table (like pens, paperweights, pen stands etc.) to explain my theories. It was my first offcampus interview, and I think I did pretty well for a fresher.
You need to stay calm and should apply presence of mind. Please go through the job description thoroughly word-by-word and recheck your resume to ensure that you are a best-fit for the position.
Skills: Communication, Body Language, Problem Solving, Leadership, Presentation Skills
Duration: <1 week

Interview Questionnaire 

6 Questions

Compare HCL Group with

HCLTech

3.5
Compare

TCS

3.7
Compare

Tata Group

4.2
Compare

Wipro

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview