What are the interview questions for Informatica?
Informatica Basic Interview Questions
- What do you mean by Enterprise data warehouse?
- What is ETL (Extract, transform, Load) and write some ETL tools.
- What is Informatica PowerCenter?
- Name different types of transformation that are important?
- Write the difference between connected lookup and unconnected lookup.
What are the roles and responsibilities of Informatica Developer?
An Informatica ETL Developer is responsible for developing, enhancing, debugging, maintaining, and testing software applications that support business units of an organization. They also maintain warehouse metadata and standards for future application development.
What is transformation in Informatica?
List of Transformations in Informatica
- Source Qualifier Transformation.
- Aggregator Transformation.
- Router Transformation.
- Joiner transformation.
- Rank Transformation.
- Sequence Generator Transformation.
- Transaction Control Transformation.
- Lookup and Re-usable transformation.
What skills are required for Informatica?
Informatica developers should have strong knowledge of the following tools:
- Informatica PowerCenter tools (workflow manager, workflow monitor, designer)
- Programming languages (SQL, XTML)
- Data platforms (Oracle, Teradata, Hadoop)
What is surrogate key in Informatica?
Surrogate key is a substitution for the natural primary key. Data warehouses typically use a surrogate, (also known as artificial or identity key), key for the dimension tables primary keys. They can use Infa sequence generator, or Oracle sequence, or SQL Server Identity values for the surrogate key.
Why Lookup is used in Informatica?
Lookup transformation is used to look up a source, source qualifier, or target to get the relevant data. For example, we can use a Lookup transformation to retrieve values from a database table for codes used in source data. …
Is Informatica easy?
It is extremely easy to use and there are a lot of automated processes as well. You can deploy Informatica for operations and governance oversight. Your analytics and applications can be fed with real-time data. You can do advanced transformations on data while moving from source to destination.
What is the interview process like at Capgemini?
Capgemini Interview Process 1 Recruitment Process: Capgemini conducts 3-4 rounds to select fresher as Software Developer in their organization. 2 Academic Criteria: 3 Written Round: The Written round consists of three major sections namely number series, General Aptitude Test, and English Assessment Test.
What should I not mention in my resume for Capgemini?
NOTE- You need not mention anything in your resume which is a lie or you are not sure of, as if there will be questions about your resume, and if you failed to answer them, that will have a negative impact. In the HR round of Capgemini Interview Process there is a good possibility of you getting nervous and conscious.
How many rounds are there in Capgemini exam for fresher?
Capgemini conducts 3-4 rounds to select fresher as Software Developer in their organization. 65 percent or above in B.Tech, Class X and XII. The Written round consists of three major sections namely number series, General Aptitude Test, and English Assessment Test.
Who is the CEO of Capgemini?
Paul Hermelin has been director and CEO of the Capgemini since his arrangement in December 2001. Capgemini was put at #665 in Forbes’ rundown of The World’s Largest Public Companies, at #233 Top Multinational Performers and at #391 in World’s Best Employers.