Wells Fargo Interview Experience for Analyst Intern 2024

Wells Fargo visited our college offering an Intern Analyst role for the Summer of 2025. Eligibility: 6 CGPA+
Branches: CS/IT/ENTC
A total of 380 students were shortlisted for the Online Assessment Test.

Online Assessment:
Platform: SHL Amcat
This section comprised four parts:

• Verbal Assessment: 12 questions to be solved in 15 minutes. Questions were based on comprehension and filling in appropriate words in a sentence, testing our English skills at a moderate level.
• Business Interpretation: 15 questions to be solved in 25 minutes. Questions were based on various graphs and charts. Candidates had to analyze them properly and answer the questions. There were candlestick graphs, pie charts, and other business-related charts. Tip: Take some time to analyze it properly; this way, you won't have to repeatedly check it for every question. Revise basic formulas related to Venn diagrams, profit, and loss, etc.
• Coding: 2 coding questions in 40 minutes. Everyone had different questions based on arrays and string manipulation. Difficulty level was easy to medium. Time was a crucial factor. I passed 12/12 test cases for the first question and 15/17 test cases for the second question.
• One separate coding question in 10 minutes: This was generally a question based on logic and mathematics, requiring no specific data structure. I passed 1/3 test cases.

Tip for Online Assessment: You cannot move back and forth between questions. Attempt accordingly. Time management is crucial, so don't waste too much time on a single question.

Out of 380 students, 27 were shortlisted for interviews.

Interview Round 1: Technical
Duration: 1 hour

1. The interviewer asked about my extracurricular activities to make me feel comfortable.
2. Coding Problem 1: Search for an element in an unsorted and sorted matrix (use different approaches for both).
3. Coding Problem 2: Sort an n x n matrix (row-wise and column-wise).
4. Discussed projects in detail and their future scope.
5. Answered 4-5 MySQL queries on all types of joins.
6. Explained client-server architecture in DBMS.
7. Questions for the interviewer.

Interview Round 2: Technical
Duration: 45 minutes

1. Discussed APIs and how to integrate them.
2. Questions on Java Servlets.
3. Explained Java Bean class.
4. Discussed unit testing in software engineering.
5. Factors to consider when deciding between RDBMS and NoSQL.
6. Asked to design a database system for my DSA project.
7. In-depth questions about NoSQL (all application-based with many follow-up questions on my answers).
8. Discussed system logs in DBMS and Java files.
9. Explained static classes and their uses.
10. Discussed garbage collection in Java.
11. Asked if I read tech articles and news; I said yes. He asked me to mention 5 startups in India and 3 technology-related news items.
12. Questions for the interviewer.

Tip: Don't just read the theory of DBMS; understand every concept in detail and why we are doing what we are doing. This way, you can tackle application-based questions. Even if you don't know certain answers, it's fine—just try to give it a shot. They typically check your approach and thinking, and how much effort you put in.

Interview Round 3: HR
Duration: 20 minutes

1. Family background.
2. How I manage studies and all my extracurricular activities (since I had many).
3. Follow-up questions on my achievements.
4. Discussed my ML project since it intrigued her—asked about parameters we considered.
5. Asked about my social and networking skills.
6. Questions for the interviewer.

Overall, we talked a lot since both of us were very talkative.

Verdict: SELECTED!