How I got the interview:

• Through LinkedIn, I received a message from a recruiter about a job conference in my area.
• I attended the conference, where they conducted simple interviews (two per candidate).
• Although I was not well-prepared, I passed the first short interview but did poorly in the second.
• A week later, they contacted me to schedule a phone interview. They called 30 minutes before the scheduled time, but I was driving, so it was cancelled.
• Two days later, I received another call for a full-day onsite interview scheduled for two weeks out.
• The onsite interview consisted of nine interviews with two different teams. Each interview was 45 minutes long, including one with an HR representative during lunchtime.
• After the fourth interview, the recruiter who had contacted me approached me before lunch and said I was doing very well. The first team wanted to hire me as soon as possible.
• I finished all the interviews. After I left, the recruiter contacted me 30 minutes later to say he would be sending me the offer that day.
• Unfortunately, I had visa issues (no H1B sponsorship). They decided they could not sponsor an H1B for me because they wanted to hire someone as soon as possible, so they cancelled the offer.

The interview will cover the following topics:

1. Software Design and Patterns
2. Clustering Techniques and Solutions (from a software perspective)
3. Clustered Caching and Concurrency Issues
4. System Integration Problems and Technologies
5. Extensive Transaction Processing Systems and their Performance
6. SQL Coding (e.g., inner selects, ranking, PARTITION BY)
7. Advanced Java Basics (concurrency, I/O, Collections & HashMaps, algorithms)
8. NoSQL Database Concepts
9. Concepts related to EJB, Web Services (RESTful & SOAP), and JMS
10. Two puzzles requiring algorithms, mathematical formulas, and recursive functions
11. Questions about your previous projects (technical focus)