Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Capgemini Team. If you also belong to the team, you can get access from here

Capgemini Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Capgemini ODI Developer Interview Questions and Answers

Updated 28 May 2024

Capgemini ODI Developer Interview Experiences

1 interview found

ODI Developer Interview Questions & Answers

user image Anonymous

posted on 28 May 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. What is Slowly changing dimension. And How many types of SCD's we have.
  • Ans. 

    Slowly changing dimension (SCD) is a concept in data warehousing that describes how dimensions change over time.

    • SCD Type 1: Overwrites old data with new data, losing historical information.

    • SCD Type 2: Keeps multiple versions of the same dimension, creating new records for each change.

    • SCD Type 3: Keeps both old and new values in the same record, with separate columns for each version.

    • SCD Type 4: Uses separate tables to ...

  • Answered by AI
  • Q2. Tell me about Check Knowledge Module
  • Ans. 

    Check Knowledge Module is used in ODI to validate data before loading it into target tables.

    • It is used to perform data quality checks on the source data

    • It can be used to check for duplicates, missing values, data format, etc.

    • It helps ensure that only clean and accurate data is loaded into the target tables

  • Answered by AI
  • Q3. Types of Knowledge Modules
  • Ans. 

    Knowledge Modules in ODI are reusable components that define the logic for performing specific tasks in the ETL process.

    • Types include Loading Knowledge Modules, Integration Knowledge Modules, Check Knowledge Modules, Reverse-Engineering Knowledge Modules, and Service Knowledge Modules.

    • Loading Knowledge Modules handle data loading into target tables.

    • Integration Knowledge Modules handle data integration between source an...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected
Round 1 - Technical 

(5 Questions)

  • Q1. React Life cycle
  • Q2. What React hooks have you utilized in your projects?
  • Q3. What is Redux, and what are the differences between Redux and Context?
  • Q4. What is the difference between visibility: hidden and display: none in CSS?
  • Q5. What are JavaScript closures, the temporal dead zone (TDZ), hoisting, and the JavaScript engine?
Round 2 - Coding Test 

Identify the duplicate character in the string.

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jan 2025.

Round 1 - Coding Test 

Trips for cracking interview

Round 2 - Technical 

(5 Questions)

  • Q1. For example how to replay for all questions
  • Q2. Different questions for all types
  • Q3. Interviews easily cracking trips
  • Q4. How to get good job in software
  • Q5. How to get job

Interview Preparation Tips

Interview preparation tips for other job seekers - Differently thinking for all types of questions and answers
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Dec 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Why did you choose the flask over the django and fastapi?
  • Ans. 

    I chose Flask over Django and FastAPI due to its simplicity, flexibility, and ease of use for smaller projects.

    • Flask is lightweight and minimalistic, making it easier to set up and use for smaller projects.

    • Flask allows for more flexibility in terms of project structure and customization compared to Django.

    • Flask is well-suited for rapid prototyping and smaller applications where simplicity is key.

    • Django, on the other ha...

  • Answered by AI
  • Q2. Write the code for flask request and response block?
  • Ans. 

    Flask request and response block code snippet

    • Use Flask's request object to access incoming request data

    • Use Flask's jsonify function to create a JSON response

    • Handle different HTTP methods like GET, POST, etc. in the route function

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. What is ORM? which ORM tool, have you used?
  • Ans. 

    ORM stands for Object-Relational Mapping, a programming technique for converting data between incompatible type systems in object-oriented programming languages.

    • ORM is used to map objects from an application to tables in a relational database.

    • It simplifies data manipulation by allowing developers to work with objects instead of SQL queries.

    • Popular ORM tools include Hibernate for Java, Entity Framework for .NET, and Seq

  • Answered by AI
  • Q2. Write ORM code for select item from table?
  • Ans. 

    Use ORM code to select item from a table in database.

    • Use ORM query methods like find(), findOne(), or where() to select items from a table.

    • Specify the table name and any conditions for the selection.

    • Example: User.find({ where: { id: 1 } }) will select a user with id 1 from the User table.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just conduct the interviews
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Project related question , Interface , Abstraction
Round 2 - Technical 

