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 Questionnaire 

1 Question

  • Q1. Time management

I applied via Naukri.com and was interviewed before May 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Explain me about yourself
  • Q2. Just be brief don't bore them

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident.

I applied via Campus Placement and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Waterfall model, Software development life cycle
  • Q2. How do you arrive at factorial without recursive function
  • Ans. 

    Factorial can be calculated using a loop by multiplying numbers from 1 to n.

    • Initialize a variable to 1

    • Use a loop to multiply the variable with numbers from 1 to n

    • Return the variable

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up your fundamental skills

Interview Questionnaire 

3 Questions

  • Q1. Process builder. 2.types of relationships. 3.difference in user ,profile and role. 4.workflow. 5.Admin questions
  • Ans. 

    Answering questions related to software development and Salesforce administration.

    • Process Builder is a visual tool in Salesforce used to automate business processes.

    • Types of relationships in Salesforce include lookup, master-detail, and many-to-many relationships.

    • User represents an individual who can log in and access Salesforce, Profile defines the permissions and settings for a user, and Role determines the hierarchy...

  • Answered by AI
  • Q2. What configuration i have done.
  • Ans. 

    I have configured various software systems and tools for development purposes.

    • Configured IDEs such as Eclipse and Visual Studio for development

    • Set up version control systems like Git and SVN

    • Installed and configured build tools like Maven and Gradle

    • Configured application servers like Tomcat and JBoss

    • Set up databases like MySQL and Oracle for development and testing

  • Answered by AI
  • Q3. Salary negotiations

Interview Preparation Tips

Round: Manager round
Experience: Configuration and what work ee have done in your previous company.

Skills evaluated in this interview

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

Associate Interview Questions & Answers

TCS user image Anonymous

posted on 10 Aug 2021

I applied via Campus Placement and was interviewed before Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. What is your project?
  • Q2. What is the Latest embedded systems?
  • Ans. 

    The latest embedded systems are focused on IoT, AI, and machine learning.

    • Embedded systems are becoming more connected to the internet of things (IoT)

    • AI and machine learning are being integrated into embedded systems for improved performance

    • Low-power consumption and high-performance processors are being developed for embedded systems

    • Examples include Amazon Echo, Nest Thermostat, and Fitbit

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and review your full resume.. All the questions were asked in your resume only..

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Introduction, questions based on project and JD

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with JB and also on point questions.

I applied via Company Website and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. I were asked to print the number of pairs in an array whose sum is equal to given number k
  • Ans. 

    Count the number of pairs in an array whose sum is equal to a given number k.

    • Iterate through the array and for each element, check if k minus the element exists in the array.

    • Use a hash table to store the frequency of each element in the array.

    • If the array contains duplicates, handle them separately to avoid overcounting.

    • Time complexity can be improved to O(n) using a two-pointer approach.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It was nice

I applied via Recruitment Consultant and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. What is Abstraction
  • Ans. 

    Abstraction is the process of hiding complex implementation details and exposing only the necessary information.

    • Abstraction helps in reducing complexity and increasing efficiency.

    • It allows us to focus on the essential features of an object or system.

    • Abstraction can be achieved through abstract classes, interfaces, and encapsulation.

    • For example, a car can be abstracted as a vehicle with certain properties and methods.

    • Ab...

  • Answered by AI
  • Q2. Concept of hiding implementation
  • Ans. 

    Hiding implementation means keeping the internal details of a class or function hidden from the outside world.

    • It is a fundamental principle of object-oriented programming.

    • It helps in achieving encapsulation and abstraction.

    • It prevents the user from accessing the internal workings of a class or function.

    • Examples include private variables and methods in a class.

    • It allows for easier maintenance and modification of code.

    • It...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Not bad, good atmosphere, positive response from staff

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.6k Interviews
Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
DXC Technology Interview Questions
3.7
 • 802 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.6k salaries
unlock blur

₹5.2 L/yr - ₹18 L/yr

Associate Consultant
50.7k salaries
unlock blur

₹3 L/yr - ₹11.9 L/yr

Senior Consultant
46.8k salaries
unlock blur

₹7.5 L/yr - ₹25 L/yr

Senior Analyst
20.9k salaries
unlock blur

₹2.2 L/yr - ₹9 L/yr

Senior Software Engineer
20.5k salaries
unlock blur

₹3.5 L/yr - ₹12.9 L/yr

Explore more salaries
Compare Capgemini with

Wipro

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare

TCS

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