

Informatica PowerCenter and Sigma compete in the data integration and business intelligence domain. Sigma holds the upper hand with its user-friendly interface and cloud integration solutions, ideal for users requiring rapid insights without technical expertise.
Features: Informatica PowerCenter is known for its scalability, stability, and advanced transformation capabilities. It efficiently handles large volumes of data and provides extensive transformation functions. Sigma features a spreadsheet-like interface that facilitates real-time collaboration, integrates seamlessly with cloud data warehouses, and allows for straightforward ad hoc data analysis.
Room for Improvement: Informatica PowerCenter could improve by reducing costs, enhancing cloud features, and better integrating modern data formats and APIs. Sigma can improve UI responsiveness for larger datasets, expand visualization options, and advance error handling and debugging capabilities.
Ease of Deployment and Customer Service: Informatica PowerCenter is mostly on-premises, requiring infrastructure but offering extensive enterprise support, while Sigma’s cloud-based deployment provides ease of setup sans infrastructure hassles. Informatica's customer service is commendable but can depend on third-party distributors. Sigma has moderate support with potential for enhanced user guidance.
Pricing and ROI: Informatica PowerCenter has a high cost, fitting for large enterprises but steep for smaller companies. It offers a strong ROI when efficiency and labor reduction are considered. Sigma provides moderate pricing with flexible cloud licensing, though costly report creator licenses might restrict user access.
It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.
The investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.
The return on investment is very good, as I previously mentioned, because the development team has been reduced to half, and it has saved us around one hour per day since we switched to Informatica PowerCenter.
It's essential for everything data-related within our company.
I have seen a return on investment with Sigma; we already said that it saves about a quarter, it gets me to answers about 25% faster.
I have definitely seen a return on investment through time saving because once the dashboards are built, they are built.
The documentation is thorough, and anyone with minimal knowledge of ETL can easily understand it and work through errors.
I like the technical support provided by Informatica.
I have occasionally needed to communicate with the technical support of Informatica PowerCenter, especially when raising cases for complex mappings and performance optimization to identify bottlenecks in transformations.
Their support I really think is a 10 out of 10.
The support staff are all professional users of the product itself and they are available almost 24/7 and helped me to come up with solutions to all of the problems that I had.
As Sigma is a cloud platform, you do not need to do all that maintenance work.
In the cloud, scaling up and down becomes easy when working with cloud providers.
The scalability of Informatica PowerCenter is tremendous because we can install it on any of our employees' systems, and it handles each and every task very swiftly.
We can easily scale the memory and also the workflows.
Sigma seemed to scale just fine with our large data sets and could handle anything we threw at it.
Permissions are easily set, so you only get to see what you need to see and you can share what needs to be shared.
We are getting 100% uptime every day.
Informatica PowerCenter is stable and can scale well.
The product is very stable with very few issues encountered in production.
We did not face typical errors during our project with Sigma.
With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
Informatica Cloud and its support becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing.
The main improvement needed is in data modeling capabilities.
Sigma lacks a versioning feature to track changes.
It would be great if there was a way for me to create reports without relying on a data analyst.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
We haven't paid for it; our client had paid for this tool.
The pricing of Sigma is a concern, as it restricts our ability to provide more users with report-creating capabilities due to the high cost of admin or report creator licenses.
The system supports real-time integration, which is essential for many of my tasks.
Informatica monitors can be used to monitor the jobs that we run, and if there is any kind of failure, we can diagnose it right away.
Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload.
The use of Sigma in decision-making, presentations to customers, and reporting to investors showcases its value in handling data-related tasks.
Sigma has positively affected my organization by saving us time in accessing information, which ultimately gets us to complete projects faster.
Sigma has positively impacted my organization because I think it has been a huge impact, and we use it for all our reporting and our dashboards for tracking.
| Product | Mindshare (%) |
|---|---|
| Informatica PowerCenter | 1.2% |
| Sigma | 1.7% |
| Other | 97.1% |

| Company Size | Count |
|---|---|
| Small Business | 14 |
| Midsize Enterprise | 11 |
| Large Enterprise | 76 |
| Company Size | Count |
|---|---|
| Small Business | 7 |
| Midsize Enterprise | 3 |
| Large Enterprise | 2 |
Informatica PowerCenter is known for its robust data integration, scalability, and user-friendly interfaces. It simplifies data processing with real-time capabilities, handling large datasets efficiently. Its adaptability with diverse sources makes it suitable for complex data environments.
Informatica PowerCenter offers extensive transformation options with features like flow designer, mapping, and error handling, enhancing development efficiency. Its GUI interface allows seamless integration across different platforms, making it suitable for managing extensive datasets. Traceability and support cater to evolving data requirements, while adaptability with multiple sources aids in driving strategic data outputs. Some areas for improvement include a more robust cloud strategy, better documentation, and improved API integrations. Enhanced automation and setup processes could further refine the experience.
What are the key features of Informatica PowerCenter?Informatica PowerCenter plays a vital role in data integration and ETL processes for building data warehouses. Industries like banking, insurance, and healthcare utilize it for extracting, transforming, and loading data into target systems, supporting analytics, reporting, and compliance. Companies often transition to cloud environments for enhanced scalability and efficiency.
Sigma enhances data tasks with an Excel-like interface, encouraging collaboration and non-technical user engagement. Its strengths include handling vast datasets and facilitating real-time data exploration, appealing to industries aiming for data-driven decision-making.
Sigma stands out with its capabilities for real-time collaboration and ease of use due to its Excel-inspired interface. It supports engagement with large datasets and prioritizes strong data governance. Key features include live queries on cloud databases and seamless integration with Snowflake. Its AI capabilities and self-service access help users perform detailed reporting and pivot table creation from extensive datasets, significantly affecting organizational efficiency and decision-making processes.
What are Sigma's most important features?Sigma is predominantly used for creating dashboards, reporting, and data visualization. It assists in real-time data exploration and ad hoc analysis, connecting seamlessly with Snowflake for consistent data views. Sales teams use it for performance comparison dashboards, while marketing teams apply it for data migration assessments. Organizations leverage its comprehensive reporting and analytics for informed decision-making.
We monitor all Data Visualization reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.