Reliance Retail Data Engineer 1 Interview Questions and Answers

Q1. Difference between where and having
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before grouping, HAVING is applied after grouping

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP BY column HAVIN
Answered by AI
Add your answer
Q2. View and materialised view
Add your answer

Retail data case study

Case study discussion

Q1. Retail situational based questions
Add your answer
Q2. Metrics used in retail business
Ans. 
Metrics used in retail business include sales, customer acquisition cost, customer lifetime value, inventory turnover, and gross margin.
• Sales: Total revenue generated from products or services sold

• Customer acquisition cost: Cost incurred to acquire a new customer

• Customer lifetime value: Predicted revenue a customer will generate over their lifetime

• Inventory turnover: Number of times inventory is sold and replaced in a ...read more
Answered by AI
Add your answer

Q1. Basic technical knowledge
Add your answer
Q2. Situational and managerial round questions
Add your answer

Q1. Basic salary negotiation
Add your answer
Q2. Situational base question
Add your answer

Q1. Basic experience related questions
Add your answer

Q1. Similar to L1.Interviewed with senior manager.
Add your answer

Q1. Team fit round with Director
Add your answer

Q1. Salary Discussion
Add your answer

Q1. Round 1: This is an initial screening round. You will be tested on the foundation of multiple technologies. SQL (Majority), Python, Visualization skillset and some basic statistics. Round 2 : Advance t...read more
Add your answer

Q1. Wxaplinnyour project
Add your answer
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
Answered by AI
Add your answer
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...read more
Answered by AI
Add your answer
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.
Answered by AI
Add your answer
Q5. Get second highest salary usingSQL
Add your answer

Group descuisson company job part time work from Home

Q1. Billing any idea
Ans. 
Billing involves creating and sending invoices to customers for products or services rendered.
• Billing is the process of generating invoices for goods or services provided to customers.

• It includes recording transactions, calculating charges, and sending bills to clients.

• Accuracy and attention to detail are crucial in billing to ensure correct invoicing.

• Examples of billing software include QuickBooks, FreshBooks, and Zoh
Answered by AI
Add your answer
Q2. Data entry operator
Add your answer

Assignment submission work from Home business development manager office dmart big marking

Python and sql based questions

Data entry, system operator,sales management, coding sarvese

Sales management
coding sarvese
data entry
System operator working

Q1. Which was the data entry meening
Add your answer
Q2. System operator
Add your answer

Sales management
Coding sarvese
Operator working sales management
Group discussion

Q1. Typing speed , self introduction, comunication skills
Add your answer
Q2. Self introduction
Add your answer
Q3. Computation skills
Add your answer
Q4. Typing speed 30wpm, self introduction
Add your answer
Q5. I have good knowledge Ms word, Excel, Power point and typing speed
Add your answer
Q6. Self introduction, comunication skills
Add your answer