Add office photos
i
London Stock Exchange Group
Compare
Filter interviews by
London Stock Exchange Group Snowflake Data Engineer Interview Questions, Process, and Tips for Experienced
London Stock Exchange Group Snowflake Data Engineer Interview Experiences for Experienced
1 interview found
Selected
I applied via Referral and was interviewed in Oct 2023. There were 2 interview rounds.
(5 Questions)
- Q1. How do you load data from JSON?
- Ans.
Data can be loaded from JSON using Snowflake's COPY INTO command.
Use the COPY INTO command in Snowflake to load data from JSON files.
Specify the file format as JSON in the COPY INTO command.
Map the JSON attributes to the columns in the target table.
Example: COPY INTO target_table FROM 's3://bucket_name/file.json' FILE_FORMAT = (TYPE = 'JSON');
- Q2. What are the performance tuning options in snowflake?
- Ans.
Performance tuning options in Snowflake include clustering, materialized views, query profiling, and resource monitoring.
Use clustering keys to organize data for faster query performance
Create materialized views to pre-aggregate data and improve query speed
Utilize query profiling to identify and optimize slow queries
Monitor resource usage to ensure efficient query execution
- Q3. How do you configure snowpipe?
- Ans.
Snowpipe is configured using a Snowflake account, specifying the source data location and the target table.
Configure a stage in Snowflake to specify the source data location.
Create a pipe in Snowflake to define the target table and the stage.
Set up notifications for the pipe to trigger loading data automatically.
Monitor the pipe for any errors or issues in data loading.
Example: CREATE STAGE my_stage URL = 's3://my_buck...
- Q4. Data modelling techniques used
- Ans.
Various data modelling techniques like dimensional modelling, ER modelling, and data vault are used.
Dimensional modelling is used for data warehousing and involves organizing data into facts and dimensions.
ER modelling is used to visualize the data relationships in an entity-relationship diagram.
Data vault modelling is used for agile data warehousing and involves creating a flexible and scalable data model.
- Q5. Streans in snowflake
- Ans.
Streams in Snowflake are used to continuously replicate data from a table to another destination in real-time.
Streams capture changes made to a table, such as inserts, updates, and deletes.
They can be used to track changes and replicate data to other tables or external systems.
Streams are created on a specific table and can be monitored for changes using SQL commands.
Skills evaluated in this interview
Interview questions from similar companies
Data Engineer Interview Questions & Answers
Commonwealth Bank of Australia, India
Anonymous
posted on 17 Feb 2024
(1 Question)
- Q1. Spark basics, sql - analytical functions,lateral view explode,project realted questions etc
Data Analyst Interview Questions & Answers
Motilal Oswal Financial Services
Anonymous
posted on 3 Mar 2023
I applied via Walk-in and was interviewed in Feb 2023. There were 2 interview rounds.
We started with our friends who is Business associate of Motilal Oswal finance services and those 2 friends are take brokership of financial firm, I was already there as a Tech Guy and Reasearcher for Stock Market and Fundamental Analytics , conducted more than 100 stocks analysis to advise clients to reduce the risk.
(2 Questions)
- Q1. We friends just do a group discussion for the customer relationship
- Q2. Investment and products related interview
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before May 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Machine learning algorithms
- Ans.
Machine learning algorithms are used to analyze data and make predictions or decisions without being explicitly programmed.
Machine learning algorithms can be categorized into supervised, unsupervised, and reinforcement learning.
Examples of machine learning algorithms include linear regression, decision trees, support vector machines, and neural networks.
These algorithms learn from data to improve their performance over...
- Q2. SQL basics and basic knowledge of security products
(1 Question)
- Q1. Very lengthy process and delayed a lot
Skills evaluated in this interview
Senior Data Analyst Interview Questions & Answers
Motilal Oswal Financial Services
Anonymous
posted on 20 Jan 2023
Selected
I was interviewed in Jul 2022.
(2 Questions)
- Q1. Mostly they check your communication
- Q2. About your previous experience
Interview Preparation Tips
I applied via Company Website and was interviewed in Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. What is ur name..were is u come
(1 Question)
- Q1. Excel.mail processing
Interview Preparation Tips
Senior Data Engineer Interview Questions & Answers
Commonwealth Bank of Australia, India
Anonymous
posted on 7 Feb 2022
I applied via Referral and was interviewed in Aug 2021. There were 2 interview rounds.
They shared one link for online test according to our Profile. If we cleared that test then we will get call from HR for 1 Technical round. In Technical round, it was started with my previous project discussion and questions where asked on that one and some scenerio based Questions on my profile, it went for almost an hour.After a week I got invitation for 2 nd round where it is combination of Technical and Managerial. It went for almost 45 mins, he mainly focused on how I react when tough situations comes in Ops area
(1 Question)
- Q1. I worked on one automation in my previous org, he asked me about it and I explained him and he asked me how it helped to business and how much it saved to Company.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jan 2021. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Questions were mainly based on past role and work experience
- Q2. Have you worked on customer segmentation?
- Ans.
Yes, I have worked on customer segmentation.
I have used clustering algorithms like K-means and hierarchical clustering to segment customers based on their behavior and demographics.
I have also used decision trees and random forests to identify the most important features for segmentation.
I have experience with both supervised and unsupervised learning techniques for customer segmentation.
I have worked on projects where...
- Q3. In depth interview on tools worked upon
Interview Preparation Tips
London Stock Exchange Group Interview FAQs
Tell us how to improve this page.
London Stock Exchange Group Interviews By Designations
- London Stock Exchange Group Associate Content Analyst Interview Questions
- London Stock Exchange Group Content Analyst Interview Questions
- London Stock Exchange Group Analyst Interview Questions
- London Stock Exchange Group Associate Research Analyst Interview Questions
- London Stock Exchange Group Research Analyst Interview Questions
- London Stock Exchange Group Software Engineer Interview Questions
- London Stock Exchange Group Business Analyst Interview Questions
- London Stock Exchange Group Associate Software Engineer 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
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
|
Content Analyst
1.2k
salaries
|  ₹2.4 L/yr - ₹7.2 L/yr |
|
Associate Content Analyst
889
salaries
| ₹2.2 L/yr - ₹6 L/yr |
|
Senior Content Analyst
465
salaries
| ₹4 L/yr - ₹9.5 L/yr |
|
Research Analyst
267
salaries
| ₹2.8 L/yr - ₹7 L/yr |
|
Associate Research Analyst
226
salaries
| ₹2.2 L/yr - ₹4.8 L/yr |
National Stock Exchange of India
Bombay Stock Exchange
Multi Commodity Exchange of India
HDFC Bank
Calculate your in-hand salary
- Home >
- Interviews >
- London Stock Exchange Group Interview Questions >
- London Stock Exchange Group Snowflake Data Engineer Interview Questions for Experienced
