IntelliBI Innovations Technologies

Informatica cloud data integration (IICS) + SQL + LINUX

Data integration and ETL (Extract, Transform, Load) processes frequently employ three technologies: Informatica Cloud Data Integration (IICS), SQL, and Linux.
Learning Format

Online/Offline Mode

Total Training Duration

32 Hrs

Hands-on Project Duration

1 Month

Certification

Yes

About Informatica Cloud Certification Training Pune

Data integration and ETL (Extract, Transform, Load) processes frequently employ three technologies: Informatica Cloud Data Integration (IICS), SQL, and Linux.

Informatica Cloud Data Integration (IICS): Also known as Informatica Intelligent Cloud Services, Informatica’s cloud-based data integration platform offers a wide array of tools and services for building and managing data integration workflows in the cloud.

With IICS developers can connect to various data sources such as on-premises databases, cloud databases, files, applications among others. It comes with pre-built connectors for salesforce.com; Amazon S3; Microsoft Azure among other popular systems. Developers can design data integration tasks, apply transformations, create mappings and schedule/monitor data integration jobs using IICS’ intuitive graphical user interface(GUI).

Apart from these capabilities; IICS also provides features around real-time integration; synchronization of data between different systems; ensuring quality & accuracy in complex data integration scenarios etcetera.

Enroll in Our Informatica Course in Pune now.

Duration of Training  :  32 hrs

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

Hands on Project minimum 1 month duration.

Informatica Cloud Data Integration Training & Certification in Pune

Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry

Realtime Projects, Scenarios & Assignments

COURSE CONTENT :

1. Informatica Cloud Overview
  • Informatica Cloud
  • Object Synchronization
  • Process Synchronization
  • Data Replication
  • Informatica Cloud Applications
  • Informatica Cloud – Key Terms
2. Informatica Cloud Secure Agent and Architecture
  • Informatica Cloud Architecture
  • Informatica Cloud Secure Agent
  • Informatica Secure Agent Architecture
  • Running Agent as Local/Network User
3. Creating Connections
  • Connection Properties
  • Connection types
  • Configuring a connection
  • Creating a Salesforce.com Connection
  • Creating a Flat File Connection
4. Data Synchronization Application
  • Data Synchronization application
  • Data Synchronization Operations
  • Field Information
5. Data Replication Application
  • Data Replication App Overview
  • Data Replication Features and Benefits
  • Data Replication Source and Target Options
  • Other Data Replication Task Options
  • Resetting the Target Table
6. Cloud Mapping Designer – Part I
  • 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
7. Cloud Mapping Designer – Part II
  • Joiner, Expression, and Lookup transformations
  • Field Rules: Renaming Fields, Selection Criteria
  • Creating a Mapping using the Lookup and Expression Transformations
8. Cloud Mapping Designer
  • Aggregator Transformation Overview
  • Aggregator Transformation – Source and Target
  • Normalizer Transformation
  • Normalized Fields
  • Lookup Transformation
  • Unconnected Lookup
9. Qualifying and Transforming Source Data
  • Data Filter
  • Simple and Advanced Data Filter
  • System Variables in a Data Filter
  • Incremental Processing
  • Field Expression
10. Mapping Task and Mapping Parameters
  • 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
11. Advanced Task Options
  • Pre and Post-Processing Commands
  • Operating System Commands
  • Parameter File
  • Setting Up a Parameter File
12. Automating and Monitoring Tasks
  • Schedules
  • Schedule Repeat Frequency
  • Repeat Frequency Options
  • Schedule Blackout Period
  • Email Notifications
13. Linear Taskflow
  • Schedules
  • Schedule Repeat Frequency
  • Repeat Frequency Options
  • Schedule Blackout Period
  • Email Notifications
14. Template Taskflows
  • What is a Taskflow?
  • Task flow Steps
  • Task flow Templates
15. Advanced Properties Settings
  • SQL Overrides in Lookups
  • Lookup SQL Override Attributes
  • Pre and Post SQL commands
16. Performance and Scalability
  • Partitions
  • Types of Partitioning
  • Partitioning Rules and Guidelines
  • Secure Agent Groups with Multiple Agents
17. Advanced Parameterization and REST Utilization
  • Parameterization
  • Use case and solution
  • Advanced Parameterization
  • Parameterization technique in a mapping
18. Advanced Administration
  • Custom Roles
  • Asset Level Permissions
  • Rules and Guidelines for Permissions
  • Project or Folder Access Using User Groups
  • Administrative settings for the organization
19. Administration
  • User Roles
  • User Groups
  • Object-level permissions
  • Organization hierarchy
  • Migrating Assets

IntelliBI Innovations is a trusted training center in administrative and software development courses from past 7+ years. IntelliBi offers strategic preparing ways for the certification abilities to upgrade yourself in a better way. Your success is our aim. We center around offering you the best classrooms/ virtual experience alongside the best client assistance. our certification from our technology partners also extends to our facilities. Our devotion to your prosperity is reflected in our agreeable staff, eager teachers and dynamic homeroom setting and hardware.

Apply Now

Request a callback

× I Want Details To Whatsapp