Add office photos
Engaged Employer
i
This company page is being actively managed by
TCS Team. If you also belong to the team, you
can get access from
here
TCS
Compare
Filter interviews by
TCS Informatica Developer Interview Questions, Process, and Tips
Updated
7 Dec 2024
Top TCS Informatica Developer Interview Questions and Answers
- Q1. What transformations did use in Informtica
- Q2. Unix shell script for sending mail
- Q3. Diff between powercenter and IICS
5 TCS Informatica Developer Interview Experiences
16 questions found
Sort by:
Popular
HARSHA v
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (2 Questions)
- Q1. Diff between powercenter and IICS View Answers (1)
- Q2. Types of caches View Answers (1)
Anonymous
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. SQL joins right left inner View Answers (1)
- Q2. Informatica scenario questions Add Answer
2
HR Round (2 Questions)
- Q1. Salary expectation Add Answer
- Q2. Location preference Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare SQL well
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Unix shell script for sending mail View Answers (1)
- Q2. Performance tuning Add Answer
2
HR Round (2 Questions)
- Q1. About project and CTC Add Answer
- Q2. Notice period and how soon can join Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Na
Skills evaluated in this interview
What people are saying about TCS
View All
abruptturkey
works at
TCS
Nokia - CTC
Hi friends,
i am a SDET with 2Y6M experience in TCS.
My CCTC is 8.36.
I have cleared L1 & L2 rounds with Nokia for R&D Test Engineer, Bengaluru . I need your guidance on
1. What CTC shall i ask?
2. How is life for an Automation tester in Nokia.
Please give valuable guidance / Suggestions.
Thanks.
Got a question about TCS?
Ask anonymously on communities.
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Campus Placement and was interviewed before Dec 2023.
3 Interview Rounds
1
Aptitude Test Round
Prepare all types of Aptitude questions.
2
Coding Test Round
2 coding questions will be there.
3
Technical Round (4 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Why are you joining IT sector Add Answer
- Q3. Which technical skills you have Add Answer
- Q4. Do you know SQL Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare atleast 1 technical skills properly and introduce yourself in a brief.
TCS interview questions for designations
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
-
I applied via Approached by Company and was interviewed before May 2023.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. What transformations did use in Informtica View Answers (1)
- Q2. I just told what I have used and the seniro in which I have used Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Easy if you have worked in Informatica in past
Skills evaluated in this interview
Interview questions from similar companies
Jayashree Shinde
Interview experience
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 View Answers (1)
- Q2. Which transformation uses in scd2? View Answers (1)
- Q3. Unix basic, how to find particular file in directory? Add Answer
- Q4. Given 2 table A and B. Find count of left join, right join, inner join, full outer join? View Answers (1)
- Q5. Incremental load Add Answer
Skills evaluated in this interview
Uday Y
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Data warehouse concept Add Answer
- Q2. Linux commands like sed ,grep,find Add Answer
- Q3. Diff between char and varchar View Answers (1)
- Q4. How to connect the session using unix View Answers (1)
Skills evaluated in this interview
Interview experience
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 Add Answer
2
Technical Round (5 Questions)
- Q1. Self intro as usual Add Answer
- Q2. What are active and passive transformations? View Answers (1)
- Q3. Some basic questions on transformations like Expression, Update, Router, filter, SQ,lookup etc Add Answer
- Q4. What are different types of lookup caches View Answers (1)
- Q5. Difference between filter and router. View Answers (1)
3
Technical Round (3 Questions)
- Q1. Some basic to medium level questions on transformations Add Answer
- Q2. Some real time scenario questions Add Answer
- Q3. Direct and indirect file loading Add Answer
4
HR Round (2 Questions)
- Q1. Asked for Mumbai location Add Answer
- Q2. 5 days Client office Add Answer
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.
Even though I agreed for relocation as well. They rejected me after all 4 freaking rounds.
Skills evaluated in this interview
Interview experience
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 View Answers (1)
- Q2. What is ETL pipeline? View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
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 Add Answer
- Q2. Explain Daily work in detail Add Answer
- Q3. Google-informatica scenario based questions Add Answer
- Q4. Sql- 2nd highest or 3rd highest salary View Answers (1)
3
HR Round (1 Question)
- Q1. Salary negotiation Add Answer
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
TCS Interview FAQs
How many rounds are there in TCS Informatica Developer interview?
TCS interview process usually has 1-2 rounds. The most common rounds in the TCS interview process are Technical, HR and Aptitude Test.
How to prepare for TCS 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 TCS. The most common topics and skills that interviewers at TCS expect are Informatica, ETL, Data Warehousing, PLSQL and SQL.
Tell us how to improve this page.
TCS Interviews By Designations
- TCS System Engineer Interview Questions
- TCS Software Developer Interview Questions
- TCS Software Engineer Interview Questions
- TCS Assistant System Engineer Interview Questions
- TCS Assistant System Engineer Trainee Interview Questions
- TCS IT Analyst Interview Questions
- TCS Java Developer Interview Questions
- TCS Ninja 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 Recruiter Interview Questions
- Show more
Interview Process at TCS Informatica Developer
based on 5 interviews in last 1 year
1 Interview rounds
- Technical Round
View more
People are getting interviews through
based on 2 TCS interviews
Campus Placement
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
Informatica Developer Interview Questions from Similar Companies
Fast track your campus placements
8%
less
than the average Informatica Developer Salary in India
View more details
TCS Informatica Developer Reviews and Ratings
based on 28 reviews
Rating in categories
|
System Engineer
1.1L
salaries
|  ₹1 L/yr - ₹9 L/yr |
|
IT Analyst
71.2k
salaries
| ₹5.1 L/yr - ₹16 L/yr |
|
AST Consultant
52.2k
salaries
| ₹8 L/yr - ₹25 L/yr |
|
Assistant System Engineer
31k
salaries
| ₹2.1 L/yr - ₹5.6 L/yr |
|
Associate Consultant
30k
salaries
| ₹8.9 L/yr - ₹37 L/yr |
Explore more salaries
Compare TCS with
Amazon
Compare
Wipro
Compare
Infosys
Compare
Accenture
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
- Home >
- Interviews >
- TCS Interview Questions >
- TCS Informatica Developer Interview Questions
Share an Interview