Add office photos
i
Capgemini
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini Informatica Developer Interview Questions and Answers
Capgemini Informatica Developer Interview Experiences
7 interviews found
Jayashree Shinde
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(5 Questions)
- Q1. Analytical functions difference
- Ans.
Analytical functions are used to perform calculations across a set of rows related to the current row.
Analytical functions operate on a group of rows and return a single result for each row
They can be used to calculate running totals, moving averages, rank, percentiles, etc.
Examples include ROW_NUMBER(), RANK(), SUM() OVER(), AVG() OVER()
- Q2. Which transformation uses in scd2?
- Ans.
The Slowly Changing Dimension Type 2 (SCD2) transformation is used for handling historical data changes in a data warehouse.
SCD2 transformation is used to track historical changes in dimension tables.
It maintains multiple versions of a record by adding new rows with updated information and end-dating the previous record.
Commonly used in scenarios where historical data needs to be preserved and queried.
Example: When a c...
- Q3. Unix basic, how to find particular file in directory?
- Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join?
- Ans.
To find the count of different types of joins between two tables A and B.
Left join: Includes all records from table A and matching records from table B.
Right join: Includes all records from table B and matching records from table A.
Inner join: Includes only the matching records from both tables.
Full outer join: Includes all records when there is a match in either table A or table B.
- Q5. Incremental load
Skills evaluated in this interview
Pooja Kalijavedu
Selected
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Questions related to transformation s
- Q2. Questions of unix
(2 Questions)
- Q1. Adavanced topic of informatica
- Q2. SQL queries questions
Anonymous
I applied via Job Portal and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Icai process related questions
- Q2. Past experience based questions
Interview Preparation Tips
What people are saying about Capgemini
Srotoswini Chanda
I applied via Recruitment Consulltant and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Scd2 mapping design
- Q2. Previous project experience
(1 Question)
- Q1. Salary negotiations
Capgemini interview questions for designations
Prachi Yawalkar
Selected
(1 Question)
- Q1. Share About Your Past experiences?
- Ans. Have a good answer ready for this question , it helps a lot to channelize your interview.
Buruju purushothamreddy
I applied via Company Website
(1 Question)
- Q1. About my self and About informatica
About sql
(4 Questions)
- Q1. What are your salary expectations?
- Q2. What are your strengths and weaknesses?
- Q3. Where do you see yourself in 5 years?
- Q4. Why are you looking for a change?
Interview Preparation Tips
I was interviewed in Mar 2021.
Interview Questionnaire
3 Questions
- Q1. Scd type 1 implement
- Q2. Informatica performance tuning
- Q3. Top 3 sql query
Interview Preparation Tips
Interview questions from similar companies
HARSHA v
(2 Questions)
- Q1. Diff between powercenter and IICS
- Ans.
PowerCenter is an on-premise data integration tool, while IICS is a cloud-based integration platform.
PowerCenter is on-premise, IICS is cloud-based
PowerCenter is a traditional ETL tool, IICS is a modern integration platform
PowerCenter requires infrastructure setup, IICS is managed by Informatica
PowerCenter is more suitable for large enterprises with on-premise data, IICS is better for cloud-based integrations
- Q2. Types of caches
- Ans.
Types of caches include memory cache, disk cache, and browser cache.
Memory cache stores data in memory for quick access.
Disk cache stores data on the hard drive for faster retrieval.
Browser cache stores web page elements to reduce loading times.
Other types include CPU cache, page cache, and object cache.
Skills evaluated in this interview
Uday Y
(4 Questions)
- Q1. Data warehouse concept
- Q2. Linux commands like sed ,grep,find
- Q3. Diff between char and varchar
- Ans.
Char is fixed length string data type, while varchar is variable length string data type.
Char stores fixed length strings, while varchar stores variable length strings.
Char pads with spaces to reach fixed length, while varchar does not pad.
Char is faster for fixed length data, while varchar is more flexible for variable length data.
- Q4. How to connect the session using unix
- Ans.
To connect a session using Unix, you can use the pmcmd command with appropriate arguments.
Use the pmcmd command followed by the connect option to connect to the Informatica session.
Provide the necessary connection details such as domain, repository, username, and password.
You can also specify the session name and folder path if needed.
Example: pmcmd connect -sv MyInformaticaServer -d MyDomain -u MyUsername -p MyPasswor
Skills evaluated in this interview
I applied via Referral and was interviewed in Dec 2023. There were 4 interview rounds.
(1 Question)
- Q1. Questions related to informatica powercenter basic to mid level
(5 Questions)
- Q1. Self intro as usual
- Q2. What are active and passive transformations?
- Ans.
Active transformations change the number of rows that pass through them, while passive transformations do not change the number of rows.
Active transformations can filter, update, or modify the number of rows in a data stream (e.g. Filter, Router, Update Strategy).
Passive transformations do not change the number of rows in a data stream, they only allow data to pass through unchanged (e.g. Expression, Lookup, Sequence G
- Q3. Some basic questions on transformations like Expression, Update, Router, filter, SQ,lookup etc
- Q4. What are different types of lookup caches
- Ans.
Different types of lookup caches include persistent cache, dynamic cache, and shared cache.
Persistent cache stores lookup data in a flat file or database table for reuse across sessions.
Dynamic cache dynamically loads lookup data into memory as needed during a session.
Shared cache allows multiple sessions to share the same cache for improved performance.
- Q5. Difference between filter and router.
- Ans.
Filter is used to pass or reject data based on conditions, while router is used to route data to different targets based on conditions.
Filter is used to include or exclude data based on specified conditions.
Router is used to direct data to different targets based on specified conditions.
Filter is typically used to remove unwanted data, while router is used to split data flow.
Example: Using filter to exclude records wit...
(3 Questions)
- Q1. Some basic to medium level questions on transformations
- Q2. Some real time scenario questions
- Q3. Direct and indirect file loading
(2 Questions)
- Q1. Asked for Mumbai location
- Q2. 5 days Client office
Interview Preparation Tips
Even though I agreed for relocation as well. They rejected me after all 4 freaking rounds.
Skills evaluated in this interview
Capgemini Interview FAQs
Tell us how to improve this page.
Capgemini Interviews By Designations
- Capgemini Analyst Interview Questions
- Capgemini Consultant Interview Questions
- Capgemini Software Engineer Interview Questions
- Capgemini Senior Consultant Interview Questions
- Capgemini Associate Consultant Interview Questions
- Capgemini Senior Analyst Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Informatica ETL Developer Interview Questions
- Oracle Database Administrator Interview Questions
- Informatica Administrator Interview Questions
- ETL Developer Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Information Technology Support Engineer Interview Questions
- Show more
Capgemini Informatica Developer Interview Process
based on 5 interviews in last 1 year
1 Interview rounds
- One-on-one Round
People are getting interviews through
Informatica Developer Interview Questions from Similar Companies
Fast track your campus placements
Capgemini Informatica Developer Reviews and Ratings
based on 10 reviews
Rating in categories
|
Consultant
55.2k
salaries
|  ₹5.2 L/yr - ₹18 L/yr |
|
Associate Consultant
52k
salaries
| ₹2.9 L/yr - ₹11.6 L/yr |
|
Senior Consultant
45.9k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
|
Senior Analyst
20.6k
salaries
| ₹2 L/yr - ₹9 L/yr |
|
Senior Software Engineer
19.9k
salaries
| ₹3.5 L/yr - ₹12.5 L/yr |
Wipro
Accenture
Cognizant
TCS
Calculate your in-hand salary
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Informatica Developer Interview Questions
