Upload Button Icon Add office photos

Filter interviews by

Informatica Software Engineer Interview Questions and Answers

Updated 16 Nov 2024

Informatica Software Engineer Interview Experiences

6 interviews found

Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Coding Test 

2 coding questions + few MCQ based on java and spring boot

Round 2 - Technical 

(3 Questions)

  • Q1. Java basic questions
  • Q2. Spring question
  • Q3. Print Matrix in spiral form coding question
  • Ans. 

    Print a matrix in spiral form

    • Iterate through the matrix in a spiral pattern, printing each element

    • Keep track of the boundaries of the matrix as you move along

    • Handle cases where the matrix is not a perfect square separately

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Informatica Software Engineer interview:
  • Java
  • Spring Boot
  • Spring Framework
  • Data Structures
Interview preparation tips for other job seekers - Interview was medium to hard couldn't solve coding question in time limit so wasn't called for round 2.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

Python, java, sql along with theoretical knowledge

Round 2 - Technical 

(3 Questions)

  • Q1. Questions on databases
  • Q2. Questions on algorithms
  • Q3. Coding related questions
Round 3 - HR 

(2 Questions)

  • Q1. Tell about yourself.
  • Q2. Strengths and weaknesses

Software Engineer Interview Questions Asked at Other Companies

asked in Qualcomm
Q1. Bridge and torch problem : Four people come to a river in the nig ... read more
asked in Capgemini
Q2. In a dark room,there is a box of 18 white and 5 black gloves. You ... read more
asked in TCS
Q3. Find the Duplicate Number Problem Statement Given an integer arra ... read more
Q4. Tell me something about yourself. Define encapsulation. What is i ... read more
asked in Paytm
Q5. Puzzle : 100 people are standing in a circle .each one is allowed ... read more

Software Engineer Interview Questions & Answers

user image KUNAL KISHOR

posted on 16 Nov 2024

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

ALGORTIH DS JAVA SPRING BOOT

Interview Questionnaire 

2 Questions

  • Q1. Interview is mainly focused on problem solving skills using data structures and algorithms
  • Q2. There was a problem to be solved using modified binary search and another problem using graphs traversal

Informatica interview questions for designations

 Senior Software Engineer

 (1)

 Principal Software Engineer

 (1)

 Software Developer

 (1)

 QA Engineer

 (2)

 System Engineer

 (1)

 Lead Engineer

 (1)

 QA Test Engineer

 (1)

 Senior QA Engineer

 (1)

I applied via Referral

Interview Questionnaire 

6 Questions

  • Q1. Your contribution in your projects?
  • Ans. 

    I have contributed to my projects by developing and implementing new features, fixing bugs, and improving overall performance.

    • Developed and implemented new features

    • Fixed bugs and issues

    • Improved overall performance

    • Collaborated with team members to ensure project success

    • Provided technical support and troubleshooting assistance

  • Answered by AI
  • Q2. How you resolve problems within team?
  • Ans. 

    I encourage open communication and collaboration to identify and solve problems within the team.

    • Encourage open communication and active listening

    • Identify the root cause of the problem

    • Brainstorm solutions as a team

    • Assign tasks and follow up on progress

    • Evaluate the effectiveness of the solution

    • Provide constructive feedback

    • Celebrate successes and learn from failures

  • Answered by AI
  • Q3. What are your expectations from the company?
  • Ans. 

    I expect a company that values innovation, growth opportunities, and work-life balance.

    • Opportunities for professional development and growth

    • A culture that encourages innovation and creativity

    • A healthy work-life balance

    • Clear communication and transparency

    • Competitive compensation and benefits

    • Collaborative and supportive team environment

  • Answered by AI
  • Q4. Do you have any plans of higher studies?
  • Ans. 

    Yes, I am planning to pursue a Master's degree in Computer Science.

    • I am interested in specializing in Artificial Intelligence.

    • I have already researched and shortlisted a few universities.

    • I plan to apply for the next academic year.

    • I believe higher studies will help me gain a deeper understanding of the field and advance my career.

  • Answered by AI
  • Q5. How flexible you are in professional life?
  • Ans. 

    I am very flexible in my professional life and can adapt to changing situations easily.

    • I am open to learning new technologies and skills

    • I can work in different environments and with different teams

    • I am willing to take on new challenges and responsibilities

    • I can adjust my work schedule to meet project deadlines

    • I am comfortable with remote work and flexible work arrangements

  • Answered by AI
  • Q6. Tell me about your self?
  • Ans. 

    I am a software engineer with experience in developing web applications and a passion for problem-solving.

    • Experienced in developing web applications using languages such as Java, Python, and JavaScript

    • Proficient in using frameworks such as Spring, Django, and React

    • Strong problem-solving skills and ability to work in a team environment

    • Passionate about learning new technologies and keeping up with industry trends

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 55 questions in 60 minutes of which 45 were technical and 10 were aptitude questions and there was no negative marking. The technical questions covered RDBMS, UNIX, C, C++, Java, Operating systems, Data structures and Algorithms. The questions were simple and the basics of each of the mentioned subjects were mainly asked.
Duration: 60 minutes
Total Questions: 55

