Upload Button Icon Add office photos

Filter interviews by

Clear (1)

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 Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

Interview Preparation Tips

Round: Resume Shortlist
Experience: I had sent my resume to the hiring group, Selection through telephonic interviews. I was interviewed by three different research groups  (once by each).
Tips: Factors in decreasing order of importance: CGPA each stage. Ability to explain your projects precisely. Ability to solve ''standard" logarithmic problems.  The way you think and put down your Answer is the most important. The final answer .s not so I important, and they prod you when you think out aloud anyway.

Round: Technical Interview
Experience: Almost- by default they ask about your previous projects/internships if they are relevant to the group. Ofher questions depend on the group you are interviewed by and your own profile, In my case it was machine learning, text mining etc. I was told about the research problem they were dealing with then and asked f or comments/suggestions/.inputs and a discussion followed.
Tips: Basically these are specialized Interviews so it's good to have sound knowledge of your domain (analytical and application skills are very much required).

Skill Tips: CGPA>9.0, 1f not (like me) relevant work done in the domain and in past internship.A recommendation from the professor is also a good add on.
College Name: IIT Madras

Interview Preparation Tips

Round: Test
Experience: There was an apititude test basically in line with CAT pattern. It was conducted online for about 45 min duration. The questions were rather simple but each question was time bound (around 45 sec or so).
Tips: As such I did not have any structured study plan. I did refresh some of my basics in mechanics and analysis. I was more inclined to get a job in aerospace division. Read as per your interest.
Duration: 45 minutes

Round: Group Discussion
Experience: Initially, we are seated randomly in a circular manner and each one was given two minutes to describe the topic. It was followed by an tense debate where participants converged and diverged on different sets of issue. They were particularly looking for interpersonal skills and out of the box thinking.

Round: Interview
Experience: The interview was purely management type.More questions were thrown at team building, bio-data, why this company? , project, what you Can contribute for the firm?, where you see yourself in next 5 -10 years, ambitions, some amount of optimization tools and techniques, concluding remarks....Interpersonal skills and clarity in answering where mainly
IBM was a more relaxed interview, which basically dealt with management and interpersonal skills. Questions like “if one of our team mate is very stubborn, lazy, adamant, how will you tackle the situation” were asked.
Tips: College (B Tech) curricular activities, NTSC certificate, Math Olympiad certificate, all India quiz competition awards were noted and appreciated. That really was a booster. That helps in implanting an idea that you are not just blah blah blah.

Skill Tips: Be very sure about your mechanics, analysis and design. These three are the fundamentals.
I haven prepared for placements exclusively. Here were combined discussions. However, it really helps if you can revise and make your fundamentals were clear. The basic understanding should be there. An hour every day for two months will do the trick.
Be really choosy of the company you want to be in. Learn a lot more of the company and get an idea of what they are actually looking for. But still don’t freeze your mind to those realms alone.. Be open minded and cheerful. The first few questions will set the mood of the interview. If you are bale to crack that, then things will be really smooth. Really concentrate on your fundamentals, especially analysis and design.
Skills: Mechanics, Analysis , Design
College Name: IIT-Madras

Interview Preparation Tips

Round: Resume Shortlist
Experience: CGPA > 8 is necessary

Round: Test
Experience: Online Test + Written Test
Online Test - Duration 90 minutes + Written Test 30 minutes for Hardware profile
Online Test -Quants, Number Series ; Calculators were not allowed
Written Test - Semiconductor Basics

Round: Interview
Experience: Interview is held in either 1 round for non-core profile or several rounds of technical interviews for Hardware.
Technical round consisted of questions form topics like VLSI, Semiconductors (BJT, MOS), ASIC Design Flow, CMOS Process Flow.

Round: Group Discussion
Experience: Group Discussion is held for non-core profilesDuration varies from 20-30 minutes with 11 members.

General Tips: Never ever mention GRE or MS or any higher studies, for that matter, in any placement interview if you want to get placed in that company
Practicing quant, puzzle solving and GD from early in the semester would definitely help
Core placement: be thorough with the core fundaes
Practice general quant questions without a calculator
Skills: Quants, Puzzle Solving
College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: It had 3 parts: Data manipulation, number series and calculations.

Round: Test
Experience: Technical test on C. Typical questions on what will be the output of the program.

