Odoo Full Stack Developer Interview Experience

Last month, I applied for a full stack developer role at Odoo through their official website. Surprisingly, I got a call and email the very next day inviting me to take an online test. Here's a breakdown of my interview process and some insights for anyone preparing for a similar role at Odoo.

Round 1: The Online Test

The test was a mix of technical and problem-solving questions. It included:

1.MCQs: These covered the basics of HTML, CSS, JavaScript, and React. The questions were pretty straightforward but required clarity on core concepts.

2.DSA Questions:

• 1 easy-level problem
• 1 medium-level problem

3.SQL: This was a slightly challenging question involving complex queries.

I managed to clear this round and got an email within 10 days inviting me for the next stage

Round 2: English and Logical Tests

This round was split into two parts:

English Test:

• The task involved writing client-facing emails to troubleshoot issues. I had to draft three different responses for hypothetical client problems. It tested clarity, tone, and professionalism in communication.

Logical and Math Test:

• Standard logical reasoning and math puzzles to evaluate problem-solving skills.

Thankfully, I cleared this round too.

Round 3: Technical Interview

This was the most intense part of the process. It was a live coding round with a very supportive interviewer who let me decide the tech stack for the task. Here’s how it went:

Task: Build a full stack web application with the following features:

• Product page
• Shopping cart
• Filters and search functionality (with debounce)
• Database connection

Tech Stack: I chose Node.js for the backend, Next.js for the frontend, and SQL for the database as I already had a good understanding of the tables I needed to create.

Expectations:

• CRUD APIs for all operations
• Clean code and working functionalities

The session, scheduled for 2 hours, ended up stretching to 3 hours and 20 minutes. Although the interviewer was helpful and provided guidance whenever I got stuck, I faced issues connecting the database. To keep things moving, I used dummy data for the project.

Additionally, I was asked two SQL questions:

• A SELECTquery with WHERE conditions.
• An INNER JOIN query with logical operators.

My Takeaway

Unfortunately, I wasn’t selected. One thing that left me a bit disappointed was how the coding round extended well beyond the scheduled time. If the decision was to not move forward with me, I felt my time could’ve been respected a bit more.

That said, the process was a great learning experience, and I gained insights into:

• How to approach a full stack app under pressure.
• The importance of staying calm when things don’t go as planned.
• Areas to improve for future interviews, like debugging database issues quickly.

Tips for Odoo Interview Preparation

1. Brush Up on Basics: The MCQs are all about fundamentals, so review core concepts of HTML, CSS, JavaScript, and React.

2. Practice DSA: Ensure you’re comfortable with easy-to-medium level problems, as these are often asked in online tests.

3. SQL Skills: Be ready for advanced SQL queries involving joins and logical operators.

4. Communication Matters: The English test assesses how well you can communicate with clients, so practice writing concise and professional emails.

Be Ready for Full Stack Tasks: The live coding round is demanding.

Focus on:

• CRUD operations
• Search functionality with features like debounce
• Backend and database connectivity
• Time Management: Try to pace yourself, especially during the coding round, as time can slip away quickly.