Informatica PowerCenter Reviews & Product Details

I like Informatica PowerCenter's easy-to-use interface and how it reduces the need for manual coding, like writing Python or SQL queries. It automates and manages complete ETL processes and is built to handle huge volumes of data with features like data partitioning and pushdown optimization. It supports a wide array of data sources, including relational databases and cloud services. I also appreciate its built-in features for data validation, cleansing, profiling, and mapping. Review collected by and hosted on G2.com.

Informatica PowerCenter was built for on-premise environments, meaning it lacks native support for dynamic cloud-based infrastructure. This results in limitations when integrating with modern cloud data warehouses and services. Scaling for large and fluctuating workloads often requires hardware upgrades and resource management, like adding physical servers, which is resource-intensive and complex compared to the automatic elastic scaling of cloud-native platforms. The platform can struggle with seamless integration across complex hybrid and multi-cloud environments. PowerCenter involves significant upfront licensing costs, ongoing maintenance expenses, and infrastructure management costs. It requires substantial server resources, CPU, memory, disk space, and dedicated IT teams for maintenance, updates, and performance tuning. It also lacks built-in AI-powered automation for tools like data pipeline development or data discovery. Review collected by and hosted on G2.com.

I like that Informatica PowerCenter provides a drag and drop feature. We don't have to manually write codes or anything. We can mention SQL, override SQL queries, but most things can be done by drag and drop only. This makes it easy to understand how things are happening and helps visualize how the pipeline is working. Review collected by and hosted on G2.com.

The thing I find can be improved is the ease of accessing the parameters which are defined on the workflow level. Like, we have to go to the menu and then in the menu, we have another option. There, we will find the parameters. That thing I find complicated. Review collected by and hosted on G2.com.

I use Informatica PowerCenter for data integration and appreciate its ability to integrate data from multiple sources. I also value its developer and monitor features, which are particularly useful for my needs. Review collected by and hosted on G2.com.

I find the integration with Spark or Python lacking. The initial setup was moderate to difficult, which was challenging. Review collected by and hosted on G2.com.

Informatica was a great tool when we were working with on premise tools when cloud tools were not there but with cloud we have multiple etl tool optuons Review collected by and hosted on G2.com.

Ability to do let bcoz now everyone is moving towards elt Review collected by and hosted on G2.com.

Informatica PowerCenter is a widely recognized data integration tool, known for its robustness and scalability in managing ETL (Extract, Transform, Load) processes. Supports a broad range of data sources, including relational databases, flat files, cloud services, and big data platforms. Supports complex transformations with an intuitive, drag-and-drop interface. User friendly and easy to use. Review collected by and hosted on G2.com.

Non-technical users or newcomers to ETL processes may struggle to use the tool effectively without extensive training.his can be a barrier for small to medium-sized businesses with limited budgets. Users may need to supplement PowerCenter with additional tools for modern data engineering needs. Review collected by and hosted on G2.com.

1.Data integration

2.Creating Mapping in power center designer

3.Create workflows in workflow manager

4.Monitor the workflow in power center monitor.

Informatica is a toll that provides an environment which allows loading of data into centralized location.

It allows the extraction of data from multiple sources, transform of data according to business requirements and load the data into file and relational target. Review collected by and hosted on G2.com.

Required more technical and tool knowledge to implement.

As the tool is not open source, required cash for getting licence.

Debugging might be difficult.

The tool has a steep learning curve and it may take some time for users to become proficient in its use. Review collected by and hosted on G2.com.

Scalability,Connectivity,Transformation Capabilities,Workflow Management,Metadata Repository,Performance Optimization Review collected by and hosted on G2.com.

Complexity,Cost,Resource Intensive,Steep Learning Curve,Dependency on IT,Vendor Lock-in Review collected by and hosted on G2.com.

Informatica powercenter has been a classic , it has been in the industry for around 30 years and still is very relavant to the point , provide every possible connector and provides best mapping tools. Review collected by and hosted on G2.com.

the UI looks very old and sometimes it is very difficult to handle big big mappings as it needs lot of experience Review collected by and hosted on G2.com.

Ease of Use, Great Documention explaining exact feature, Great support.

easy to Implemnet buisness logic via transformation offered. Review collected by and hosted on G2.com.

Debugger need to be enchanced further, Tools becomes slow if you are working across mutiple repository. Review collected by and hosted on G2.com.

It is a great ETL tool that can ingest data from multiple sources, perform transformations, and then load it to target systems with drag-and-drop options. Different tools are available for monitoring and repository management and workflow designing. Review collected by and hosted on G2.com.

Sometimes it stops responding, and the user interface is not that modern. It isn't easy to work using a touchpad for dragging and dropping, and we need a mouse to work efficiently. Review collected by and hosted on G2.com.