Upload Button Icon 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 Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

TCS Informatica Developer Interview Questions, Process, and Tips

Updated 7 Dec 2024

Top TCS Informatica Developer Interview Questions and Answers

TCS Informatica Developer Interview Experiences

5 interviews found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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

  • Answered by AI
  • 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.

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL joins right left inner
  • Ans. 

    SQL joins are used to combine rows from two or more tables based on a related column between them.

    • Types of SQL joins include: INNER JOIN, LEFT JOIN (or LEFT OUTER JOIN), RIGHT JOIN (or RIGHT OUTER JOIN)

    • INNER JOIN returns rows when there is at least one match in both tables

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table

    • RIGHT JOIN returns all rows from the right table and the matc

  • Answered by AI
  • Q2. Informatica scenario questions
Round 2 - HR 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Location preference

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL well

Skills evaluated in this interview

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
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Unix shell script for sending mail
  • Ans. 

    Use 'mail' command in Unix shell script to send emails.

    • Use 'mail' command followed by recipient email address

    • Include subject with -s flag and message body with -m flag

    • Example: mail -s 'Subject' recipient@example.com -m 'Message body'

  • Answered by AI
  • Q2. Performance tuning
Round 2 - HR 

(2 Questions)

  • Q1. About project and CTC
  • Q2. Notice period and how soon can join

Interview Preparation Tips

Interview preparation tips for other job seekers - Na

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Prepare all types of Aptitude questions.

Round 2 - Coding Test 

2 coding questions will be there.

Round 3 - Technical 

