Deloitte Manager/Sr Manager - Facility Management Interview Questions and Answers

Q1. Project related discussions
Add your answer
Q2. Meduim level SQl and DSA
Add your answer

Q1. This was data modelling round
Add your answer
Q2. Design a uber data model
Ans. 
Uber data model design for efficient storage and retrieval of ride-related information.
• Create tables for users, drivers, rides, payments, and ratings

• Include attributes like user_id, driver_id, ride_id, payment_id, rating_id, timestamp, location, fare, etc.

• Establish relationships between tables using foreign keys

• Implement indexing for faster query performance
Answered by AI
Add your answer

Q1. Project explaining
Add your answer
Q2. Write code to generate csv file with note pad data
Ans. 
Code to generate a CSV file with notepad data
• Open a text file and read the data

• Parse the data and write it to a CSV file

• Use libraries like pandas in Python for easier CSV handling
Answered by AI
Add your answer

Maxium sub string and reverse a string

Q1. 1. What is columnar storage,parquet,delta? Why it is used
Ans. 
Columnar storage is a data storage format that stores data in columns rather than rows, improving query performance.
• Columnar storage stores data in a column-wise manner instead of row-wise.

• It improves query performance by reducing the amount of data that needs to be read from disk.

• Parquet is a columnar storage file format that is optimized for big data workloads.

• It is used in Apache Spark and other big data processing ...read more
Answered by AI
Add your answer
Q2. 2.list ,tuple,set in python 3.sql groupby and window function ,union
Add your answer
Q3. 3. Explain detail project architecture
Ans. 
The project architecture involves the design and organization of data pipelines and systems for efficient data processing and storage.
• The architecture includes components such as data sources, data processing frameworks, storage systems, and data delivery mechanisms.

• It focuses on scalability, reliability, and performance to handle large volumes of data.

• Example: A project architecture may involve using Apache Kafka for ...read more
Answered by AI
Add your answer
Q4. 4. How to connect SQL server to databricks
Ans. 
To connect SQL server to Databricks, use JDBC/ODBC drivers and configure the connection settings.
• Install the appropriate JDBC/ODBC driver for SQL server

• Configure the connection settings in Databricks

• Use the JDBC/ODBC driver to establish the connection
Answered by AI
Add your answer
Q5. Optimisation techniques used
Ans. 
Optimisation techniques used in data engineering
• Partitioning data to improve query performance

• Using indexing to speed up data retrieval

• Implementing caching mechanisms to reduce data access time

• Optimizing data storage formats for efficient storage and processing

• Parallel processing and distributed computing for faster data processing

• Using compression techniques to reduce storage space and improve data transfer

• Applying qu...read more
Answered by AI
Add your answer

Q1. Data warehouse concepts
Add your answer

Q1. Pyspark related questions.
Add your answer

The test was conducted on AMCAT by SHL. The questions were pretty moderate

Q1. I was asked SQL and about my project on data science. The interview was not much difficult
Add your answer
Q2. I was also asked a riddle. 9 coins with 1 coin having different weight - find odd one out
Add your answer

Q1. Was asked DBMS and about my project
Add your answer

Q1. Maximum salary for each department in sql
Add your answer