AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Infosys BPM
Compare
Filter interviews by
Infosys BPM Informatica ETL Developer Interview Questions and Answers
Infosys BPM Informatica ETL Developer Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Sep 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. Mostly questions about sedhuling and promote your code from dev to QA, QA to UAT &UAT to Production,
- Q2. Sql queries about joiners Transformations their relationships and difference between them
- Q3. Dwh questions everything because we don't where they are asking
- Q4. But definitely in dimenstions and fact table questions are mandatory to asking everyone
- Q5. Oltp and olap Process of dwh and data mart and data lifecycle
- Ans.
OLTP and OLAP are two different types of databases used in data warehousing. Data warehousing involves the process of creating a data warehouse and data marts to store and analyze data throughout its lifecycle.
OLTP (Online Transaction Processing) databases are used for transactional processing, while OLAP (Online Analytical Processing) databases are used for analytical processing.
Data warehousing involves the process o...
Interview Preparation Tips
In projects work have 3 questions and
Sql have 1 query question
And transformation about
Most important dwh questions have 5 so these are enough to crack the interview
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
(1 Question)
- Q1. About informatica,SQL,dwa
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. What is the difference between delete , truncate and drop?
- Ans.
Delete removes specific rows from a table, truncate removes all rows, and drop removes the entire table.
Delete is a DML operation, while truncate and drop are DDL operations.
Delete is slower as it logs individual row deletions, while truncate and drop are faster.
Delete can be rolled back, while truncate and drop cannot be rolled back.
Delete can have conditions to specify which rows to delete, while truncate and drop af...
- Q2. Write a SQL query to find the duplicates?
- Ans.
A SQL query to find duplicates in a table.
Use the GROUP BY clause to group the records by the columns that may have duplicates.
Use the HAVING clause to filter the groups that have more than one record.
Select the columns that you want to display in the result.
Order the result if necessary.
- Q3. Difference between union and union all
- Ans.
Union combines the result sets of two or more SELECT statements, while Union All combines all rows from two or more SELECT statements.
Union removes duplicate rows from the result set, while Union All does not.
Union requires the number and order of columns in all SELECT statements to be the same, while Union All does not have this requirement.
Union is slower than Union All because it performs a distinct operation, while...
- Q4. Write any analytical syntax.
- Ans.
An analytical syntax example is SELECT COUNT(*) FROM table_name;
Analytical syntax is used to retrieve and analyze data from databases
Commonly used in business intelligence and data warehousing
Other examples include GROUP BY, ORDER BY, and JOIN statements
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in May 2022. There were 3 interview rounds.
(6 Questions)
- Q1. What is filter transformation
- Ans.
Filter transformation is used to filter rows from a data source based on specified conditions.
Filter transformation is an active transformation in Informatica PowerCenter.
It allows you to define conditions to filter rows from the source data.
Rows that meet the filter conditions are passed to the next transformation, while others are dropped.
Filter transformation can be used to eliminate unwanted data or select specific...
- Q2. Difference between connected and unconnected lookup
- Ans.
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup is used in mapping flow, while unconnected lookup is used in expression transformation.
Connected lookup receives input values directly from the pipeline, while unconnected lookup receives input values from the calling transformation.
Connected lookup returns a value to the pipeline, while unconnected ...
- Q3. Diff between active and passive transformation
- Ans.
Active transformations change the number of rows that pass through it, while passive transformations do not.
Active transformations change the data stream by adding, deleting, or modifying rows
Passive transformations do not change the data stream, but may change the data within the stream
Active transformations include Filter, Router, Update Strategy, and Expression
Passive transformations include Aggregator, Joiner, Look
- Q4. How to improve performance
- Q5. What is pushdown automata
- Ans.
Pushdown automata is a type of automata that can recognize context-free languages.
Pushdown automata is a theoretical model of computation.
It has a stack that can be used to store and retrieve information.
It is used to recognize context-free languages.
It is more powerful than finite automata but less powerful than Turing machines.
Examples of context-free languages include arithmetic expressions and programming languages
- Q6. How to update table without using update startegy
- Ans.
Use SQL merge statement to update table without update strategy
Use SQL merge statement to update table
Specify the source and target tables
Define the join condition
Specify the columns to update
Use WHEN MATCHED THEN UPDATE statement
Use WHEN NOT MATCHED THEN INSERT statement
More on informatica and SQL code
(1 Question)
- Q1. Nothing difficult just discuss about pay scale
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.
Interview Preparation Tips
I applied via Company Website and was interviewed before Jul 2021. There were 2 interview rounds.
Attended the codevita competition in final year of college.
(3 Questions)
- Q1. About College Project
- Q2. Some very basics of java
- Q3. Experience of college project as a team
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Mar 2021. There were 2 interview rounds.
(5 Questions)
- Q1. If you cleared Aptitude and Coding, Mostly Interview will be cleared with some basics questions like OOPs concepts, sort functions kind of questions.
- Q2. Explain OOPs concept in JAVA?
- Ans.
OOPs concept in JAVA is a programming paradigm that focuses on objects and their interactions.
OOPs stands for Object-Oriented Programming
It involves the use of classes, objects, inheritance, polymorphism, and encapsulation
Classes are used to define objects and their properties
Objects are instances of classes that can interact with each other
Inheritance allows for the creation of new classes based on existing ones
Polymo...
- Q3. Function to sort an array in Java?
- Ans.
Java provides Arrays.sort() method to sort an array.
Use Arrays.sort() method to sort an array of strings.
The method sorts the elements in ascending order by default.
To sort in descending order, use Collections.reverseOrder() method.
- Q4. Tell me about yourself?
- Q5. Final year project which you worked on?
Interview Preparation Tips
Skills evaluated in this interview
I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions of java.
(1 Question)
- Q1. Intro and other hr related questions.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.
It was general aptitude with numerical,reasoning and general such questions with coding MCQ
(1 Question)
- Q1. Syntax and tech questions from c, python and oops. HR question was like what will I do if this happens in team. How will i face it or resolve it.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jun 2021. There were 4 interview rounds.
Aptitude test was easy. Preparation was good for about a month.
Direct interview was average.
GD was easy round and topic is also easy one.
(1 Question)
- Q1. HR round was average and salary discussion was there in this round.
Interview Preparation Tips
- Head first java
- Previous question paper
- Complete reference
Infosys BPM Interview FAQs
Some of the top questions asked at the Infosys BPM Informatica ETL Developer interview -
Tell us how to improve this page.
Infosys BPM Interviews By Designations
- Infosys BPM Processing Executive Interview Questions
- Infosys BPM Senior Processing Executive Interview Questions
- Infosys BPM Process Specialist Interview Questions
- Infosys BPM Accountant Interview Questions
- Infosys BPM Account Assistant Interview Questions
- Infosys BPM Business Analyst Interview Questions
- Infosys BPM System Engineer Interview Questions
- Infosys BPM Team Lead Interview Questions
- Show more
Interview Questions for Popular Designations
- Informatica Developer Interview Questions
- ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- ETL Lead Interview Questions
- Oracle Database Administrator Interview Questions
- Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Processing Executive
12.4k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Process Specialist
8.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Processing Executive
5k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Account Assistant
3.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Accountant
3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Accenture
TCS
Wipro
HCLTech
- Home >
- Interviews >
- Infosys BPM Interview Questions >
- Infosys BPM Informatica ETL Developer Interview Questions
