[ OK ] J3e0SrhTyY — full writeup
[ INFO ] category: Behavioral · Onsite difficulty: difficult freq: first seen: 2024-06-14
[DIFFICULT][ONSITE]OnsiteSWE III (Senior)Accepted
$ cat problem.md
Walmart Interview Experience:
Round 1 (DSA):
3 DSA questions:
- N meetings 1 room (GFG)
- Minimum Platforms Required (GFG)
- Merge Intervals | Merge Intervals (Leetcode)
Round 2 (Same Day): Java + LLD
- Aggregation, Composition, is-a relation, has-a relation
- New features in Java 8 (As I'm working on Java 8)
- Design Patterns using in daily life (I said singleton, builder, Observer, Factory)
- Coded Singleton pattern. Questions on that:
- why making instance as static?
- is static required
- use of static
- How to make sure that getInstance class is thread safe
Ans: using synchronized block/ function
- Code Observer Design Pattern
- How the updated attribute is communicated to all observers
- Volatile keyword
- No. of ways you can achieve multithreading in Java
Ans: -Implement runnable interface
-Extend Thread class
-Executor Service
- Marker Interface
Round 3 (HM round -> After 5 days)
- Discussions on projects
- Biggest Technical challenge in one of the projects
- Design a System to migrate 100,000 rows from 1 DB to Another
- For single instance
- For multiple instances (how to make sure reading of old DB is safe and no record is read twice)
Ans: SQL Locks
Functional Requirements
- No duplicate rows in new DB
- No data loss between two DBs
- No new table should be created. You are free to modify the old table
More Behavioural questions
Verdict: Selected