Round: Test
Experience: Again mainly questions on the subjects covered in round 1 but bit more in deep questions required short but detailed answers.
Tips: Learn to write pretty good Unix Scripts and Know the Basics of Operating System & OOP
Duration: 40 minutes
Total Questions: 10

Round: Technical Interview
Experience: Questions mainly on UNIX & RDBMS. Interviewer will ask you to write UNIX scripts and SQL/JAVA-SQL queries/programs for some use cases.
Tips: Know how JOINS, INTERSECTION, UNION & Aggregation works in SQL.

Round: Technical Interview
Experience: Questions on Programming, Data Structure and algorithms.
You will be asked to write pseudo-program for some of the use cases.
Tips: Choose your programming language cleverly. ;)

Round: Other Interview
Experience: Round 5 is an interview with Technical Manager.
Questions are asked based on the content of your resume like projects, hobbies and traits.
Few puzzle questions are asked which usually can be answered with logical analysis.
Tips: Be prepared for questions on the answer you give for the previous question(s).

Round: HR Interview
Experience: Again question will be asked on the basis of your resume. Questions may also asked on your previous interview experience if you have any.
Tips: Clear your doubts before leaving the room.

General Tips: Be confident, be straight forward, do not try to bluff with answers and try to be creative with answers. Prepare well both technical and aptitude.
Skills: Algorithms And Data Structures, Operating Systems, Unix, SQL, Java Programming, Object-Oriented Programming (OOP), C Programming
College Name: JSS Mahavidyapeetha Sri Jayachamarajendra College Of Engineering, Mysore
Motivation: Work Environment of Informatica.

Interview Preparation Tips

Round: Test
Experience: Round 1: Online objective test.
There were questions from Operating Systems, C, Algorithms, Data Structures.

Round 2: Online and subjective (choose language C++ or JAVA). This round had 15 questions.
Data structures, C++ questions, Fibonacci optimisation, algorithms (DFS/BFS).

Round: Technical Interview
Experience: In the first round of interview they asked me questions about :1) My project (asked no. of classes and mention their responsibilities).
2) ACID properties of database and indexing in a database.

There were also questions related to OOPS concepts including polymorphism, composition, aggregation, inheritance, Abstract classes, interface; difference between usage of abstract class and interface, can abstract class be instantiated, how to access child class methods having reference of base class.
There was another question on run time and compile time binding and under which category do we classify method overloading and also questions on code for deleting the duplicate nodes in a sorted link list and printing root to leaf paths in a binary search tree.

Round: Technical Interview
Experience: This was the second round of the interview. They asked me the following questions,There is a tree (not binary) and all non-leaf nodes are RED in colour. Some leaf nodes are white in colour. If a node has all white coloured children then its colour can be changed into white. So we have to convert maximum number of nodes into white colour – write program for the same.
Code for checking whether a given binary tree balanced or not.
What are virtual functions, what is their role?
Questions related to virtual functions.

You are given the details of each transaction of each item i.e. item_name, quantity, price. So at the end of the day, you want top 50 items that have been sold. There are two cases:
In the first case you have fixed number of items.
In the second case very large number of items – so you need to decide what data structure to be used for this.

Round: Technical Interview
Experience: In the third round of the interview they asked questions like :
1) Types of tree traversals (breadth first and depth first (pre, post, in)
2) Determining width of binary tree i.e. using breadth wise traversal
3) Why files are preferred over databases?

College Name: IIT KANPUR

Interview questions from similar companies

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

It was about 45mins aptitude test .

Round 2 - Technical 

(1 Question)

  • Q1. I was asked about the double Linked list, stack ,Queue.
Round 3 - Technical 

(1 Question)

  • Q1. Logical questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed in Jun 2023.

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 - HR 

(2 Questions)

  • Q1. Will you be able to work in Rotational Shifts?
  • Q2. How much experience do you have in SQL and Node JS.
  • Ans. 

    I have 5 years of experience in SQL and Node JS.

    • I have worked extensively with SQL databases, writing complex queries and optimizing performance.

    • I am proficient in using Node JS for server-side development, building RESTful APIs and handling database operations.

    • I have experience in integrating SQL databases with Node JS applications using libraries like Sequelize or Knex.

    • I have successfully delivered projects that invo...

  • Answered by AI
Round 3 - One-on-one 

(5 Questions)

  • Q1. What is Index in SQL?
  • Ans. 

    Indexes in SQL are data structures that improve the speed of data retrieval operations on database tables.

    • Indexes are created on one or more columns of a table to allow faster searching and sorting of data.

    • They work similar to the index of a book, allowing the database engine to quickly locate the data.

    • Indexes can be created on primary keys, foreign keys, or any other frequently searched columns.

    • They reduce the amount ...

  • Answered by AI
  • Q2. What are the different types of Normalization in DBMS?
  • Ans. 

    Normalization is a process in DBMS that eliminates data redundancy and ensures data integrity.

    • Normalization is used to organize data in a database efficiently.

    • There are different normal forms, such as 1NF, 2NF, 3NF, BCNF, and 4NF.

    • Each normal form has specific rules and dependencies to achieve data normalization.

    • Normalization helps in reducing data duplication, improving data consistency, and simplifying database mainte...

  • Answered by AI
  • Q3. What do you know about Views in mySQL?
  • Ans. 

    Views in mySQL are virtual tables that are based on the result of a query. They can be used to simplify complex queries and provide a layer of abstraction.

    • Views are created using the CREATE VIEW statement.

    • They are stored in the database and can be accessed like regular tables.

    • Views can be used to hide complexity by encapsulating complex queries into a single view.

    • They can also be used to restrict access to certain colu...

  • Answered by AI
  • Q4. What are Stored Procedures?
  • Ans. 

    Stored Procedures are precompiled database objects that contain a set of SQL statements and can be executed with a single call.

    • Stored Procedures are used to encapsulate and execute frequently used SQL statements.

    • They improve performance by reducing network traffic and optimizing query execution.

    • They can accept input parameters and return output values.

    • Stored Procedures can be used for data manipulation, data retrieval,...

  • Answered by AI
  • Q5. Tell me something about Internet of Things.
  • Ans. 

    Internet of Things (IoT) refers to the network of physical devices, vehicles, appliances, and other objects embedded with sensors, software, and connectivity.

    • IoT enables devices to collect and exchange data over the internet.

    • It allows for remote monitoring and control of devices and systems.

    • IoT has applications in various industries such as healthcare, transportation, agriculture, and smart homes.

    • Examples of IoT device...

  • Answered by AI
Round 4 - Client Interview 

(6 Questions)

  • Q1. Questions about Past Experience, the projects I have worked on.
  • Q2. What does JWT stand for? How do we use them?
  • Ans. 

    JWT stands for JSON Web Token. It is a compact, URL-safe means of representing claims between two parties.

    • JWT is used for authentication and authorization purposes in web applications.

    • It consists of three parts: header, payload, and signature.

    • The header contains the algorithm used to sign the token.

    • The payload contains the claims or information about the user.

    • The signature is used to verify the integrity of the token.

    • J...

  • Answered by AI
  • Q3. What is the difference between Webtokens and APIs?
  • Ans. 

    Webtokens and APIs are both used in web development, but they serve different purposes.

    • Webtokens are used for authentication and authorization, providing a secure way to transmit user information between client and server.

    • APIs (Application Programming Interfaces) are sets of rules and protocols that allow different software applications to communicate and interact with each other.

    • Webtokens are often used within APIs to...

  • Answered by AI
  • Q4. What is oAuth, what method did you use for Authentication/ Authorisation is your project?
  • Ans. 

    oAuth is an open standard for authorization. In my project, I used the oAuth 2.0 protocol for authentication and authorization.

    • oAuth is a protocol that allows users to grant limited access to their resources on one website to another website without sharing their credentials.

    • It provides a secure way for users to authenticate and authorize third-party applications to access their data.

    • oAuth 2.0 is the most widely used v...

  • Answered by AI
  • Q5. If the data in a table is already normalized, what can we do to further optimize is?
  • Ans. 

    Further optimization of normalized data can be achieved through indexing, denormalization, and caching.

    • Create appropriate indexes on frequently queried columns to improve query performance.

    • Consider denormalizing the data by combining related tables to reduce the number of joins required.

    • Implement caching mechanisms to store frequently accessed data in memory for faster retrieval.

    • Use materialized views or summary tables...

  • Answered by AI
  • Q6. How do you perform indexing in a database, which column you use for indexing?
  • Ans. 

    Indexing in a database improves query performance by creating a data structure that allows for faster data retrieval.

    • Indexing involves creating an index on one or more columns of a database table.

    • The column used for indexing should be chosen based on the frequency of data retrieval and the cardinality of the column.

    • Columns with high selectivity and frequent data retrieval are good candidates for indexing.

    • Examples of co...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected
Round 1 - Resume Shortlist 
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
Round 2 - Coding Test 

Very hard question and 4 qs in total

Round 3 - Technical 

(1 Question)

  • Q1. Tell me about yourself
Round 4 - HR 

(1 Question)

  • Q1. Tell me about 5 years after now
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Job Fair

Round 1 - Group Discussion 

I attended through campus placement.they gave a general topic and ask us to speak

Round 2 - Technical 

(1 Question)

  • Q1. What is variable html structure coding in array
  • Ans. 

    A variable is a storage location in a computer program that holds data and can be referenced and manipulated.

    • Variables are used to store data in a program and can be of different types such as integers, strings, or arrays.

    • In HTML, variables are not directly used, but data can be stored in attributes or elements for manipulation.

    • Coding in an array involves storing multiple values in a single variable, accessed by index

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. It was just a simple general discussion about the timings

Skills evaluated in this interview

Informatica Interview FAQs

How many rounds are there in Informatica Software Engineer interview?
Informatica interview process usually has 2 rounds. The most common rounds in the Informatica interview process are Coding Test, Technical and HR.
How to prepare for Informatica Software Engineer 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 Informatica. The most common topics and skills that interviewers at Informatica expect are Informatica, Troubleshooting, Data Management, Agile and Data Structures.
What are the top questions asked in Informatica Software Engineer interview?

Some of the top questions asked at the Informatica Software Engineer interview -

  1. Print Matrix in spiral form coding quest...read more
  2. There was a problem to be solved using modified binary search and another probl...read more
  3. Interview is mainly focused on problem solving skills using data structures and...read more

Tell us how to improve this page.

Informatica Software Engineer Interview Process

based on 4 interviews

1 Interview rounds

  • Coding Test Round
View more
Informatica Software Engineer Salary
based on 178 salaries
₹8 L/yr - ₹30 L/yr
116% more than the average Software Engineer Salary in India
View more details

Informatica Software Engineer Reviews and Ratings

based on 6 reviews

3.4/5

Rating in categories

3.2

Skill development

4.1

Work-life balance

3.5

Salary

3.0

Job security

3.8

Company culture

3.0

Promotions

3.3

Work satisfaction

Explore 6 Reviews and Ratings
Software Engineer
178 salaries
unlock blur

₹8 L/yr - ₹30 L/yr

Senior Software Engineer
144 salaries
unlock blur

₹10 L/yr - ₹40 L/yr

Associate Software Engineer
72 salaries
unlock blur

₹6 L/yr - ₹16.8 L/yr

Lead Software Engineer
59 salaries
unlock blur

₹24 L/yr - ₹51 L/yr

Senior QA Engineer
58 salaries
unlock blur

₹13 L/yr - ₹26 L/yr

Explore more salaries
Compare Informatica with

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Tech Mahindra

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