The short answer
PowerCenter is Informatica's on premises ETL tool. IICS, now sold as part of Informatica IDMC, is its cloud platform, and its Cloud Data Integration (CDI) service is the cloud successor of PowerCenter. If you are starting today, learn IDMC Cloud Data Integration. If your company still runs PowerCenter, learn both, because most new Informatica projects are migrations from PowerCenter to IDMC.
In this article (6 sections)
01What is Informatica PowerCenter?
PowerCenter is the ETL tool many banks, telecom companies, retailers and IT services firms have used for years to move and transform data into data warehouses. It is installed on servers that the company runs and maintains.
A PowerCenter setup has a domain, a repository (a database that stores all the metadata) and an Integration Service that runs the jobs. Developers work in desktop client tools:
- Designer, to build sources, targets and mappings
- Workflow Manager, to create sessions and workflows
- Workflow Monitor, to watch runs and read session logs
- Repository Manager, to manage folders, users and deployments
The basic flow is: a mapping holds the transformation logic, a session runs one mapping, and a workflow runs sessions in order.
02What is IICS, and how does it relate to IDMC?
IICS (Informatica Intelligent Cloud Services) is Informatica's cloud platform. Informatica now sells it under the name IDMC (Intelligent Data Management Cloud). People still say IICS in job posts and interviews, and they usually mean the same thing.
IDMC runs as a set of services in the browser. The one that replaces PowerCenter is Cloud Data Integration (CDI). Others include Cloud Application Integration, Mass Ingestion and Data Quality.
You design jobs in the browser in Cloud Mapping Designer. The jobs run on a Secure Agent, a small runtime that you install on a server or cloud machine close to your data. Informatica's cloud stores the design and schedules; the Secure Agent does the data processing.
The flow is similar to PowerCenter: a mapping holds the logic, a mapping task runs it with its connections and parameters, and a taskflow runs tasks in order with conditions.
03IICS vs PowerCenter: side by side
| PowerCenter | IICS / IDMC Cloud Data Integration | |
|---|---|---|
| Where it runs | Company servers (on premises or self managed cloud) | Informatica cloud for design and control, Secure Agent for processing |
| Where you build | Desktop client tools | Browser (Cloud Mapping Designer) |
| Main objects | Mapping, session, workflow | Mapping, mapping task, taskflow |
| Upgrades | Your team installs and patches | Informatica updates the service; you update agents |
| Connectivity | Mostly databases and files | Databases, files, cloud warehouses, SaaS apps and REST APIs |
| Cost model | Licence for the installation | Consumption based, measured in IPUs (Informatica Processing Units) |
| Typical new work today | Support and maintenance | New pipelines and migrations from PowerCenter |
Swipe sideways to see the full table
04Is PowerCenter going away?
Not overnight, but the direction is clear. Informatica moved PowerCenter 10.5 out of standard support on 31 March 2026, which leaves extended support as the paid option for companies that stay. Informatica positions IDMC as the path forward, so a lot of current Informatica work is moving existing PowerCenter jobs to the cloud.
That is good news for PowerCenter developers. Migration projects need people who understand the old jobs and can rebuild, test and tune them in IDMC.
05How PowerCenter skills carry over
Most of what you know transfers. The transformation logic is the same family: Expression, Filter, Joiner, Lookup, Router, Aggregator, Sorter, Normalizer, Union and Sequence Generator all exist in CDI. Slowly changing dimensions, parameters, partitioning and pushdown optimization work on the same ideas.
What is new in IDMC:
- Secure Agent setup, runtime environments and connections
- Mapping tasks and taskflows instead of sessions and workflows
- Mass Ingestion for moving many tables or files at once
- Intelligent Structure Model for parsing JSON and XML
- REST V2 connector and the IICS REST APIs for automation
- Watching IPU usage, because every run has a cost
- Admin work in the browser: users, groups, roles, sub organizations and asset export and import
06Which one should you learn?
| Your situation | What to learn |
|---|---|
| Fresher with basic SQL | IDMC Cloud Data Integration directly. You do not need PowerCenter first. |
| PowerCenter developer | IDMC CDI, focusing on the differences: Secure Agent, tasks, taskflows, cloud connectors, IPUs. |
| Your company still runs PowerCenter | Both. PowerCenter for current support work, IDMC for the migration projects coming next. |
| SQL or Oracle developer moving into ETL | IDMC CDI. Your SQL is the most useful skill you already have. |
Swipe sideways to see the full table
In short: PowerCenter knowledge is still valuable for support and migration work, but IDMC Cloud Data Integration is where new Informatica jobs are heading.