Visa | SDE 1

Current Experience: 1.10 Years

College: Tier-2

Previous Organization: One of the MNCs

Applied through portal.

OA

The Online Assessment included the following problems:

• Longest Substring Without Repeating Characters
• Letter Combinations of a Phone Number

1st Round (Coding)

This round involved coding questions.

2nd Round (Technical Discussion)

AGENDA: Focus areas for SWE framework Coding Quality Engineering Fundamentals Collaborate as OneVisa/Execute

Questions covered:

• Spring boot annotations - controller, service, transactional
• Autowiring - what it is? How it works?
• SQL vs NoSQL - vertical scaling vs horizontal scaling
• Pass by reference and pass by value
• Static vs non static
• 2-sum problem
• 3-sum problem

During writing code, the interviewer was asking questions like "why you used this and that type of questions."

SQL questions:

• Problem: print number of students in each dep where cgpa > 9

  My query: select Dep, count(*) as count from student group by Dep having cgpa > 9;

• Problem: duplicate row in the table

  My query: select * from student groupby studentId having count(*) > 1;

Outcome:

I was not able to provide an optimized solution for the 3-sum problem. I gave an N^2+NlogN solution and he was expecting an N^2 solution only.

I was also not able to provide correct answers for a few conceptual Java questions.

Verdict: rejected.

Other interview experience: https://leetcode.com/discuss/post/6834384/all-interview-experiences-switch-journey-vpu1/