(4 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a skilled Informatica Developer with 5 years of experience in data integration and ETL processes.

    • Experienced in designing and implementing ETL mappings using Informatica PowerCenter

    • Proficient in SQL for data querying and manipulation

    • Strong understanding of data warehousing concepts and best practices

    • Collaborated with business stakeholders to gather requirements and deliver solutions

    • Certified in Informatica PowerCe

  • Answered by AI
  • Q2. Why are you joining IT sector
  • Q3. Which technical skills you have
  • Q4. Do you know SQL

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

 Informatica ETL Developer

 (1)

 Informatica Administrator

 (1)

 Developer

 (46)

 Software Developer

 (501)

 Java Developer

 (184)

 Salesforce Developer

 (35)

 Web Developer

 (33)

 Python Developer

 (28)

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Approached by Company and was interviewed before May 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What transformations did use in Informtica
  • Ans. 

    I have used various transformations in Informatica such as Filter, Router, Expression, Aggregator, Joiner, Lookup, and Sorter.

    • Filter transformation is used to filter rows based on a condition.

    • Router transformation is used to route data to different targets based on conditions.

    • Expression transformation is used to perform calculations or manipulate data.

    • Aggregator transformation is used to perform aggregate calculations ...

  • Answered by AI
  • Q2. I just told what I have used and the seniro in which I have used

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

I appeared for an interview in Apr 2017.

Interview Questionnaire 

2 Questions

  • Q1. Java questions...
  • Q2. Tell me about urself and about us family and all
  • Ans. 

    I am a software developer with a passion for coding and problem-solving. My family is supportive and has always encouraged my career in tech.

    • Experienced software developer

    • Passionate about coding and problem-solving

    • Supportive family that encourages my career in tech

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Easy questions are there
Duration: 1 hour
Total Questions: 90

Round: Group Discussion
Experience: 12 members are there only 9 got selected
Tips: Be confident in urself and specially work in Communication skills
Duration: 15 minutes

Round: Technical Interview
Experience: Asking all the concepts of Java like oops collections threads
Tips: Prepare well on Java

Round: HR Interview
Experience: Everything was Gud but due to my certificate problem I got rejected.. Otherwise everything is good.
Tips: Be confident

College Name: C. V. Raman College of Engineering

Interview Preparation Tips

College Name: Vidyalankar Institute Of Technology

Interview Questionnaire 

11 Questions

  • Q1. Hobbies: Drawing. Asked about drawing and pencil shading. Draw in next 5 mins something great to impress me else rejected
  • Q2. Sketch my face
  • Q3. If you are told to do a job of a peon for the company will you?
  • Q4. Remove all the pcs from the lab and keep in other lab RIGHT NOW?
  • Ans. 

    Yes, I can remove all the pcs from the lab and keep them in another lab right now.

    • Ensure all the necessary equipment and tools are available for the move

    • Coordinate with the lab staff to ensure a smooth transition

    • Label and document each PC for easy identification and setup in the new lab

    • Ensure proper packaging and handling to prevent any damage during the move

  • Answered by AI
  • Q5. Impress me with your talents
  • Q6. If a person asks you on a construction site to pick up bricks will you?
  • Q7. How crazy are you?
  • Q8. Show me how crazy are you in next 5 mins?
  • Q9. Write down Fibonacci series and also explain pseudo code for it?
  • Ans. 

    Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.

    • The first two numbers of the series are always 0 and 1

    • The next number is the sum of the previous two numbers

    • The series goes on infinitely: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, ...

    • Pseudo code: 1. Initialize variables a=0, b=1, c=0 2. Print a and b 3. Repeat steps 4-6 until desired number of terms 4. c=a+b 5. Pr

  • Answered by AI
  • Q10. Write algorithm for matrix multiplication?
  • Ans. 

    Algorithm for matrix multiplication

    • Create a result matrix with dimensions of the two input matrices

    • Iterate through each row and column of the result matrix

    • For each element in the result matrix, multiply corresponding row in first matrix with corresponding column in second matrix

    • Add the products obtained in the previous step to get the final value for the element

  • Answered by AI
  • Q11. Explain your project and which algorithm you used in it. Why that algorithm?
  • Ans. 

    I worked on a project that involved sentiment analysis of customer reviews using Naive Bayes algorithm.

    • The project involved collecting customer reviews from various sources.

    • Preprocessing the data by removing stop words, stemming, and tokenizing.

    • Used Naive Bayes algorithm for sentiment analysis.

    • The algorithm was chosen because of its simplicity and effectiveness in text classification tasks.

    • The accuracy of the model was

  • Answered by AI

Interview Preparation Tips

Round: HR Interview
Experience: Confused

If they say do you have any questions?
NEVER ASK about your performance in that round.

Round: Technical Interview
Experience: Good
Tips: Interview depends on your basic knowledge

Skills: Presence Of Mind, Technical Skills, Analytical Skills
College Name: Vidyalankar Institute Of Technology
Motivation: Got rejected for TCS aptitude.
Funny Moments: Whole HR interview

Skills evaluated in this interview

Interview Questionnaire 

9 Questions

  • Q1. Talk about your BE project?
  • Ans. 

    Developed a web-based project management system for a construction company.

    • Used PHP and MySQL for backend development

    • Implemented user authentication and authorization

    • Designed a responsive UI using Bootstrap

    • Integrated Google Maps API for location tracking

    • Enabled file uploads and downloads for project documents

  • Answered by AI
  • Q2. If you belong to EXTC, then why IT?
  • Ans. 

    EXTC and IT are not mutually exclusive fields. My knowledge in EXTC complements my skills in IT.

    • My knowledge in EXTC gives me a strong foundation in electronics and communication, which are essential in the IT industry.

    • I have also gained programming skills through my coursework and projects in EXTC.

    • IT is a rapidly growing field with a lot of opportunities, and I believe my skills and knowledge make me a strong candidat...

  • Answered by AI
  • Q3. Are you ok with relocation?
  • Ans. 

    Yes, I am open to relocation for the right opportunity.

    • I am willing to relocate for a position that aligns with my career goals

    • I am excited about the prospect of exploring a new city and culture

    • I am flexible and adaptable to new environments

  • Answered by AI
  • Q4. Which languages are you familiar with?
  • Ans. 

    I am familiar with several programming languages.

    • Java

    • Python

    • C++

    • JavaScript

    • SQL

  • Answered by AI
  • Q5. BE project members and your guide
  • Q6. What/s the diffrencebetween leader and a manager
  • Ans. 

    A leader inspires and motivates while a manager plans and organizes.

    • Leaders focus on the big picture while managers focus on details

    • Leaders lead by example while managers delegate tasks

    • Leaders inspire and motivate while managers enforce rules and policies

    • Leaders are visionaries while managers are implementers

    • Examples of leaders: Steve Jobs, Martin Luther King Jr. Examples of managers: Tim Cook, COO of Apple

  • Answered by AI
  • Q7. Are you okay with relocation?
  • Ans. 

    Yes, I am open to relocation for the right opportunity.

    • I am willing to relocate for the right job opportunity

    • I am open to exploring new places and cultures

    • I understand that relocation may come with challenges, but I am prepared to face them

    • I am excited about the prospect of starting fresh in a new location

  • Answered by AI
  • Q8. What's the name of the person who took your technical interview?
  • Ans. 

    I'm sorry, I don't have that information.

    • N/A

  • Answered by AI
  • Q9. How was the TCS aptitude test?
  • Ans. 

    The TCS aptitude test was challenging but fair.

    • The test covered a wide range of topics including math, logic, and English.

    • The questions were designed to test problem-solving skills and critical thinking.

    • Time management was crucial as there were many questions to answer in a limited time.

    • Overall, the test was a good indicator of one's aptitude for software engineering.

  • Answered by AI

Interview Preparation Tips

Round: Technical Interview
Experience: pretty decent and interactive
Tips: be true, be yourself

General Tips: Do not fake a personality, be original. Avoid an answer if you have to, but , in an affirmative way.
Skills: Ability To Justify, Ability To Be Involved In Hands On Work, Ability To Deal Diplomatically, Ability To Convince
College Name: Vidyalankar Institute Of Technology
Funny Moments: The HR interviewer asked me the name of my tech interviewer.

Interview Questionnaire 

7 Questions

  • Q1. Introduce Yourself
  • Ans. 

    I am a software engineer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.

    • 5 years of experience in software development

    • Proficient in Java, Spring Boot, and Angular

    • Strong problem-solving skills

  • Answered by AI
  • Q2. About Your Family
  • Q3. About MindTree
  • Q4. Why MindTree?
  • Ans. 

    MindTree's focus on innovation, culture of learning, and diverse opportunities make it an ideal fit for my career growth.

    • Strong focus on innovation and cutting-edge technologies

    • Culture of continuous learning and development

    • Diverse opportunities for growth and career advancement

  • Answered by AI
  • Q5. Plans for Higher Study
  • Ans. 

    I am currently focusing on gaining practical experience in the software engineering field, but I may consider pursuing higher studies in the future.

    • Currently focusing on gaining practical experience in software engineering

    • Open to considering higher studies in the future

    • Higher studies could include a Master's degree in Computer Science or related field

  • Answered by AI
  • Q6. About Relocation
  • Q7. Any Question?

Interview Preparation Tips

Round: Test
Experience: First round was aptitude test organised by our college through AMCAT
It had 4 section –
1. English – 25 questions (25 minutes)
2. Quantitative – 25 questions (35 minutes)
3. Technical – 25 questions (35 minutes)
4. Logical – 24 questions (35 minutes)
Practice previous Amcat papers. Technical was mostly from data structure and algorithm. There were very basic questions from Operating System and SQL. Each section had individual cut off . It was adaptive test so you can not go back to your previous answer.
Tips: If you are good in basics then you can easily score well in AMCAT.There is no negative marking in AMCAT.You have to manage time as some of the questions are lengthy.Follow R.S.Aggarwal book.
Topics to concentrate for Quantative:
· Time and Work
· Pipes and Cisterns
· Problems on Trains
· Boats and Streams
· Calendar and Clocks
· Probability
· Ratios and Percentage
· Number systems

Logical Ability
Analogy Pattern Recognition
Classification Pattern Recognition
Coding Pattern Recognition
Number Series Pattern Recognition
Direction sense, Blood relations, CDL
Puzzles, Logical word sequence
Selection decision table
Data sufficiency
Objective reasoning

English:

Synonyms/Antonyms/Word Meaning (Vocabulary)
Complete the Sentence (Grammar)
Spot error/Correct sentence (Grammar/sentence construction)
Sentence Ordering (Comprehension skills)
Questions based on passage (Comprehension skills)
Duration: 130 minutes
Total Questions: 99

Round: Resume Shortlist
Experience: Eligibility Criteria:

10th and 12th percentage - 65%
Aggregate of 60% in Engineering (BE / B.Tech/MCA only)
Please note the percentage calculation in case of CGPA:
Total marks obtained from in all the subjects from the first to last semester divided by total of maximum marks in all the subjects from first to last semester.
Candidates need to clear all exams before joining & should come with Degree Certificates
At the time of recruitment, Mindtree allow candidates to appear for the selection/interview process if they have less than 2 backlogs
Only Students from circuit branches can take part in the Mindtree selection process (branches mentioned below) :-
Computer Science and Engineering
Electronics
Electronics and Electricals
Electronics & Communication Engineering
Electronics & Instrumentation
Electronics and telecommunication Engineering
Information Science
Information Technology
Instrumentation Engineering
Telecommunication
MCA

Round: Test
Experience: This round is elimination round and your programs will be considered for technical round. There were 2 C/C++/Java programming questions and you need to type the program, compile and submit. Some hints will be on the screen. This test is conducted by Aspiring Minds. You have to focus on basics programming. There were two questions.One question from pattern printing and other one from array/pointer/String.
Tips: Focus on basic programming
Duration: 20 minutes
Total Questions: 2

Round: Technical Interview
Experience: Thorough discussion about the projects. My major work was on Advance Java, so the interviewer kept on grilling me. Questions on the database, challenges faced, control flow were asked. She even asked me about the implementation of my project. The interview ended with some questions on OOPs concepts.
Tips: Prepare both the programs which have been asked in Programming test. You are surely going to face this question. Prepare well with Logics.Apart from that you need to focus on C/Data Structure/DBMS/Basics of Operating System/Basics of OOPS.

C- Pointer/Array/Strings/Structure/Union
Data Structure : Linked List/Stack/Tree/Sorting/Traversal/SEaching

Round: HR Interview
Experience: This was end of d interview, thankfully I was able to answer all of them. I was the first candidate to enter .

I hope all that I shared above could help you in your preparation. Be confident and give your best.
Tips: In HR round, questions are of fixed type. in every Interview So preparee it from Indiabix.

General Tips: Focus on basics. The "basic" is most difficult to cover :D So Prepare well and be Confident
Skill Tips: Confidence is the key in all interview
Skills: Smartness, Ability To Think Of Creative Solutions, Technical Skill, Confidence
College Name: B P Poddar Institute of management and technology

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.
What are the top questions asked in TCS Informatica Developer interview?

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

  1. What transformations did use in Informt...read more
  2. Unix shell script for sending m...read more
  3. Diff between powercenter and I...read more

Tell us how to improve this page.

TCS Informatica Developer Interview Process

based on 5 interviews

1 Interview rounds

  • Technical Round
View more
TCS Informatica Developer Salary
based on 639 salaries
₹2.9 L/yr - ₹10.5 L/yr
9% less than the average Informatica Developer Salary in India
View more details

TCS Informatica Developer Reviews and Ratings

based on 33 reviews

4.3/5

Rating in categories

4.2

Skill development

4.2

Work-life balance

3.7

Salary

4.7

Job security

4.3

Company culture

3.2

Promotions

4.0

Work satisfaction

Explore 33 Reviews and Ratings
System Engineer
1.1L salaries
unlock blur

₹1 L/yr - ₹9 L/yr

IT Analyst
66.1k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

AST Consultant
51.8k salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Associate Consultant
30.1k salaries
unlock blur

₹9 L/yr - ₹32 L/yr

Assistant System Engineer
29.8k salaries
unlock blur

₹2.2 L/yr - ₹7 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

Accenture

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