i
Wells Fargo
Compare
Filter interviews by
Wells Fargo Analyst and Consultant Interview Questions, Process, and Tips
Wells Fargo Analyst and Consultant Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Mar 2023. There were 2 interview rounds.
(5 Questions)
- Q1. Difference between delete, drop, truncate
- Ans.
Delete, drop, and truncate are SQL commands used to remove data from a table.
DELETE command removes specific rows from a table
DROP command removes an entire table from the database
TRUNCATE command removes all rows from a table
- Q2. What is windows key in oracle
- Ans.
Windows key in Oracle refers to the key used to access the Start menu and other Windows features while using Oracle applications.
The Windows key can be used to quickly switch between Oracle applications and other open programs on the computer.
Pressing the Windows key + D will minimize all open windows and show the desktop.
The Windows key can also be used to open the Run dialog box and access various system settings.
In ...
- Q3. Types of lod functions in tableau
- Ans.
LOD functions in Tableau are used to perform calculations at different levels of detail.
FIXED LOD functions: used to create a calculation that is independent of the level of detail in the view
INCLUDE LOD functions: used to create a calculation that includes a specific dimension in the view
EXCLUDE LOD functions: used to create a calculation that excludes a specific dimension in the view
Examples: {FIXED [Region]: SUM([Sa...
- Q4. Write a query to delete null values in oracle
- Ans.
Query to delete null values in Oracle
Use the DELETE statement with the IS NULL condition
Specify the table name and column name in the WHERE clause
Commit the changes after executing the query
- Q5. Why we are using fixed lod
- Ans.
Fixed LOD is used to create a level of detail that remains constant regardless of the view's dimensions.
Fixed LOD helps in maintaining a consistent level of detail in the visualization.
It is useful when we want to focus on a specific aspect of the data.
Fixed LOD can be used to create a reference line or a benchmark for comparison.
For example, we can use fixed LOD to show the average sales for a specific category of pro
Interview Preparation Tips
- Tableau
- Oracle SQL
Skills evaluated in this interview
What people are saying about Wells Fargo
Interview questions from similar companies
I applied via LinkedIn and was interviewed in Dec 2024. There was 1 interview round.
(6 Questions)
- Q1. Explain your last project and your role in this project
- Ans.
Led a team in implementing a new CRM system for a large retail company
Managed project timeline and deliverables
Collaborated with stakeholders to gather requirements
Provided training and support to end users
Ensured successful implementation and user adoption
Improved customer data management and analytics
- Q2. Overall working experience with other companies
- Ans.
I have over 10 years of experience working with various companies in consulting roles.
Managed client relationships and delivered successful projects on time and within budget
Led cross-functional teams to drive business growth and improve operational efficiency
Developed and implemented strategic plans to address client needs and achieve objectives
- Q3. Why choose kafka over MQ ? what challenges you faced during kafka implementation ?
- Ans.
Kafka is chosen for its scalability and fault tolerance compared to MQ.
Kafka offers higher throughput and lower latency compared to MQ.
Kafka is horizontally scalable, allowing for easy expansion as data volume grows.
Kafka provides fault tolerance through replication of data across multiple brokers.
Challenges faced during Kafka implementation may include setting up proper configurations, ensuring data consistency, and m...
- Q4. Monolith to microservice migration journey ? what all decisions needs to be taken and how the entire migration took place.
- Ans.
Monolith to microservice migration involves breaking down a large application into smaller, independent services.
Evaluate the current monolith architecture and identify the components that can be decoupled into microservices.
Define the boundaries of each microservice to ensure they are cohesive and loosely coupled.
Choose the right technology stack for each microservice based on its requirements and scalability needs.
Im...
- Q5. If worked for RestAPI ? what is the use of swagger ? what is the content of Swagger documentation ?
- Ans.
Swagger is a tool used for documenting and testing REST APIs.
Swagger is used for documenting REST APIs by providing a user-friendly interface to view and interact with API endpoints.
It allows developers to easily understand the functionality of an API, including available endpoints, request/response formats, and authentication methods.
Swagger documentation typically includes information such as API endpoints, request p...
- Q6. Only this was asked to me , and rejected
Interview Preparation Tips
Suraj Kumar
Selected
I applied via Naukri.com and was interviewed in Jan 2024. There were 3 interview rounds.
Market research case study
(2 Questions)
- Q1. Question regarding previous Profiles.
- Q2. What roles and what kind do you handled.
(1 Question)
- Q1. Mainly salary negotiation
Associate Consultant Interview Questions & Answers
Northern Trust Operating Services
Anonymous
posted on 16 Feb 2024
Selected
I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Fund accounting workflow
- Q2. Fund accounting Investone platform
(3 Questions)
- Q1. What will happen if trades not booked
- Ans.
If trades are not booked, it can lead to financial discrepancies and inaccurate reporting.
Unbooked trades can result in incorrect profit and loss calculations.
It can lead to discrepancies in portfolio valuations.
Unbooked trades can cause delays in settlement and payment processes.
It can result in inaccurate reporting to clients and regulatory authorities.
Failure to book trades can lead to compliance issues and potentia
- Q2. What is the important spectra in sunguard ole
- Ans.
The important spectra in Sunguard Ole are UV-A and UV-B.
UV-A and UV-B are the two important spectra in Sunguard Ole.
UV-A has longer wavelengths and can penetrate deeper into the skin, causing long-term damage.
UV-B has shorter wavelengths and is responsible for sunburns and immediate skin damage.
Sunguard Ole provides protection against both UV-A and UV-B rays.
It is important to use sunscreen with broad-spectrum protecti
- Q3. What is screen to check fund currency details
- Ans.
The screen to check fund currency details is the Currency Details screen.
The Currency Details screen provides information about the currency of a fund.
It displays the currency code, name, symbol, and exchange rate of the fund.
Users can access this screen by navigating to the fund details page and selecting the 'Currency Details' option.
The screen may also show historical exchange rates and any recent updates or changes
R W
(2 Questions)
- Q1. C++, com component, oops concept
- Q2. General interview questions on knowledge.
I applied via Job Portal and was interviewed in Nov 2023. There was 1 interview round.
(1 Question)
- Q1. Java basics, microservices design patterns , java design patterns, no sql db concepts and queries, new features in java.
Selected
I applied via Referral and was interviewed in Jan 2023. There were 3 interview rounds.
Basic accounting and corporate knowledge and financial expertise
(1 Question)
- Q1. About me and organisation and communication skill
(2 Questions)
- Q1. Basic of stock market and finance
- Q2. Reconciliation and corporate action
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before Jun 2023. There were 2 interview rounds.
(3 Questions)
- Q1. Self introduction
- Q2. Strengths and weakness
- Q3. What is your long term goal
(6 Questions)
- Q1. Profile summary
- Q2. Previous experience
- Q3. Capital markets
- Q4. Financial instruments
- Q5. What are the challenges you faced in previous job
- Q6. Any appreciations or achievements in previous job?
Interview Preparation Tips
I applied via Referral and was interviewed before Jun 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. Process is throwing Out of Memory Error , describe the steps you will take to debug and then interviewer went down in Memory Management concepts and garbage collection algo's of JVM in great detail.
- Ans.
To debug Out of Memory Error, analyze memory usage and garbage collection algorithm of JVM.
Analyze heap dump to identify memory leaks
Check if JVM is running out of heap space
Analyze garbage collection logs to identify any issues
Tune JVM parameters to optimize memory usage
Consider using a profiler to identify memory-intensive code
Check for any large objects or arrays that may be causing the issue
- Q2. Design automated Parking Lot.
- Ans.
Automated parking lot design with efficient space utilization and user-friendly interface.
Use sensors to detect available parking spots
Implement a central computer system to manage parking allocation
Incorporate user-friendly interface for easy navigation and payment
Maximize space utilization with multi-level parking and compact car storage
Ensure safety measures are in place for pedestrians and vehicles
- Q3. Design Something similar as auto correct/suggestions functionality of Google search.
- Ans.
Design an auto-suggestion feature for a search engine.
Implement a search algorithm that suggests relevant keywords based on user input.
Use machine learning to improve the accuracy of suggestions over time.
Allow users to easily select and add suggested keywords to their search query.
Interview Preparation Tips
First define the problem statement and write down all requirements on paper.
Writing down the requirements and clarify the assumptions are two most important task in any system design question.
Remember nobody expects you to design fully functional auto-correct functionality, or Zomato app, or parking lot in one hour.
It took many months for any development team to get these kind of design right and sometime applications have to be redesign multiple times in reality.
In interview what people want to see is that how well you think,are you able to connect the dots in your design and can you come up with high level prototype which is generic and scalable.
I have seen people got lost in little nuances/edge scenarios which doesn't matter in larger scheme of things, so
1. Focus on big picture first.
2. Get your high level entity design, Schema Design right.
3. Then connect the dots and focus of if we can scale the system or enhance the system if required.
4. Try to accommodate any edge case scenario.
Generally, if you get first three steps rights , in one hour or so that's enough for you to crack the round.
Skills evaluated in this interview
Principal Consultant Interview Questions & Answers
Fidelity Investments
Anonymous
posted on 21 Sep 2021
I applied via Referral and was interviewed before Sep 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. They asked about cics,db2 and mq.
Interview Preparation Tips
Wells Fargo Interview FAQs
Tell us how to improve this page.
Wells Fargo Interviews By Designations
- Wells Fargo Senior Software Engineer Interview Questions
- Wells Fargo Software Engineer Interview Questions
- Wells Fargo Financial Analyst Interview Questions
- Wells Fargo Analytics Consultant Interview Questions
- Wells Fargo Loan Documentation Specialist Interview Questions
- Wells Fargo Analyst Interview Questions
- Wells Fargo Program Associate Interview Questions
- Wells Fargo Senior Financial Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Consultant Interview Questions
- Associate Consultant Interview Questions
- Senior Consultant Interview Questions
- Senior Associate Consultant Interview Questions
- Lead Consultant Interview Questions
- Technical Consultant Interview Questions
- SAP Abap Consultant Interview Questions
- AST Consultant Interview Questions
- Show more
Wells Fargo Analyst and Consultant Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Software Engineer
4.4k
salaries
|  ₹13.1 L/yr - ₹48.4 L/yr |
|
Financial Analyst
2.6k
salaries
| ₹2.1 L/yr - ₹9.4 L/yr |
|
Software Engineer
1.8k
salaries
| ₹7.9 L/yr - ₹32 L/yr |
|
Senior Financial Analyst
1.4k
salaries
| ₹3.4 L/yr - ₹9 L/yr |
|
Assistant Vice President
1.4k
salaries
| ₹12.3 L/yr - ₹45 L/yr |
HSBC Group
Standard Chartered
JPMorgan Chase & Co.
Bank of America
- Home >
- Interviews >
- Wells Fargo Interview Questions >
- Wells Fargo Analyst and Consultant Interview Questions
