Wells Fargo Interview Questions, Process, and Tips

Q1. Filters in Tableau
Ans. 
Filters in Tableau allow users to focus on specific data points within a visualization.
• Filters can be applied to dimensions or measures to narrow down the data being displayed.

• Users can use various types of filters such as quick filters, context filters, and data source filters.

• Filters can be used to show or hide data based on specific criteria, such as date ranges or categories.

• Example: Applying a filter to show only
Answered by AI
Add your answer
Q2. Blending and joins in Tableau
Ans. 
Blending and joins in Tableau allow users to combine data from multiple sources for analysis and visualization.
• Blending is used when data sources have a common field but different levels of granularity.

• Joins are used when data sources have a common field and the same level of granularity.

• Blending creates a virtual join, while joins physically combine the data.

• Examples: Blending sales data from Excel with customer data ...read more
Answered by AI
Add your answer
Q3. LOD expressions in Tableau
Ans. 
LOD expressions in Tableau allow you to compute values at different levels of detail in a visualization.
• LOD expressions include FIXED, INCLUDE, and EXCLUDE functions

• FIXED LOD expressions compute values at a specific level of detail regardless of the visualization level

• INCLUDE LOD expressions compute values at the specified level of detail and include other dimensions in the visualization

• EXCLUDE LOD expressions compute ...read more
Answered by AI
Add your answer
Q4. Different types of Joins in SQL, difference between TRUNCATE and DELETE
Ans. 
Different types of joins in SQL include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN. TRUNCATE is faster than DELETE as it removes all rows at once.
• Types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

• TRUNCATE: removes all rows from a table without logging individual row deletions

• DELETE: removes specific rows from a table and logs each row deletion

• TRUNCATE is faster than DELETE as it does not log individual
Answered by AI
Add your answer

Q1. About my technical experience
Add your answer
Q2. What will you do if you get the offer from multiple companies
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. How do you approach product prioritization?
Ans. 
I approach product prioritization by considering customer needs, market trends, business goals, and impact on resources.
• Understand customer needs and pain points

• Evaluate market trends and competition

• Align with business goals and strategy

• Consider impact on resources and timeline

• Use frameworks like MoSCoW method or RICE score for prioritization
Answered by AI
Add your answer
Q3. If a bug needs to be prioritised before a release, how would you influence the stakeholders?
Ans. 
Influence stakeholders by highlighting impact on user experience, revenue, and reputation.
• Explain the severity of the bug and its potential impact on user experience

• Highlight the financial implications of releasing a product with known bugs

• Emphasize the potential damage to the company's reputation if the bug is not addressed

• Present data or examples to support your arguments
Answered by AI
Add your answer

Q1. Team, release and scenario based questions
Add your answer

Q1. Key value proposition of your product roadmap
Ans. 
Our product roadmap focuses on delivering innovative features that enhance user experience and drive customer satisfaction.
• Prioritizing customer feedback to guide feature development

• Leveraging market research to identify trends and opportunities

• Collaborating cross-functionally to ensure alignment with business goals
Answered by AI
Add your answer

Q1. Salary negotiation
Add your answer

Underwriting. Personal Information

What is your full name, Social Security Number, and date of birth?

Are you a U.S. citizen or permanent resident?


Why they ask: To verify your identity and eligibility for a mortgage.

2. Income and Employment

What is your annual income?

Are you employed, self-employed, or retired?

How long have you been at your current job?


Why they ask: To ensure you have a steady income to repay the loan.

3. Credit History

What is your credit score?

Do you have any outstanding loans, credit card debt, or missed payments?

Have you ever declared bankruptcy or had a foreclosure?


Why they ask: To assess your ability and reliability to repay the loan.

4. Assets and Savings

How much money do you have in savings, investments, or retirement accounts?

Do you own any other properties or assets?


Why they ask: To confirm you have enough funds for a down payment, closing costs, and emergency reserves.

5. Property Details

What is the purchase price of the home?

Are you buying a primary residence, second home, or investment property?

What is the home’s address and type (e.g., single-family, condo)?


Why they ask: To evaluate the value and purpose of the property as collateral for the loan.

6. Debts and Expenses

What are your monthly expenses, including rent, utilities, and other bills?

Do you owe child support or alimony?


Why they ask: To calculate your debt-to-income (DTI) ratio and ensure you can afford the mortgage payments.

7. Down Payment

How much are you planning to put down as a down payment?

Are the funds coming from your savings or a gift?


Why they ask: To verify you have a sufficient down payment and its source is legitimate.

8. Insurance and Taxes

Do you have homeowners insurance lined up?

Are you aware of the property taxes in the area?

Q1. Previous Employment
Add your answer