(1 Question)

  • Q1. Scenario based question
Round 3 - HR 

(1 Question)

  • Q1. Salary Discussioon
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Mostly js questions, not so many of angular or react.
  • Q2. Like fizbuzz or things like that.

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't apply here, the culture here is horrible.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. Basic html css questions
Round 2 - Aptitude Test 

Logical reasoning, quantitative analysis and computer test

Round 3 - Technical 

(1 Question)

  • Q1. Basic html, css, javascript questions
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Sliding Window find the subarray with sum equal to k
  • Ans. 

    Using sliding window technique to find subarray with sum equal to k.

    • Initialize two pointers at the start of the array.

    • Move the right pointer to expand the window until the sum is greater than or equal to k.

    • Move the left pointer to shrink the window if the sum exceeds k.

    • Repeat until the end of the array is reached.

    • Example: Input array [1, 4, 20, 3, 10, 5], k=33. Output: [20, 3, 10].

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about your experience.
  • Ans. 

    I have 5 years of experience in developing web applications using Angular.

    • Developed responsive web applications using Angular framework

    • Implemented RESTful APIs to fetch and update data

    • Worked on optimizing performance and improving user experience

    • Collaborated with UI/UX designers to create visually appealing interfaces

  • Answered by AI
  • Q2. What is directive
  • Ans. 

    A directive in Angular is a class with a @Directive decorator that allows you to attach behavior to elements in the DOM.

    • Directives are used to manipulate the DOM, add behavior to elements, and create reusable components.

    • There are three types of directives in Angular: Component, Structural, and Attribute directives.

    • Examples of directives include ngIf, ngFor, and ngStyle.

  • Answered by AI
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. How to insert multiple values in one go
  • Ans. 

    Use the INSERT INTO statement with multiple value sets separated by commas

    • Use the INSERT INTO statement followed by the table name

    • List the column names in parentheses after the table name

    • Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas

    • Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)

  • Answered by AI
  • Q2. Update query using joins
  • Ans. 

    Update query using joins in SQL

    • Use UPDATE statement with JOIN clause to update data in multiple tables

    • Specify the tables to be updated and joined using ON clause

    • Set the columns to be updated in SET clause

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Basic Questions

Skills evaluated in this interview

Capgemini Interview FAQs

How many rounds are there in Capgemini ODI Developer interview?
Capgemini interview process usually has 1 rounds. The most common rounds in the Capgemini interview process are Technical.
How to prepare for Capgemini ODI Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Capgemini. The most common topics and skills that interviewers at Capgemini expect are PLSQL, Oracle SQL, Unix, Oracle and UNIX.
What are the top questions asked in Capgemini ODI Developer interview?

Some of the top questions asked at the Capgemini ODI Developer interview -

  1. What is Slowly changing dimension. And How many types of SCD's we ha...read more
  2. Tell me about Check Knowledge Mod...read more
  3. Types of Knowledge Modu...read more

Tell us how to improve this page.

Capgemini ODI Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Capgemini ODI Developer Salary
based on 10 salaries
₹4.7 L/yr - ₹12 L/yr
At par with the average ODI Developer Salary in India
View more details

Capgemini ODI Developer Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

3.0

Salary

4.0

Job security

4.0

Company culture

3.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Consultant
55.1k salaries
unlock blur

₹5.2 L/yr - ₹17 L/yr

Associate Consultant
50.8k salaries
unlock blur

₹3 L/yr - ₹11.8 L/yr

Senior Consultant
46.1k salaries
unlock blur

₹7.4 L/yr - ₹24.3 L/yr

Senior Analyst
20.8k salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Senior Software Engineer
20.1k salaries
unlock blur

₹3.5 L/yr - ₹12.4 L/yr

Explore more salaries
Compare Capgemini with

Wipro

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.8
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview