Deloitte Interview Questions, Process, and Tips

Q1. Basic Python, SQL & Spark coding questions.
Add your answer
Q2. Nth highest salary, word count in pyspark
Ans. 
To find the nth highest salary in pyspark, use the window function with row_number and filter on the desired rank.
• Use window function with row_number to assign a rank to each salary

• Filter the result to get the row with the desired rank

• Example: df.withColumn('rank', F.row_number().over(Window.orderBy(F.col('salary').desc()))).filter(F.col('rank') == n).select('salary')
Answered by AI
Add your answer

Q1. Questions on SQL & PySpark.
Add your answer

Q1. Questions about previous projects & optimization techniques etc. Also behavioural
Add your answer

Q1. Salary negotiation part.
Add your answer

Contains logical quants di verbal

Q1. Project desciption and internship
Add your answer
Q2. Us healthcare defination
Add your answer

Q1. Internship role and impact
Ans. 
My internship role involved conducting market research and financial analysis, leading to recommendations that were implemented by the team.
• Researched market trends and competitor analysis to identify growth opportunities

• Performed financial analysis to evaluate investment decisions

• Presented findings and recommendations to senior management

• Collaborated with cross-functional teams to implement strategies

• Contributed to th
Answered by AI
Add your answer
Q2. Strenght and weakness
Add your answer

Q1. ES6 new features
Ans. 
ES6 introduces new features like arrow functions, classes, template literals, let and const declarations, and more.
• Arrow functions provide a more concise syntax for writing functions.

• Classes allow for easier object-oriented programming in JavaScript.

• Template literals enable easier string interpolation and multiline strings.

• let and const declarations provide block-scoped variables.

• ES6 also introduces features like destr...read more
Answered by AI
Add your answer
Q2. Closure and their coding questions
Add your answer
Q3. Lazy loading and redux working in react
Ans. 
Lazy loading is a technique used to defer loading of non-essential resources until they are actually needed, while Redux is a state management library for React applications.
• Lazy loading in React involves dynamically importing components or modules only when they are required, improving performance by reducing initial load times.

• Redux is used in React applications to manage the state of the application in a predictable...read more
Answered by AI
Add your answer
Q4. Call by value & call by reference, object-related, hoisting etc
Add your answer
Q5. How do we optimize the API and rendering in React?
Ans. 
Optimizing API and rendering in React involves reducing unnecessary API calls, using memoization, lazy loading, and code splitting.
• Reduce unnecessary API calls by batching requests or using GraphQL to fetch only required data.

• Use memoization techniques like useMemo and useCallback to prevent unnecessary re-renders.

• Implement lazy loading for components that are not immediately needed, improving initial load time.

• Utilize...read more
Answered by AI
Add your answer

Aptitude+CS fundamentals MCQ speed is the main game

Topic-Impact of Upi going global on india....FIRST GD THEN DEBATE THEN THE INTERVIEWER ASKED ONE-ONE QN TO EACH CANDIDATE.

Q1. Explain Projects on ur resume
Ans. 
Managed various projects including market research, product launches, and process improvements.
• Led cross-functional teams to successfully launch new products

• Conducted market research to identify new opportunities for growth

• Implemented process improvements to increase efficiency and reduce costs
Answered by AI
Add your answer
Q2. Why NOSQL instead of SQL
Ans. 
NoSQL offers flexibility, scalability, and better performance compared to SQL databases.
• NoSQL databases are schema-less, allowing for more flexibility in data storage and retrieval.

• NoSQL databases can easily handle large amounts of unstructured data, making them ideal for big data applications.

• NoSQL databases are designed for horizontal scalability, allowing for easy distribution of data across multiple servers.

• NoSQL d...read more
Answered by AI
Add your answer
Q3. What you know about cloud
Ans. 
Cloud computing refers to the delivery of computing services over the internet, including storage, servers, databases, networking, software, and analytics.
• Cloud computing allows users to access and store data and applications on remote servers rather than on local computers.

• It offers scalability, flexibility, cost-effectiveness, and increased collaboration.

• Examples of cloud services include Amazon Web Services (AWS), M
Answered by AI
Add your answer