Upload Button Icon Add office photos
Engaged Employer

i

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

Cognizant 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

Cognizant Informatica Developer Interview Questions and Answers

Updated 27 Sep 2022

Cognizant Informatica Developer Interview Experiences

3 interviews found

I appeared for an interview in Mar 2022.

Round 1 - Technical 

(2 Questions)

  • Q1. All they asked about data warehouse concept
  • Q2. Difference between database and dataware house
  • Ans. 

    Database is a collection of related data while data warehouse is a large collection of data used for business analysis.

    • Database is used for transactional processing while data warehouse is used for analytical processing.

    • Database is designed for day-to-day operations while data warehouse is designed for decision-making purposes.

    • Database is usually smaller in size while data warehouse is much larger in size.

    • Database is n...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Datawarehouse concept , difference between database and dataware house

I applied via Naukri.com and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions about the skillset

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong with the basics. Questions may vary depending upon the interviewer.

Informatica Developer Interview Questions Asked at Other Companies

asked in BNP Paribas
Q1. if we dont specify anything in group by aggregator what will happ ... read more
asked in Cognizant
Q2. 1. What is factless fact. 2. Star schema vs snowflake schema. And ... read more
asked in BNP Paribas
Q3. what kind of transformation is update strategy? explain
asked in Wipro
Q4. What is the difference between iics and power center
asked in Capgemini
Q5. Given 2 table A and B. Find count of left join, right join, inner ... read more

I appeared for an interview in Jan 2021.

Interview Questionnaire 

1 Question

  • Q1. 1. What is factless fact. 2. Star schema vs snowflake schema. And which is normalized. 3. About oracle joins.
  • Ans. 

    Answers to questions related to Informatica Developer role.

    • Factless fact is a fact table that does not have any measures.

    • Star schema has a single fact table and multiple dimension tables, while snowflake schema has multiple dimension tables that are further normalized.

    • Oracle joins include inner join, left join, right join, and full outer join.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - They will focus on theory instead of knowledge. So read concepts clearly.

Interview questions from similar companies

I applied via Company Website and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Self introduction

Interview Preparation Tips

Interview preparation tips for other job seekers - say individual ideas,plans, story's.say different opinions,speek confidentially, correctly answer Yes or no questions, correctly say interested and confidential job,

I appeared for an interview before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 45 minutes
Round difficulty - Hard

All mcqs should answer with in time limit should have a lot of practice to solve in exam

  • Q1. 

    Water Jug Problem Statement

    You have two water jugs with capacities X and Y liters respectively, both initially empty. You also have an infinite water supply. The goal is to determine if it is possible to...

  • Ans. 

    The Water Jug Problem involves determining if a specific amount of water can be measured using two jugs of different capacities.

    • Start by considering the constraints and limitations of the problem.

    • Think about how the operations allowed can be used to reach the target measurement.

    • Consider different scenarios and test cases to come up with a solution.

    • Implement a function that takes the capacities of the jugs and the targe...

  • Answered by AI
Round 2 - Coding Test 

(1 Question)

Round duration - 60 minutes
Round difficulty - Easy

Easy and just basic questions very easy round

  • Q1. 

    Matrix Multiplication Task

    Given two sparse matrices MAT1 and MAT2 of integers with dimensions 'N' x 'M' and 'M' x 'P' respectively, the goal is to determine the resulting matrix produced by their multipl...

  • Ans. 

    Implement a function to multiply two sparse matrices and return the resulting matrix.

    • Create a function that takes two sparse matrices as input and returns the resulting matrix after multiplication.

    • Iterate through the non-zero elements of the matrices to perform the multiplication efficiently.

    • Ensure to handle the sparse nature of the matrices to optimize the multiplication process.

    • Consider the constraints provided to en...

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 6 cgpaTata Consultancy Services (TCS) interview preparation:Topics to prepare for the interview - Dql, Data structures, Java, Operating system, Data scienceTime required to prepare for the interview - 1 monthInterview preparation tips for other job seekers