Round: Technical Interview
Experience: Questions were based on various areas of CSE, especially Programming languages and thesis work. Questions on Database connectivity in Java , CGI, DFA, DMA etc were also asked.
Tips: ISL works 80% in java and 20% in C. Thus, prepare Java well before appearing for the IBM-ISL. Must have basic knowledge in databases, Operating systems.

College Name: IIT KANPUR

Interview Preparation Tips

Round: Test
Experience: Initial shortlisting was based on 1 hour written test.
Questions on Quant,Codingand Algorithms were asked in the test
Tips: Focus on quant,coding and algorithms
Duration: 60 minutes

Round: Technical Interview
Experience: The subject knowledge and skills tested in Technical interview are:
1.Math
2.Coding
Tips: Good math knowledge is required.

Round: HR Interview
Experience: General HR question were asked in this round.

Skills: Data structure, Algorithms, Math, Coding
College Name: IIT MADRAS

Interview Preparation Tips

Round: Test
Experience: Quant, Sequence series, Basic mathematics
Each question was given a specific time after which other question appeared on screen and you cannot go back to the previous question. So this was a bit stressful.
12 people got selected.
Duration: 30 minutes

Round: Group Discussion
Experience: The moderator picked each and every guy and asked him/her to put his/her views, and then time was allocated to debate on the points raised. In total 15 mins GD. No elimination through GD. Basic GD skills were looked for that is ability to speak and to drive the discussion to a positive direction.

Round: HR Interview
Experience: Just 1 round of interview. Mostly HR question were asked. Resume based questions were asked. Basically HR questions were asked.

Round: Resume Shortlist
Tips: Interview was basically the criteria for selection. The internship, project POR everything mattered. Co-curricular activities were also asked.

General Tips: I think i was selected because I was able to justify my skill set properly. I gave valid explanations of my skill sets, I was able to justify my internships. Projecting my confidence level was an added advantage. Decide your future i.e. what is your area of interest and then prepare for it.
Having a good POR always help.
CGPA should be above 8.
Have mock interviews with a wingmates.
During internship work properly.
Skill Tips: Prepare for CAT. Quant, Puzzles, Case studies are important. Mock GDs and Mock PIs with wing-mates are very important. Revised all basic courses. All app-mech courses, solved some questions from unsolved section of any text book. Ensure you have mock GDs and mock PIs with wingmates.
College Name: IIT MADRAS

Interview Preparation Tips

Round: Resume Shortlist
Experience: CGPA above 8

Round: Test
Experience: These involve questions from aptitude.
Tips: R S Agarwal's book on aptitude is enough for preparation.
Duration: 80 minutes

Round: Group Discussion
Experience: 11 members were part of the GD. The GD was not a rejection round.
Duration: 20 minutes

Round: HR Interview
Experience: Basic Questions.
Tips: Just prepare normal questions for HR.

General Tips: Prepare from placement material from LAN.
Prepare basic fundaes.
College Name: IIT MADRAS
Contribute & help others!
anonymous
You can choose to be anonymous

HCL Group Interview FAQs

How many rounds are there in HCL Group Snowflake Developer interview?
HCL Group interview process usually has 1 rounds. The most common rounds in the HCL Group interview process are Technical and One-on-one Round.
What are the top questions asked in HCL Group Snowflake Developer interview?

Some of the top questions asked at the HCL Group Snowflake Developer interview -

  1. In alphanumeric string get only numeric val...read more
  2. Get the 3rd highest value from a ta...read more
  3. What is Multi-cluster...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

JOBS

Reliance Industries

No Jobs

INTERVIEWS

HCL Group

No Interviews

JOBS

TH Global Capital

No Jobs

INTERVIEWS

HCL Group

No Interviews

REVIEWS

Zydus Lifesciences

No Reviews

SALARIES

Hexaware Technologies

JOBS

Aspire Systems

No Jobs

SALARIES

Kotak Mahindra Bank

Tell us how to improve this page.

HCL Group Snowflake Developer Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more
HCL Group Snowflake Developer Salary
based on 9 salaries
₹4.8 L/yr - ₹11.8 L/yr
At par with the average Snowflake Developer Salary in India
View more details

HCL Group Snowflake Developer Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

3.0

Salary

3.0

Job security

3.0

Company culture

2.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Technical Lead
3.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
3.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
2.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Engineer
2.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
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