Enrolling now
IDMC (Informatica) Cloud Data Integration
Informatica Cloud the way real ETL teams use it, from secure agent to automated taskflows.
- Level
- Beginner to Intermediate
- Duration
- Shared on demo call
- Format
- Live online, small batches
- Timing
- Morning batch, IST
About this course
Learn Informatica Intelligent Data Management Cloud (IDMC, earlier IICS) Cloud Data Integration hands-on. Set up the secure agent and connections, build mappings and mapping tasks, replicate, mask and mass ingest data, orchestrate with taskflows, tune performance and automate everything with schedules and REST APIs.
Who this is for
- PowerCenter and on-premise ETL developers moving to Informatica Cloud
- SQL and Oracle developers who want an ETL career
- Fresh graduates who want a first job in data integration
- Data engineers who support Informatica pipelines at work
What you will be able to do
- Explain the Informatica Cloud architecture and its CDI assets
- Install the secure agent and create connections
- Build synchronization and data transfer tasks
- Create mappings and mapping tasks in Cloud Mapping Designer
- Create replication, masking and mass ingestion tasks
- Orchestrate jobs with taskflows and IICS REST web services
- Parse JSON and XML with Intelligent Structure Model
- Handle exceptions and tune job performance with partitions and pushdown optimization
- Automate and monitor tasks with schedules and alerts
- Manage users, groups, custom roles and assets as an IICS admin
Real-time end-to-end project
Build. Deploy. Showcase. Add it to your portfolio.
One complete project, the same flow production data teams use.
- 01
Connect
Secure Agent
- 02
Extract
Oracle and files
- 03
Transform
Mapping Designer
- 04
Load
Cloud targets
- 05
Orchestrate
Taskflows
- 06
Monitor
Schedules and alerts
Key highlights
- All 18 modules of Cloud Data Integration covered
- Live demos for mappings, taskflows and admin
- Performance tuning and pushdown optimization
- Exception handling the way production jobs need it
- Admin skills: users, roles, sub-orgs and asset migration
- Resume and interview guidance
- Interview support and work support
- Doubt support even after the course
Full curriculum
What you will learn, module by module
Every topic below is taught live, with hands-on practice. Tap a module to see its topics.
- Modules
- 18
- Topics
- 149
- Duration
- Shared on demo call
- Mode
- Online
01Informatica Cloud Overview5 topics
- 1.1Informatica Intelligent Cloud Services (IICS) as an iPaaS solution
- 1.2Informatica Cloud Terminologies
- 1.3Informatica Cloud Architecture
- 1.4CDI Assets
- 1.5CDI Components
02Runtime Environments and Connections9 topics
- 2.1Runtime Environments
- 2.2Secure Agent Architecture
- 2.3Secure Agent Status
- 2.4Elastic Server
- 2.5Secure Agent Services
- 2.6IICS Log Files
- 2.7Connections
- 2.8Connection Types
- 2.9Creating Connections
03Synchronization and Data Transfer Task9 topics
- 3.1Synchronization Task Overview
- 3.2Synchronization Task: Definition Step
- 3.3Synchronization Task: Source Step
- 3.4Synchronization Task: Target Step
- 3.5Synchronization Task: Data Filters Step
- 3.6Synchronization Task: Field Mapping Step
- 3.7Synchronization Task: Schedule Step
- 3.8Data Transfer Task
- 3.9Activity Monitor
04Cloud Mapping Designer13 topics
- 4.1Cloud Mapping Designer Overview
- 4.2Mapping Designer Terminologies
- 4.3CLAIRE Transformation Recommendations
- 4.4Mapping Data Preview
- 4.5Customizing Mapping Preview
- 4.6Field Rules
- 4.7Best Practices for Creating Mappings
- 4.8Data flow run order
- 4.9Mapping Task
- 4.10Dynamic Schema Change
- 4.11Deploy mapping updates
- 4.12Demo: Creating a simple Mapping
- 4.13Demo: Creating a Mapping Task
05Cloud Mapping Designer: Transformations14 topics
- 5.1Source Transformation
- 5.2Target Transformation
- 5.3Filter Transformation
- 5.4Joiner Transformation
- 5.5Expression Transformation
- 5.6Lookup Transformation
- 5.7Union Transformation
- 5.8Mapplets
- 5.9SQL Transformation
- 5.10Aggregator Transformation
- 5.11Normalizer Transformation
- 5.12Rank Transformation
- 5.13Data Masking Transformation
- 5.14Java Transformation
06Mapping Parameters8 topics
- 6.1Parameterization use cases
- 6.2Adding Parameters to a Mapping
- 6.3Creating parameters
- 6.4Parameter Types
- 6.5Using parameter files
- 6.6In-Out Parameter in Mapplet
- 6.7Parameter File Directory
- 6.8Parameter Best Practices
07Expression Macro and Dynamic Linking2 topics
- 7.1Expression Macro
- 7.2Dynamic Linking
08Replication Task8 topics
- 8.1Replication Task Overview
- 8.2Replication Task Features
- 8.3Replication Task: Source and Target Options
- 8.4Other Replication Task Options
- 8.5Resetting the Target Table
- 8.6Generating Non-Unique Index
- 8.7Replicating Data to a Flat file
- 8.8Creating a replication task
09Masking Task8 topics
- 9.1Masking Task Overview
- 9.2Masking Task: Source and Target Options
- 9.3Data Subset: Row Limits and Data Filters
- 9.4Field Masking Rules
- 9.5Masking Rule Types
- 9.6Refresh Masking Task metadata
- 9.7Reset a Masking Task
- 9.8Masking Best Practices
10Mass Ingestion Task6 topics
- 10.1Mass Ingestion Task Overview
- 10.2Functionalities
- 10.3Configuring a Mass Ingestion Task
- 10.4File Ingestion Task
- 10.5Database Ingestion Task
- 10.6Streaming Ingestion Task
11Taskflows9 topics
- 11.1Taskflow overview
- 11.2Linear Taskflows
- 11.3File Listener Enhancements
- 11.4Taskflow Steps
- 11.5Taskflow Templates
- 11.6Parameters in Taskflow
- 11.7Using REST APIs
- 11.8Invoke a Taskflow through a File Listener
- 11.9Demo: Creating a Linear Taskflow
12Hierarchical Connectivity5 topics
- 12.1Web Service transformation
- 12.2REST V2 Connector
- 12.3Hierarchical Schemas
- 12.4Hierarchy Parser Transformation
- 12.5Hierarchy Builder Transformation
13Intelligent Structure Model7 topics
- 13.1Intelligent Structure Model
- 13.2Intelligent Structure Discovery Process
- 13.3Intelligent Structure Example
- 13.4Refining a Discovered Structure
- 13.5Editing an Intelligent Structure Model
- 13.6Intelligent structure models based on an XSD file
- 13.7Using intelligent structure models in Structure Parser transformation
14Advanced Task Settings and Performance Tuning11 topics
- 14.1Primary Key Chunking
- 14.2Lookup SQL Override
- 14.3Partitions Overview
- 14.4Types of Partitions
- 14.5Partitioning Rules and Guidelines
- 14.6Pushdown optimization overview
- 14.7Types of pushdown optimization
- 14.8Pushdown optimization user-defined parameters
- 14.9Secure agent groups
- 14.10Shared secure agent groups
- 14.11DTM performance properties
15Exception Handling8 topics
- 15.1Types of exceptions
- 15.2User-defined exceptions
- 15.3Non-fatal exceptions
- 15.4Default Field Value Setting
- 15.5Row Error Logging
- 15.6Error handling settings
- 15.7Fatal exceptions
- 15.8Bad files or Reject files
16Administration14 topics
- 16.1Licenses
- 16.2Administrator Service
- 16.3User Roles (System-defined Roles and Custom Roles)
- 16.4Creating a User
- 16.5User Groups
- 16.6User Statistics
- 16.7Permissions
- 16.8Object-Level Permissions
- 16.9Organization Hierarchy
- 16.10Sub-Organization
- 16.11Importing and Exporting Assets
- 16.12Asset Dependency
- 16.13Add-on Bundles
- 16.14Demo: Creating Sub-Organization and Export/Import Assets
17Automating and Monitoring Tasks7 topics
- 17.1Schedules
- 17.2Schedule Repeat Frequency
- 17.3Schedule Blackout Period
- 17.4Schedule Export
- 17.5Monitoring tasks
- 17.6Email Notifications
- 17.7Event Monitoring
18IICS APIs6 topics
- 18.1REST API overview
- 18.2Informatica Cloud REST API
- 18.3REST API Versions
- 18.4Request Header and Request Body configuration
- 18.5Return Lists
- 18.6Demo: RunAJob Utility
Course deliverable
What you will have built
By the end of this course you will have built, scheduled and monitored real Cloud Data Integration jobs in IDMC, from source connections to automated taskflows, the way production Informatica teams run them.
- Runtime and connections
- Secure Agent, Elastic Server, Oracle, flat file and cloud connections
- Quick loads
- Synchronization and Data Transfer tasks with filters, field mapping and schedules
- Transformations
- Cloud Mapping Designer: Joiner, Lookup, Expression, Aggregator, Normalizer, Rank, SQL, Java
- Reusable logic
- Mapplets, mapping parameters, parameter files, expression macros, dynamic linking
- Replication and masking
- Replication tasks, masking tasks with field masking rules and data subsets
- Bulk ingestion
- Mass Ingestion: file, database and streaming ingestion
- Orchestration
- Linear taskflows, file listeners, taskflow parameters and REST triggers
- JSON, XML and APIs
- REST V2 connector, Hierarchy Parser and Builder, Intelligent Structure Model
- Performance and errors
- Partitions, pushdown optimization, PK chunking, row error logging, reject files
- Admin and automation
- Users, groups, custom roles, sub-orgs, asset export and import, schedules, alerts, REST API
Projects you will build
End-to-end CDI pipeline
Pull data from Oracle and flat files, clean and join it in Cloud Mapping Designer with parameters, and load it to a cloud target through a scheduled taskflow.
Masking and replication
Replicate production tables and create a masked, subset copy for testing with field masking rules.
API and JSON integration
Read a REST API with the REST V2 connector, parse nested JSON with Intelligent Structure Model and trigger jobs through the IICS REST API.
Questions about this course
Is IDMC the same as IICS?
Yes. Informatica Intelligent Cloud Services (IICS) is now part of Informatica Intelligent Data Management Cloud (IDMC). This course covers its Cloud Data Integration (CDI) service.
Do I need PowerCenter experience?
No. PowerCenter experience helps you move faster, but we start from the Informatica Cloud basics. Basic SQL is enough to begin.
Will I practise on a real Informatica Cloud org?
Yes. Every module has hands-on practice, with live demos for mappings, taskflows and admin work.
Is there a free demo before I join?
Yes. Book a free demo to see the course plan, ask questions and get batch timings and fees.
Other courses
Same data. Bigger opportunities.
Book the free live demo or WhatsApp us. We will suggest the right path for your background and goal.