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.

The above is the detailed content of Odoo Full Stack Developer Interview Experience. For more information, please follow other related articles on the PHP Chinese website!