Deloitte Portfolio Administrator Interview Questions and Answers

Q1. Technical work related questions
Add your answer

Q1. Partner's round, again technical questions
Add your answer

Q1. Where do you see yourself in next 5 years
Add your answer
Q2. Are willing to start immediately
Add your answer
Q3. Tell us about your previous job experience
Add your answer
Q4. Why do u want to work with PwC
Add your answer
Q5. Do you know excel.And if Yes,What do u know
Ans. 
Yes, I know Excel. I am proficient in using formulas, pivot tables, charts, and macros.
• Proficient in using formulas such as VLOOKUP, IF, SUMIF, COUNTIF, etc.

• Expertise in creating pivot tables and charts for data analysis and visualization.

• Experience in automating tasks using macros and VBA programming.

• Familiarity with advanced Excel functions like INDEX-MATCH, array formulas, and conditional formatting.

• Ability to handl...read more
Answered by AI
Add your answer

Prepare questions from all basic topics

Q1. Basic questions on recruitment.
Add your answer

Q1. Technical recruitment process question.
Add your answer
Q2. Xray search strings
Add your answer

Q1. Most of the interview was focused around SQL combine with case study assessment.
Add your answer
Q2. Explanation of joins
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from th...read more
Answered by AI
Add your answer
Q3. Order of execution concept
Ans. 
Order of execution concept refers to the sequence in which instructions are executed in a program.
• Instructions are executed in the order they appear in the code unless specified otherwise.

• Some programming languages have specific rules for order of execution, such as PEMDAS in mathematics.

• Understanding order of execution is crucial for debugging and optimizing code.

• Example: In Python, arithmetic operators follow the PEM
Answered by AI
Add your answer
Q4. Explanation on nulls
Ans. 
Nulls are placeholders for missing or unknown values in a database.
• Nulls represent the absence of a value in a database field.

• Nulls are different from empty strings or zero values.

• Nulls can cause issues in database queries if not handled properly.

• Nulls can be used to indicate missing data or unknown values.

• Nulls can be replaced with default values or handled using functions like COALESCE.
Answered by AI
Add your answer

Q1. This was taken with Director which focused mainly on behaviour, career plans and other relevant scenario and ethics.
Add your answer