Skill Set Inventory Section

The skill set inventory is used to guide your preparation before taking the test. It is an outline of the technical topics and subject areas that are covered in each test. The skill set inventory includes test domain weighting, test objectives and topical content. The topics and concepts are included to clarify the test objectives.

Test takers will be tested on:

• Big Data Integration Course Introduction
• Big Data Basics
• Informatica on Hadoop Architecture
• Data Warehouse Offloading
• Code Migration and Ingestion
• Informatica Polyglot Computing in Hadoop
• Monitoring, Logs, and Troubleshooting
• Hadoop Data Integration Challenges and Performance Tuning
• Complex File Parsing
• NoSQL Databases
• Fundamentals
• Developing Physical Data Objects
• Viewing Data
• Developing Mappings and Transformations
• Working with Dynamic Schema and Dynamic Mappings
• Deploying Applications
• Parameters
• Workflows
• Edge Data Streaming (EDS) Overview
• Big Data Streaming Overview
• Kafka Overview
• Streaming Mappings
• Monitoring Logs and Troubleshooting
• Performance Tuning and Best Practices
• End-to-End Use Case 

Test Domains

The test domains and the extent to which they are represented as an estimated percentage of the test follows:

Question Format

You may select from one or more response offerings to answer a question.

You will score the question correctly if your response accurately completes the statement or answers the question. Incorrect distractors are given as possible correct answers so that those without the required skills and experience may wrongly select that choice.

A passing grade of 70% is needed to achieve recognition as an Informatica Certified Professional (ICP) as a Data Engineering 10.2 Developer, Certified Professional.

You are given 90 minutes to complete the test. Formats used in this test are:

• Multiple Choice:  Select one option that best answers the question or completes the statement
• Multiple Response: Select all that apply to best answer the question or complete the statement
• True/False: After reading the statement or questions select the best answer

Test Policy

• You are eligible for one attempt and re-take, if needed, per test registration.
• If you do not pass on your first attempt
• Purchase of the test will include one second-attempt if a student does not pass an test.
• You must wait two weeks after a failed test to take the test again.
• Any additional retakes are charged the current fee at the time of purchase.
• Promotions are excluded and cannot be combined.

Test Topics

The test will contain 70 questions comprised of topics that span across the sections listed below.  In order to ensure that you are prepared for the test, review the subtopics with each section.

Big Data Basics

• Hadoop concepts
• Hadoop Architecture Components
• The Hadoop Distributed File System (HDFS)
• MapReduce
• “Yet Another Resource Manager” (YARN)

Informatica on Hadoop Architecture

• Explanation of the Big Data world
• Illustrate the Informatica abstraction layer
• Informatica’s Polyglot computing engines
• Smart Executor
• Open Source through Innovation
• Connection architecture
• Informatica connections to third-party apps on Hadoop

Data Warehouse Offloading

• The requirements of an optimal Data Warehouse
• Data Warehouse Offloading Process

Code Migration and Ingestion

• Create and interpret PowerCenter Reuse Reports
• Import PowerCenter Mappings to Developer
• SQOOP
• SQL to Mapping capability for converting SQL code to    Informatica mappings

Informatica Polyglot Computing in Hadoop

• Hive MR/Tez
• Blaze
• Spark
• The Smart Executor

Monitoring, Logs, and Troubleshooting

• Monitor mappings
• Troubleshooting mappings in Hive

Hadoop Data Integration Challenges and Performance Tuning

• Challenges with executing mappings in Hadoop
• Partitioning and Parallel Workflows
• Big Data Management Performance Tuning
• Mapping Level Tuning

Complex File Parsing

• Complex file reader
• Data Processor transformation
• Complex file writer
• Performance Considerations: Partitioning
• Data Processor Transformation Considerations

Edge Data Streaming (EDS) Overview

• EDS architecture and key features
• EDS Data flow process
• EDS UI
• Create an EDS Service
• Create, deploy and monitor a data flow

Big Data Streaming Overview

• Big Data Streaming overview
• Stream Data Processing with Spark streaming
• BDS component architecture
• BDS key features

Kafka Overview

• Kafka Concepts
• Kafka core APIs
• Kafka models

NoSQL Databases

• NoSQL Databases - an overview
• Informatica HBase support
• Informatica MongoDB support
• Informatica Cassandra support

Fundamentals

• Introduction to the Developer tool
• Brief Overview of Big Data Management Architecture
• Reviewing the Developer interface

Developing Physical Data Objects

• Introduction to the types of physical data objects
• Using relational connections
• Using flat file connections
• Synchronize a flat-file data object

Viewing Data

• Introduction to data views
• Troubleshooting configurations
• Reviewing logs
• Monitoring activities

Developing Mappings and Transformations

• Mapping and transformation concepts
• Core transformations
• Developing and validating a mapping
• Using transformations in a mapping

Working with Dynamic Schema and Dynamic Mappings

• Introduction to dynamic mapping concepts
• Developing and running a dynamic mapping
• Reviewing a mapping template

Deploying Applications

• Deploying Applications for Users
• Create, deploy, and run an application

Parameters

• Using Parameters
• Types of Parameters
• Run mappings with parameter file and parameter set

Workflows

• Working with Workflows
• Create a workflow
• Configure a workflow
• Add a conditional sequence flow

Streaming Mappings

• Sources in a streaming mapping
• Targets in streaming Mapping
• Lookup sources
• Kafka Data Object Properties

Monitoring Logs and Troubleshooting

• Spark Monitoring
• Viewing Logs
• Troubleshooting

Performance Tuning and Best Practices

• Tune performance of Spark jobs
• Best practices while working with streaming data

End-to-End Use Case

• Use Case
• EDS and BDS – Final Goal

Sample Test Questions

Additional Information

Retake Policy: Current purchases of the test will include one second-attempt if a student does not pass a test. Any additional retakes are charged the current fee at the time of purchase. Promotions are excluded and cannot be combined. You must wait two weeks after a failed test to take the test again.

Informatica University has a community page so students can assist one another in their test preparation within the Informatica Network: https://network.informatica.com/welcome