Cloud Data Integration for Developers Advanced Training

ExistBI is an Informatica Partner

Course Description

This 4-day Advanced Informatica Cloud Data Integration class helps students explore the advanced functionalities of the IICS integration software, such as; using expression macros, dynamic mapping task, file listeners, handling dynamic schema change and errors, performing structure discovery, SQL ELT optimization, partitioning, and using advanced transformation in cloud mapping designers.

Students can take the Public instructor-led online class every 2-weeks or larger teams can set-up a private group training.

All delegates receive extensive course materials (student guides and labs) and access to a licensed environment for hands-on labs. For our live instructor-led online training, we use WebEx meetings for all interaction: to view the trainer screen, audio communication, ask questions and lab support. You can also email the trainer or set up 1-1 meetings for additional support.

Course Summary

Next Public Course Dates

UK & Europe:

  • 13 - 16 January 2026
  • 27 - 30 January 2026
  • 10 - 13 February 2026

US & Canada:

  • 6 - 9 January 2026
  • 20 - 23 January 2026
  • 3 - 6 February 2026

More dates

Prerequisites
Duration
  • 4 Days
  • 60% theoretical, 40% practical
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite
Audience
  • Developer

Course Modules

IICS Transformations

  • Normalizer Transformation
  • SQL Transformation
  • Transaction Control Transformation
  • Sequence Generator Transformation
  • Velocity Transformation
  • Schema Change Handling
  • Lab: Using Transaction Control Transformation in a Mapping
  • Lab: Using Normalizer Transformation in a Mapping to Transform Consolidated Data
  • Lab: Create Expression Macro in a Mapping
  • Lab: Using Vertical Macro in a Mapping
  • Lab: Using Horizontal Macro in a Mapping
  • Lab: Create Dynamic Schema Change Handling

Testimonials

“Great Tableau Course.  Lots of information packed into short period.”

★★★★★

- Matt, Data Analyst, Fortune Brands

“Our training was great!  The trainer really knew a lot about Fabric and Power BI!!”

★★★★★

- Patti Patterson, IT Admin, Kensing Solutions

“Trainer was amazing. I was worried about staying engaged for 4 days, but the pace and explanation was exceptional! Would love to know what other training he provides.”

★★★★★

- Natalie Chronister, Project Administrator III, Carnegie Mellon University Software Engineering Institute

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line