Premium Employer

i

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

Infosys Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 36.3k Reviews

Filter interviews by

Infosys Informatica Developer Interview Questions and Answers

Updated 24 Jul 2024

3 interviews found

Sort by: Popular
Interview experience
5
 Excellent
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (4 Questions)

  • Q1. Data warehouse concept
  • Q2. Linux commands like sed ,grep,find
  • Q3. Diff between char and varchar
  • Q4. How to connect the session using unix

Skills evaluated in this interview

Informatica Developer Interview Questions

user image Anonymous

posted on 31 Oct 2023

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Recruitment Consulltant and was interviewed before Oct 2022.

2 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (4 Questions)

  • Q1. Introduction and overview about the tool
  • Q2. Project discussion
  • Q3. High level scenario based queries
  • Q4. Deep into scenarios

Interview Preparation Tips

Interview preparation tips for other job seekers - Two technical rounds will be there one is normal base technical level like what is what the exact scenario and 2nd one is deep discussion a bout project and scenario based queries.

Informatica Developer Interview Questions

user image Anonymous

posted on 28 May 2022

I applied via Shine

3 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Coding Test Round

Super

3

Aptitude Test Round

Super

Interview Preparation Tips

Interview preparation tips for other job seekers - Good job for work at home in laptop

Informatica Developer Jobs at Infosys

View all

Interview questions from similar companies

Informatica Developer Interview Questions

Capgemini user image Jayashree Shinde

posted on 6 Aug 2024

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

I applied via Naukri.com and was interviewed in Jul 2024.

1 Interview Round

1

Technical Round (5 Questions)

  • Q1. Analytical functions difference
  • Q2. Which transformation uses in scd2?
  • 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?
  • Q5. Incremental load

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. Diff between powercenter and IICS
  • Q2. Types of caches
Interview experience
3
 Average
Difficulty level
 Moderate
Duration
 4-6 weeks
Result
 -

I applied via Referral and was interviewed in Dec 2023.

4 Interview Rounds

1

Assessment Round (1 Question)

  • Q1. Questions related to informatica powercenter basic to mid level
2

Technical Round (5 Questions)

  • Q1. Self intro as usual
  • Q2. What are active and passive transformations?
  • Q3. Some basic questions on transformations like Expression, Update, Router, filter, SQ,lookup etc
  • Q4. What are different types of lookup caches
  • Q5. Difference between filter and router.
3

Technical Round (3 Questions)

  • Q1. Some basic to medium level questions on transformations
  • Q2. Some real time scenario questions
  • Q3. Direct and indirect file loading
4

HR Round (2 Questions)

  • Q1. Asked for Mumbai location
  • Q2. 5 days Client office

Interview Preparation Tips

Interview preparation tips for other job seekers - Though it went well till HR round, they have dropped my profile saying that they need mumbai Resident people for this role.
Even though I agreed for relocation as well. They rejected me after all 4 freaking rounds.

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Mar 2024.

1 Interview Round

1

Technical Round (2 Questions)

  • Q1. What are cubes and OLAP cubes
  • Q2. What is ETL pipeline?

Skills evaluated in this interview

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

I applied via Indeed and was interviewed before Oct 2022.

3 Interview Rounds

1

Resume Shortlist Round

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
2

Technical Round (4 Questions)

  • Q1. Sql/ data warehousing/ scenario based questions
  • Q2. Explain Daily work in detail
  • Q3. Google-informatica scenario based questions
  • Q4. Sql- 2nd highest or 3rd highest salary
3

HR Round (1 Question)

  • Q1. Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Just focus on basic and take time to explain your daily work.

Skills evaluated in this interview

I was interviewed in Mar 2022.

1 Interview Round

1

Technical Round (2 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Datawarehouse concept , difference between database and dataware house
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed before Mar 2022.

2 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
2

Technical Round (2 Questions)

  • Q1. Difference between iics and power centre
  • Q2. What is secure agent

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well and login before 5 mins ,it’s a 30 mins interview

Skills evaluated in this interview

Infosys Interview FAQs

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

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

  1. How to connect the session using u...read more
  2. Diff between char and varc...read more
  3. Introduction and overview about the t...read more

Tell us how to improve this page.

People are getting interviews through

based on 2 Infosys interviews
Job Portal
50%
50% candidates got the interview through other sources.
Moderate Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Join Infosys Creating the next opportunity for people, businesses & communities
Infosys Informatica Developer Salary
based on 168 salaries
₹3 L/yr - ₹10.1 L/yr
17% less than the average Informatica Developer Salary in India
View more details

Infosys Informatica Developer Reviews and Ratings

based on 7 reviews

4.1/5

Rating in categories

3.6

Skill development

3.9

Work-Life balance

2.6

Salary & Benefits

4.2

Job Security

4.4

Company culture

2.1

Promotions/Appraisal

3.6

Work Satisfaction

Explore 7 Reviews and Ratings
Informatica Developer

Bangalore / Bengaluru

3-8 Yrs

Not Disclosed

Explore more jobs
Technology Analyst
57.4k salaries
unlock blur

₹3 L/yr - ₹11 L/yr

Senior Systems Engineer
49.9k salaries
unlock blur

₹2.5 L/yr - ₹8 L/yr

System Engineer
32.8k salaries
unlock blur

₹2 L/yr - ₹5 L/yr

Technical Lead
31.4k salaries
unlock blur

₹5.3 L/yr - ₹19.5 L/yr

Senior Associate Consultant
27.3k salaries
unlock blur

₹6.2 L/yr - ₹18 L/yr

Explore more salaries
Compare Infosys with

TCS

3.7
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Accenture

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview