AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Informatica Interview Questions and Answers
37 Interview questions
Shell scripts using grep and awk are powerful for text processing and data extraction in Unix/Linux environments.
Grep Usage: Use 'grep' to search for specific patterns in files. Example: 'grep "error" logfile.txt' finds all lines containing 'error'.
Awk for Field Processing: 'awk' can process and analyze text files by fields. Example: 'awk '{print $1}' data.txt' prints the first column of data.
Combining Grep and Aw...
I prioritize the issue based on severity, communicate with relevant teams, and provide regular updates to the customer.
Prioritize issues based on severity to ensure critical issues are resolved first
Communicate effectively with relevant teams to address the issue promptly
Provide regular updates to the customer on the progress of issue resolution
Segment customers based on their needs, behavior, and demographics.
Segment based on customer needs and pain points
Segment based on customer behavior and usage patterns
Segment based on demographics such as age, location, industry, etc.
Project framework is a structure that provides guidelines, tools, and libraries for developing software applications.
Provides a foundation for organizing code and implementing best practices
Includes libraries, tools, and templates to streamline development process
Can be specific to a programming language or technology stack
Examples: Angular for front-end web development, Spring for Java applications
Waits in Selenium are used to make the automation script wait for a certain condition to be met before proceeding.
Implicit Wait: Waits for a certain amount of time before throwing an exception if the element is not found.
Explicit Wait: Waits for a certain condition to be met before proceeding.
Fluent Wait: Waits for a certain condition with a defined polling frequency.
Prints the elements of a matrix in a spiral order, starting from the top-left corner.
Initialize boundaries: top, bottom, left, right.
Iterate while top <= bottom and left <= right.
Traverse from left to right along the top boundary, then increment top.
Traverse from top to bottom along the right boundary, then decrement right.
Traverse from right to left along the bottom boundary, then decrement bottom.
Traverse ...
Normalizations are used to standardize data by removing redundancies and inconsistencies.
Normalizations help in organizing data in a consistent and efficient manner.
They reduce data redundancy by eliminating duplicate information.
Normalization ensures data integrity and accuracy by avoiding inconsistencies.
Examples include normalizing database tables to reduce data duplication and improve query performance.
AWS SQS (Simple Queue Service) is a fully managed message queuing service that enables decoupling of components in a distributed system.
Used for storing messages in a queue before they are processed by a consumer
Supports distributed systems by enabling asynchronous communication between components
Helps in decoupling different parts of a system, improving scalability and fault tolerance
Messages can be stored in SQS...
Use dynamic programming to find the longest increasing decreasing subsequence in an array.
Use dynamic programming to keep track of the length of the longest increasing subsequence ending at each index.
Similarly, keep track of the length of the longest decreasing subsequence starting at each index.
Combine the two to find the longest increasing decreasing subsequence.
Random and dynamic data requests are requests for data that is not predetermined or fixed.
Random data requests are requests for data that is not predetermined or fixed.
Dynamic data requests are requests for data that changes frequently.
Examples of random and dynamic data requests include user input, sensor data, and API responses.
Informatica Interview Experiences
29 interviews found
Anonymous
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. What is the purpose of Persistent Volume Claims (PVC) in Kubernetes, and what measures can be taken to secure the master node? and also asked about PDB
- Ans.
PVCs in Kubernetes manage storage requests, while securing the master node involves various best practices.
Persistent Volume Claims (PVC) allow users to request storage resources dynamically.
PVCs abstract the underlying storage, enabling portability across different environments.
Example: A PVC can request a specific size and access mode (ReadWriteOnce) for a database pod.
To secure the master node, use role-based access...
- Q2. Shell script using grep and awk commands
- Ans.
Shell scripts using grep and awk are powerful for text processing and data extraction in Unix/Linux environments.
Grep Usage: Use 'grep' to search for specific patterns in files. Example: 'grep "error" logfile.txt' finds all lines containing 'error'.
Awk for Field Processing: 'awk' can process and analyze text files by fields. Example: 'awk '{print $1}' data.txt' prints the first column of data.
Combining Grep and Awk: Yo...
I applied via LinkedIn and was interviewed in Jun 2024. There were 2 interview rounds.
2 coding questions + few MCQ based on java and spring boot
(3 Questions)
- Q1. Java basic questions
- Q2. Spring question
- Q3. Print Matrix in spiral form coding question
Interview Preparation Tips
- Java
- Spring Boot
- Spring Framework
- Data Structures
Skills evaluated in this interview
I applied via Campus Placement
Python, java, sql along with theoretical knowledge
(3 Questions)
- Q1. Questions on databases
- Q2. Questions on algorithms
- Q3. Coding related questions
(2 Questions)
- Q1. Tell about yourself.
- Q2. Strengths and weaknesses
I applied via Company Website and was interviewed in Aug 2024. There was 1 interview round.
1. SQL Question - Query the average population for all cities in a CITY, round the number
2. Medium Difficulty DSA Question - Print all permutations of a String
I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. How do you segment your customers
- Ans.
Segment customers based on their needs, behavior, and demographics.
Segment based on customer needs and pain points
Segment based on customer behavior and usage patterns
Segment based on demographics such as age, location, industry, etc.
- Q2. How do you get issues resolved for the customer
- Ans.
I prioritize the issue based on severity, communicate with relevant teams, and provide regular updates to the customer.
Prioritize issues based on severity to ensure critical issues are resolved first
Communicate effectively with relevant teams to address the issue promptly
Provide regular updates to the customer on the progress of issue resolution
Interview Preparation Tips
KUNAL KISHOR
ALGORTIH DS JAVA SPRING BOOT
(1 Question)
- Q1. Questions will be added on java programming, basics of java, unix concepts.
(1 Question)
- Q1. Collections, patterns, multithreading, exception handling, file handling questions.
Harper rank coding question
(1 Question)
- Q1. Why you left previous company. What’s ur expections.
Kaviya Kumar
I appeared for an interview in Jun 2024.
Coding on java,with explanation video, proctored
(2 Questions)
- Q1. Explain project framework
- Ans.
Project framework is a structure that provides guidelines, tools, and libraries for developing software applications.
Provides a foundation for organizing code and implementing best practices
Includes libraries, tools, and templates to streamline development process
Can be specific to a programming language or technology stack
Examples: Angular for front-end web development, Spring for Java applications
- Q2. Explain waits in selenium
- Ans.
Waits in Selenium are used to make the automation script wait for a certain condition to be met before proceeding.
Implicit Wait: Waits for a certain amount of time before throwing an exception if the element is not found.
Explicit Wait: Waits for a certain condition to be met before proceeding.
Fluent Wait: Waits for a certain condition with a defined polling frequency.
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. What is AWS SQS and
- Ans.
AWS SQS (Simple Queue Service) is a fully managed message queuing service that enables decoupling of components in a distributed system.
Used for storing messages in a queue before they are processed by a consumer
Supports distributed systems by enabling asynchronous communication between components
Helps in decoupling different parts of a system, improving scalability and fault tolerance
Messages can be stored in SQS for ...
- Q2. What is the use of Normalizations
- Ans.
Normalizations are used to standardize data by removing redundancies and inconsistencies.
Normalizations help in organizing data in a consistent and efficient manner.
They reduce data redundancy by eliminating duplicate information.
Normalization ensures data integrity and accuracy by avoiding inconsistencies.
Examples include normalizing database tables to reduce data duplication and improve query performance.
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Nov 2023. There were 3 interview rounds.
(1 Question)
- Q1. Rolling Sales, YTD, MTD, Calendar Table, Fiscal Year from April
(1 Question)
- Q1. SQL- WIndows, CTEs
(1 Question)
- Q1. Salary Expectations, WFH options
Top trending discussions
Informatica Interview FAQs
Some of the top questions asked at the Informatica interview -
The duration of Informatica interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Informatica Interviews By Designations
- Informatica Software Engineer Interview Questions
- Informatica QA Engineer Interview Questions
- Informatica Lead Engineer Interview Questions
- Informatica QA Lead Interview Questions
- Informatica Technical Writer Interview Questions
- Informatica Software Developer Interview Questions
- Informatica Senior Software Engineer Interview Questions
- Informatica R&D Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 23 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Informatica Reviews and Ratings
based on 142 reviews
Rating in categories
|
Software Engineer
179
salaries
|  ₹13.4 L/yr - ₹22 L/yr |
|
Senior Software Engineer
159
salaries
| ₹20 L/yr - ₹35 L/yr |
|
Associate Software Engineer
77
salaries
| ₹9.9 L/yr - ₹16 L/yr |
|
Lead Software Engineer
67
salaries
| ₹28 L/yr - ₹51 L/yr |
|
Senior QA Engineer
59
salaries
| ₹16 L/yr - ₹26 L/yr |
Oracle
Amdocs
Automatic Data Processing (ADP)
24/7 Customer
- Home >
- Interviews >
- Informatica Interview Questions