Tip 1 : preapre core subjects 
Tip 2 : be confident and answer clearly
Tip 3 : be strong with projects

Application resume tips for other job seekers

Tip 1 : good projects in ml and ai
Tip 2 : practical experience

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. What is flexbox
  • Ans. 

    Flexbox is a CSS layout module that allows for flexible and responsive web design.

    • Flexbox allows for easy alignment and positioning of elements within a container.

    • It uses a set of properties to define the layout, such as display: flex and flex-direction.

    • Flexbox is particularly useful for creating responsive designs that adapt to different screen sizes.

    • It can also be used in combination with other CSS layout modules, su...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Flexbox is a layout model that allows elements to align and distribute space within a container. Using flexible widths and heights, elements can be aligned to fill a space or distribute space between elements, which makes it a great tool to use for responsive design systems.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. It was for automotive domain. Mainly the questions were on automotive concept like CAN, UDS protocols, and tools of Vector company. Embedded c knowledge is must
  • Q2. Embedded c knowledge is must
  • Q3. Debugging skills are add on

Interview Preparation Tips

Interview preparation tips for other job seekers - Python or any script language for automotion will be plus point

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

Interview Questionnaire 

3 Questions

  • Q1. What is a bit
  • Q2. What us the size of a bit
  • Ans. 

    A bit is the smallest unit of digital information. It can have a value of either 0 or 1.

    • A bit is a binary digit, represented as either 0 or 1.

    • It is the basic unit of information used in computing and digital communications.

    • A group of 8 bits is called a byte.

    • The size of a bit is dependent on the architecture of the computer system.

  • Answered by AI
  • Q3. How many bits are there in C
  • Ans. 

    C is a programming language and does not have a fixed number of bits.

    • C is a high-level programming language that can be compiled to run on different architectures with varying bit sizes.

    • The number of bits in C depends on the hardware architecture it is compiled for.

    • For example, C code compiled for a 32-bit architecture will have 32-bit integers, while code compiled for a 64-bit architecture will have 64-bit integers.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm and patient. Dont hesitate to give answers.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Basic question on testing, selenium, java, sql, agile, topics from resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with whatever written in resume

I applied via Campus Placement and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All technical discussion not much deeper but basic questions of graduation were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and don't hesitate 🙂

Cognizant Interview FAQs

How many rounds are there in Cognizant Informatica Developer interview?
Cognizant interview process usually has 2 rounds. The most common rounds in the Cognizant interview process are Resume Shortlist and Technical.
How to prepare for Cognizant Informatica 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 Cognizant. The most common topics and skills that interviewers at Cognizant expect are Informatica, Informatica Powercenter, Web Development, Development and ETL.
What are the top questions asked in Cognizant Informatica Developer interview?

Some of the top questions asked at the Cognizant Informatica Developer interview -

  1. 1. What is factless fact. 2. Star schema vs snowflake schema. And which is norm...read more
  2. Difference between database and dataware ho...read more
  3. All they asked about data warehouse conc...read more

Tell us how to improve this page.

Cognizant Informatica Developer Salary
based on 460 salaries
₹4 L/yr - ₹15.1 L/yr
33% more than the average Informatica Developer Salary in India
View more details

Cognizant Informatica Developer Reviews and Ratings

based on 23 reviews

4.1/5

Rating in categories

4.2

Skill development

4.0

Work-life balance

3.8

Salary

4.1

Job security

4.1

Company culture

3.8

Promotions

3.9

Work satisfaction

Explore 23 Reviews and Ratings
Associate
72.4k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

Programmer Analyst
55.6k salaries
unlock blur

₹2.4 L/yr - ₹9.3 L/yr

Senior Associate
50.2k salaries
unlock blur

₹9 L/yr - ₹28.6 L/yr

Senior Processing Executive
29.1k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Technical Lead
17.7k salaries
unlock blur

₹6 L/yr - ₹25 L/yr

Explore more salaries
Compare Cognizant with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Accenture

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