Deloitte Interview Questions, Process, and Tips

Simple quat questions

Q1. Which language you are comfortable in and write code for any sorting algorithm you know
Add your answer
Q2. What is oops
Add your answer

1. Print the duplicate characters from a string. 2. Take two character arrays and check whether character array 2 is a subarray of character array 1.

Q1. Questions on REST APIs, multi threading etc
Add your answer
Q2. Questions on Maven, excel handling code, JSON parsing etc
Add your answer

Q1. Topics asked Advanced SQL spark dataproc Bigquery Qliksense Git Hub Any innovations or process optimised or not Google Cloud
Add your answer

Q1. Bigquery spark hadoop hive questions asked on above topics Why are you changing? what extra can you bring with you? whats motivating you to join Deloitte?
Add your answer

Q1. Why do we have @functionalInterface if we can make any interface as functional interface if it already has one abstract method?
Ans. 
Functional interfaces provide clarity and enforce single abstract method constraint.
• Functional interfaces provide clarity to developers by explicitly indicating that the interface is intended to be used as a functional interface.

• Using @FunctionalInterface annotation helps enforce the single abstract method constraint, preventing accidental addition of more abstract methods.

• It also allows the compiler to perform additio...read more
Answered by AI
Add your answer
Q2. What is comparable and how to implement it?
Ans. 
Comparable is an interface in Java used for comparing objects and sorting collections.
• Comparable interface is used to define a natural ordering of objects.

• To implement Comparable, a class must implement the compareTo() method.

• Example: Implementing Comparable interface in a class to compare instances based on a specific attribute.
Answered by AI
Add your answer

It cover the topics like computer networking , cloud computing ,testing

Q1. Introduce yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• Bachelor's degree in Statistics

• Proficient in Excel, SQL, and data visualization tools

• Experience in conducting market research and trend analysis

• Strong analytical and critical thinking skills

• Excellent communication and presentation abilities
Answered by AI
Add your answer
Q2. What is constraint
Ans. 
A constraint is a limitation or restriction that prevents something from being done or achieved.
• Constraints can be physical, such as lack of resources or time constraints.

• Constraints can also be imposed by rules, regulations, or limitations set by external factors.

• Constraints can impact decision-making and problem-solving processes.

• For example, a budget constraint may limit the amount of money available for a project.

• A...read more
Answered by AI
Add your answer
Q3. Difference between null and blank
Ans. 
Null represents absence of a value, while blank represents an empty value or space.
• Null is a specific value that indicates the absence of any data.

• Blank typically refers to an empty value or space, such as an empty string or whitespace.

• In programming, null is often used to represent a variable that has not been assigned a value, while blank may refer to a field that has not been filled in by a user.

• Example: A database ...read more
Answered by AI
Add your answer
Q4. What is foreign key and primary key
Ans. 
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.
• Primary key ensures uniqueness of each record in a table

• Foreign key establishes a relationship between two tables

• Example: In a 'students' table, 'student_id' can be a primary key, while in a 'courses' table, 'student_id' can be a foreign key linking to 'students' table
Answered by AI
Add your answer
Q5. Python vs pyspark
Ans. 
Python is a general-purpose programming language, while PySpark is a distributed computing framework built on top of Spark for big data processing.
• Python is a versatile language used for various applications, including web development, data analysis, and automation.

• PySpark is specifically designed for processing large datasets in parallel across a cluster of machines.

• Python is easier to learn and more widely used, whil...read more
Answered by AI
Add your answer

Q1. Basic question related to Java and spring boot
Add your answer

Q1. Current Project role and responsibilites.
Ans. 
Leading a team of developers in designing and implementing a new web application for a financial services company.
• Managing a team of developers to ensure project milestones are met

• Designing the architecture of the web application

• Implementing new features and functionalities based on client requirements

• Conducting code reviews and providing technical guidance to team members
Answered by AI
Add your answer