AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Spencer's Retail Data Engineer Interview Questions and Answers
Spencer's Retail Data Engineer Interview Experiences
1 interview found
Thunder
(1 Question)
- Q1. Have you worked in databricks
- Ans.
Yes, I have worked in Databricks for data engineering projects.
I have experience using Databricks for data processing and analysis.
I have utilized Databricks for building and optimizing data pipelines.
I have worked with Databricks notebooks for coding and collaboration.
I have used Databricks clusters for scalable data processing.
I have integrated Databricks with other tools like Apache Spark for big data processing.
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
(5 Questions)
- Q1. Wxaplinnyour project
- Q2. How would you build a pipeline to connect http source and bring data in adls
- Ans.
Build a pipeline to connect http source and bring data in adls
Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source
Transform the data as needed using tools like Apache Spark or Azure Databricks
Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis
- Q3. Dimension and fact tabel difference
- Ans.
Dimension tables store descriptive attributes while fact tables store quantitative data.
Dimension tables contain attributes that describe the business entities, such as customer, product, or time.
Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.
Dimension tables are denormalized and have a one-to-many relationship with fact tables.
Fact table...
- Q4. Write slq query to get employee having 2manager
- Ans.
Use a self join to find employees with 2 managers in SQL query.
Use a self join on the employee table to join the table with itself.
Count the number of distinct managers for each employee.
Filter the results to only include employees with 2 managers.
- Q5. Get second highest salary usingSQL
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There was 1 interview round.
(1 Question)
- Q1. About partitions and bucketing Spark optimization Question from hadoop All questions were scenario based
Coding is my life and my dream
(2 Questions)
- Q1. Html and css and html
- Q2. Java and python and java
Selected
I applied via Job Portal and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. About past experience
- Q2. Data analyst project
(1 Question)
- Q1. Salary question
I applied via Referral and was interviewed in Nov 2023. There were 2 interview rounds.
(5 Questions)
- Q1. Normal interviewer questions
- Q2. Personal Details Previous job related Most important your Excel knowledge
- Q3. Personal Details
- Q4. Previous job related
- Q5. Excel knowledge
Interview Preparation Tips
- Excel knowledge
Those candidates they don't have any other company opportunities
This is permanent job but you can't consider life long feature job
Here is very difficult to get promoted because this designation job is third party job
I applied via Walk-in and was interviewed in Mar 2023. There were 3 interview rounds.
Good aptitude test and group discussion. Also assignment and case study and HR and assignment and technical and one on one round
Good coding test and aptitude test, Hr and technical and one on one round and case study and assignment
Interview Preparation Tips
Positive
Outlook
Grateful
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
(5 Questions)
- Q1. Wxaplinnyour project
- Q2. How would you build a pipeline to connect http source and bring data in adls
- Ans.
Build a pipeline to connect http source and bring data in adls
Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source
Transform the data as needed using tools like Apache Spark or Azure Databricks
Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis
- Q3. Dimension and fact tabel difference
- Ans.
Dimension tables store descriptive attributes while fact tables store quantitative data.
Dimension tables contain attributes that describe the business entities, such as customer, product, or time.
Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.
Dimension tables are denormalized and have a one-to-many relationship with fact tables.
Fact table...
- Q4. Write slq query to get employee having 2manager
- Ans.
Use a self join to find employees with 2 managers in SQL query.
Use a self join on the employee table to join the table with itself.
Count the number of distinct managers for each employee.
Filter the results to only include employees with 2 managers.
- Q5. Get second highest salary usingSQL
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Oct 2024. There were 2 interview rounds.
3 sum problem was asked to complete
Take home project to design app
Senior Software Engineer Interview Questions & Answers
Titan Company
Anonymous
posted on 22 May 2023
Selected
I applied via campus placement at Pondicherry University and was interviewed before May 2022. There were 3 interview rounds.
Will be asked for basic python competency
(2 Questions)
- Q1. How does the internet work end to end
- Ans.
The internet is a global network of interconnected devices that communicate using standardized protocols.
Data is sent in packets using the TCP/IP protocol
Devices are identified using unique IP addresses
DNS translates domain names to IP addresses
Routers direct traffic between networks
Firewalls protect against unauthorized access
Encryption ensures secure communication
- Q2. What is the stack overflow error
- Ans.
Stack overflow error occurs when the call stack exceeds its limit due to infinite or too many recursive function calls.
Occurs when the call stack is full
Caused by infinite or too many recursive function calls
Can lead to program crashes or unexpected behavior
Interview Preparation Tips
Skills evaluated in this interview
Spencer's Retail Interview FAQs
Tell us how to improve this page.
Spencer's Retail Interviews By Designations
- Spencer's Retail Assistant Manager Interview Questions
- Spencer's Retail Head Cashier Interview Questions
- Spencer's Retail Loss Prevention Officer Interview Questions
- Spencer's Retail Sales Team Leader Interview Questions
- Spencer's Retail Store Manager Interview Questions
- Spencer's Retail Team Lead Interview Questions
- Spencer's Retail Assistant Manager Operations Interview Questions
- Spencer's Retail Asst .Warehouse Manager (Apparel) Warehouse in-Charge Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Spencer's Retail Data Engineer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Team Lead
144
salaries
|  ₹1.4 L/yr - ₹4 L/yr |
|
Store Manager
115
salaries
| ₹2.2 L/yr - ₹10 L/yr |
|
Assistant Manager
95
salaries
| ₹3.3 L/yr - ₹11.2 L/yr |
|
Team Member
76
salaries
| ₹0.9 L/yr - ₹2 L/yr |
|
Senior Executive
62
salaries
| ₹2 L/yr - ₹5.8 L/yr |
Future Retail
Aditya Birla Fashion and Retail
Reliance Retail
Trent
- Home >
- Interviews >
- Spencer's Retail Interview Questions >
- Spencer's Retail Data Engineer Interview Questions
