Informatica Cloud Training
IICS – Informatica Intelligent Cloud Services (Data Integration)
Informatica Cloud Data Integration is the cloud based Power Center which delivers accessible, trusted, and secure data to facilitate more valuable business decisions. Informatica Cloud Data Integration can help you and your organization with global, distributed data warehouse and analytics projects.
KEY FEATURES
30 Hrs Instructor Led Training
20 hrs Lab Sessions
100 + Professionals Trained
Pay in 2 Installments
Certification and Job Assistance
Flexible Schedule
COURSE OVERVIEW
Informatica Cloud is a data integration solution and platform that works like Software as a Service (SaaS). It integrates cloud-based data with the data residing in on-premise databases and systems or between cloud applications.
Informatica Cloud Data Integration is the cloud based Power Center which delivers accessible, trusted, and secure data to facilitate more valuable business decisions. Informatica Cloud Data Integration can help you and your organization with global, distributed data warehouse and analytics projects.
If you are using a cloud data warehouse like AWS Redshift, Azure SQL Data Warehouse, or Snowflake, you can use Informatica Cloud Data Integration solutions to help improve the overall performance, productivity, and extensive connectivity to cloud and on-premises sources.
Informatica Cloud can connect to on-premises and cloud-based applications (like Salesforce, Marketo, NetSuite, Workday) databases, flat files, file feeds, and social networking sites .
Learning Informatica Cloud will benefit the following professionals:
- Business Intelligence professionals
- Testing professionals
- Business analysts
- DBA professionals
The following are the prerequisites required for learning Informatica Cloud course:
Basic knowledge of,
- Database,
- Oracle SQL, and
- Informatica Power Center.
To enhance your existing skills, you can go through our self paced video on:
- SQL
- Oracle
The skills that the user gains upon completion of the training course are listed below:
- Understand various Cloud Computing types
- All the aspects for one to get started with Informatica Cloud Data Integration Service
- All related Administration activities for Data Integration Service/Module
- Step by step aspects for creating a mapping, mapping tasks, and linear task flows on the cloud
- Creation and Execution of Data Synchronization and Data Replication tasks
- Migration aspects of Informatica Data Integration Service
- Connectivity to multiple cloud-based and on-premise technologies
- Informatica Cloud is one of the fast-growing sectors in the market as major business users are opting this customizable open source tool.
- The demand for Informatica Cloud professionals is significantly increasing over the past few years.
- The average salary of a certified Informatica Cloud professional is $144,763 per annum.
INFORMATICA CLOUD COURSE CONTENT
- Informatica Cloud
- Object Synchronization
- Process Synchronization
- Data Replication
- Informatica Cloud Applications
- Informatica Cloud – Key Terms
- Informatica Cloud Architecture
- Informatica Cloud Secure Agent
- Informatica Secure Agent Architecture
- Running Agent as Local/Network User
- Connection Properties
- Connection types
- Configuring a connection
- Creating a Salesforce.com Connection
- Creating a Flat File Connection
- Data Synchronization application
- Data Synchronization Operations
- Field Information
- Data Replication App Overview
- Data Replication Features and Benefits
- Data Replication Source and Target Options
- Other Data Replication Task Options
- Resetting the Target Table
- Cloud Mapping Designer use cases
- Mapping Lifecycle
- Transformations in Cloud Mapping Designer
- Mapping Validation
- Creating a Simple Mapping using a Source, Filter, and Multiple Targets
- Joiner, Expression, and Lookup transformations
- Field Rules: Renaming Fields, Selection Criteria
- Creating a Mapping using the Lookup and Expression Transformations
- Aggregator Transformation Overview
- Aggregator Transformation – Source and Target
- Normalizer Transformation
- Normalized Fields
- Lookup Transformation
- Unconnected Lookup
- Data Filter
- Simple and Advanced Data Filter
- System Variables in a Data Filter
- Incremental Processing
- Field Expression
- Mapping Task
- Parameterization use cases
- Adding Parameters to a Mapping
- Parameter Types
- Parameter Panel and Best Practices
- Mapping Updates and Deployment
- Creating, testing, and running a Mapping Task
- Pre and Post-Processing Commands
- Operating System Commands
- Parameter File
- Setting Up a Parameter File
- Schedules
- Schedule Repeat Frequency
- Repeat Frequency Options
- Schedule Blackout Period
- Email Notifications
- Linear Taskflow Overview
- Tasks included in a Linear Taskflow
- Properties of a Linear Taskflow
- Scheduling a Taskflow
- What is a Taskflow?
- Task flow Steps
- Task flow Templates
- SQL Overrides in Lookups
- Lookup SQL Override Attributes
- Pre and Post SQL commands
- Multiple Object Source Type
- Salesforce Objects – Options
- Salesforce Data Model and ERDs
- Saved Queries
- Purpose of external ID
- External ID fields in Salesforce.com
- Foreign Keys
- Salesforce ID
- Relationships – Master-Detail relationship
- Relationships – Lookup relationship
- Force.com
- Workbench
- Data Loader
- Mapping, Sync and Replication task for SFDC
- Data Synchronization Operations – IDs
- Lookup Overview
- Configuring a Lookup
- Lookup Best Practices
- Hierarchical Schemas
- Hierarchy Parser Transformation
- Hierarchy Builder Transformation
- Web Services and-REST Web Services
- Parameters of REST Web Service Message
- Web Service Transformation
- Using Web Service Transformation in a mapping
- What is a REST API?
- Informatica Cloud REST API
- Partitions
- Types of Partitioning
- Partitioning Rules and Guidelines
- Secure Agent Groups with Multiple Agents
- Discovery IQ Overview
- Discovery IQ Features
- Parameterization
- Use case and solution
- Advanced Parameterization
- Parameterization technique in a mapping
- Custom Roles
- Asset Level Permissions
- Rules and Guidelines for Permissions
- Project or Folder Access Using User Groups
- Administrative settings for the organization
- User Roles
- User Groups
- Object-level permissions
- Organization hierarchy
- Migrating Assets
Frequently asked questions
The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.
In case you are not able to attend any lecture, you can view the recorded session of the class in Icronix . To make things better for you, we also provide the facility to attend the missed session in any other live batch.
The trainer is a certified consultant and has significant amount of experience in working with the technology.
Yes, we accept payments in two installments.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.