Deloitte Associate Engineer Interview Questions and Answers

Q1. Tell me about your self
Add your answer
Q2. Why you want join the company.
Add your answer
Q3. What makes you perfect for this position
Add your answer
Q4. What skills you know
Add your answer
Q5. Where do you want see yourself after 1 year.
Add your answer

It comprises of 30 questions from verbal quant.

It comprises of few coding questions related to graph dp.

Q1. About Yourself and work experience.
Add your answer

Q1. Pure technical round with hands-on tools questions.
Add your answer

Q1. What is Spark What is hadoop
Ans. 
Spark is a fast and general-purpose cluster computing system.
• Spark is designed for speed and ease of use in data processing.

• It can run programs up to 100x faster than Hadoop MapReduce.

• Spark provides high-level APIs in Java, Scala, Python, and R.

• It supports various workloads such as batch processing, interactive queries, streaming analytics, and machine learning.

• Spark can be used standalone, on Mesos, or on Hadoop YARN
Answered by AI
Add your answer
Q2. What is hive in big data
Ans. 
Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.
• Hive uses a SQL-like language called HiveQL to query and manage large datasets stored in Hadoop

• It allows users to write complex queries to analyze and process data

• Hive organizes data into tables, partitions, and buckets for efficient querying

• It is commonly used for data warehousing, data analysis, and da
Answered by AI
Add your answer
Q3. Which file format is best
Ans. 
There is no one-size-fits-all answer to which file format is best, as it depends on the specific use case and requirements.
• Consider the type of data being stored or transmitted (e.g. text, images, videos, etc.)

• Take into account compatibility with software and devices that will be used to access the files

• Evaluate factors such as file size, compression, and quality requirements

• Common file formats include PDF for document...read more
Answered by AI
Add your answer

Q1. How will you design ingestion pipeline
Ans. 
Designing ingestion pipeline involves defining data sources, data processing steps, data storage, and data delivery mechanisms.
• Identify data sources such as databases, APIs, files, etc.

• Define data processing steps like data extraction, transformation, and loading (ETL).

• Choose appropriate data storage solutions like databases, data lakes, or data warehouses.

• Implement data delivery mechanisms for downstream applications ...read more
Answered by AI
Add your answer

Easy prepare the topics analytical verbal english quant basic level

Q1. Introduction youself where u from
Add your answer
Q2. What is your favorite subject
Add your answer

Q1. Explain the process in ADF?
Ans. 
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

• It supports a wide range of data sources, including Azure Blob Storage, Azure SQL Database, and on-premises data sources.

• You can use ADF to ingest data from various so...read more
Answered by AI
Add your answer
Q2. Difference between dashboard and report in power BI
Ans. 
Dashboard is a visual display of key metrics and trends, while a report is a detailed collection of data and analysis.
• Dashboard provides a high-level overview, while a report dives deeper into specific data points

• Dashboards are interactive and allow for drill-down capabilities, reports are static

• Dashboards are typically used for monitoring and decision-making, reports are used for in-depth analysis

• Example: A dashboard ...read more
Answered by AI
Add your answer
Q3. Difference between lead and lag in SQL
Ans. 
Lead and lag are SQL functions used to access data from a previous or subsequent row in a result set.
• Lead function is used to access data from a subsequent row in the result set.

• Lag function is used to access data from a previous row in the result set.

• Both functions can be used to compare values between rows or calculate differences.

• Example: SELECT lead(column_name) OVER (ORDER BY column_name) FROM table_name;
Answered by AI
Add your answer

Q1. Why you want to join PWC?
Ans. 
I want to join PWC because of its reputation for providing excellent opportunities for professional growth and development.
• PWC is known for its strong commitment to employee training and development.

• I am impressed by PWC's diverse client base and the opportunity to work on challenging projects.

• I believe PWC's collaborative work environment will allow me to learn from experienced professionals and grow in my career.
Answered by AI
Add your answer
Q2. Why after a promotion this year you want to left your current organization?
Ans. 
Seeking new challenges and growth opportunities in a different environment.
• Looking for new challenges and opportunities for growth

• Interested in exploring different work environments and cultures

• Seeking a change in career path or industry

• Desire for a higher level of responsibility or leadership role

• Wishing to relocate to a different location for personal reasons
Answered by AI
Add your answer

Question from maths reasoning andc

Two leetcode medium questions

Q1. DSA question about binary search
Add your answer
Q2. Situation related questions about work culture
Add your answer