Deloitte Senior PMO Analyst Interview Questions and Answers

Q1. Tell me about yourself ?
Add your answer
Q2. What are few major projects that you had in your work ?
Add your answer

Q1. Questions related to your work domain ?
Add your answer
Q2. Any software that you used (Although they will ask opposite of the software you have experience with)
Add your answer

Set of questions on english , aptitude , all are at easy level

Sql basics and some query questions

Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
Add your answer
Q2. Question on real life scenarios
Add your answer

Q1. Salary expectation
Add your answer
Q2. When can u join
Add your answer

The aptitude test was interesting, Had a bunch of fun puzzles

Q1. Tell me about yourself
Ans. 
I am a detail-oriented business analyst with a strong background in data analysis and problem-solving.
• Experienced in gathering and analyzing business requirements

• Skilled in creating data models and visualizations

• Proficient in using tools like SQL, Excel, and Tableau

• Strong communication and presentation skills

• Certified in business analysis (e.g. CBAP)
Answered by AI
Add your answer
Q2. Where do you see yourself in 5 years
Add your answer

Q1. How to measure risk & returns
Add your answer
Q2. Investment due diligence and performance calculation
Add your answer
Q3. Why we should hire you
Add your answer
Q4. Why you want to switch job
Add your answer
Q5. Fixed income valuation methods
Add your answer

Q1. Explain all types of joins
Ans. 
Different types of joins in SQL are inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a match in both tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full outer join: Returns rows when there is a match in either table
Answered by AI
Add your answer
Q2. Difference between having and where
Ans. 
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
• HAVING is used with GROUP BY to filter groups based on aggregate functions results

• WHERE is used to filter rows based on conditions

• HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY

• Example: SELECT department, AVG(salary) FROM employees GROU...read more
Answered by AI
Add your answer

It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.

Q1. What is the difference between where and having clause ?
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE co...read more
Answered by AI
Add your answer
Q2. One ques was a guesstimate problem.
Add your answer

Q1. Self Introduction.
Add your answer
Q2. Business case problem which was to be solved in 15 minutes.
Add your answer

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Q1. What is DSA , sorting , difference between array and linked list
Ans. 
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
• DSA stands for Data Structures and Algorithms

• Sorting is the process of arranging data in a particular order

• Arra...read more
Answered by AI
Add your answer
Q2. Written a SQL query
Add your answer

Q1. Coding question like add numbers
Add your answer
Q2. Experience on your project
Ans. 
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
• Developed predictive models to forecast customer behavior and optimize marketing strategies

• Conducted market research to identify trends and opportunities for growth

• Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Answered by AI
Add your answer