Introducing G2.ai, the future of software buying.Try now
Compare Google Cloud BigQuery and Informatica PowerCenter 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Kpow for Apache Kafka®
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
ILUM
Visit Website
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Alteryx
Visit Website
At a Glance
Market Segments
Enterprise (38.1% of reviews)
Enterprise (78.2% of reviews)
Entry-Level Pricing
Free
No pricing available
Google Cloud BigQuery
Star Rating
(1,201)4.5 out of 5
Market Segments
Enterprise (38.1% of reviews)
Pros & Cons
Entry-Level Pricing
Free
Free Trial is available
Browse all 5 pricing plansInformatica PowerCenter
Star Rating
(85)4.4 out of 5
Market Segments
Enterprise (78.2% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Informatica PowerCenterSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Informatica PowerCenter excels in data transformation capabilities, with a score of 9.1, making it a preferred choice for complex data workflows. In contrast, Google Cloud BigQuery also performs well in this area but has a slightly lower score of 9.0.
- Reviewers mention that Google Cloud BigQuery shines in scalability, achieving a score of 9.3, which is particularly beneficial for organizations expecting rapid data growth. Informatica PowerCenter, while solid, scores 8.7 in this category, indicating it may not scale as efficiently for larger datasets.
- G2 users highlight the ease of setup as a significant advantage for Google Cloud BigQuery, scoring 8.6 compared to Informatica PowerCenter's 7.4. This suggests that users find BigQuery more user-friendly when getting started.
- Reviewers say that Informatica PowerCenter offers robust data security features, scoring 9.2, which is crucial for enterprises handling sensitive information. Google Cloud BigQuery, while also secure, scores slightly lower at 9.1, indicating a minor difference in perceived security strength.
- Users on G2 report that the reporting capabilities of Informatica PowerCenter are strong, with a score of 8.9, particularly for detailed analytics. Google Cloud BigQuery, however, has a score of 8.6, suggesting that while it is effective, it may not provide the same depth of reporting features.
- Reviewers mention that both products have strong data integration capabilities, but Informatica PowerCenter scores 9.0, indicating a slight edge in integrating various data sources compared to Google Cloud BigQuery, which also performs well but scores lower in this area.
Pricing
Entry-Level Pricing
Google Cloud BigQuery
Free
Free
New customers get $300 in free Google Cloud credits to spend on BigQuery with free trial sign-up.
- 10 GB storage
- Up to 1 TB queries per month
Informatica PowerCenter
No pricing availableFree Trial
Google Cloud BigQuery
Free Trial is available
Informatica PowerCenter
No trial information availableRatings
Meets Requirements
8.8
612
8.8
67
Ease of Use
8.7
626
8.1
67
Ease of Setup
8.8
401
7.4
35
Ease of Admin
8.5
224
7.9
33
Quality of Support
8.4
564
8.5
63
Has the product been a good partner in doing business?
8.7
217
8.1
32
Product Direction (% positive)
9.2
600
9.1
62
Features by Category
Administration
Not enough data
9.0
12
Not enough data
8.2
12
Not enough data
9.2
12
Federation
Not enough data
8.9
12
Not enough data
8.5
11
Not enough data
8.5
10
Not enough data
8.3
11
Transformation
Not enough data
9.2
12
Not enough data
8.8
12
Not enough data
8.8
12
Management
8.6
123
8.9
19
8.3
121
8.6
15
Functionality
9.0
121
9.2
19
9.1
124
9.1
19
9.0
124
9.2
19
8.9
123
8.5
19
9.4
124
8.7
17
Functionality
Not enough data
8.8
10
Not enough data
9.1
13
Not enough data
9.0
13
Not enough data
8.8
13
Not enough data
8.8
12
Not enough data
8.9
12
Not enough data
8.9
11
Not enough data
8.5
11
Data Management
8.9
223
|
Verified
Not enough data
8.3
214
|
Verified
Not enough data
8.9
219
|
Verified
Not enough data
8.6
215
|
Verified
Not enough data
8.3
204
|
Verified
Not enough data
8.7
205
|
Verified
Not enough data
Integration
8.6
204
|
Verified
Not enough data
8.6
216
|
Verified
Not enough data
8.6
204
|
Verified
Not enough data
Deployment
7.8
190
|
Verified
Not enough data
9.1
215
|
Verified
Not enough data
Performance
9.1
220
|
Verified
Not enough data
Security
8.7
211
|
Verified
Not enough data
9.2
217
|
Verified
Not enough data
Generative AI
7.7
132
Not enough data
7.9
129
Not enough data
Storage
9.1
70
Not enough data
8.8
70
Not enough data
Availability
8.4
62
Not enough data
8.5
66
Not enough data
8.6
68
Not enough data
Performance
8.5
65
Not enough data
Security
8.7
70
Not enough data
8.8
69
Not enough data
8.4
69
Not enough data
8.7
65
Not enough data
Support
8.7
66
Not enough data
8.9
66
Not enough data
Centralized computation
9.1
27
Not enough data
Localized computation
8.5
28
Not enough data
Statistical Tool
8.7
78
Not enough data
9.0
79
Not enough data
8.8
79
Not enough data
Data Analysis
9.3
78
Not enough data
9.1
79
Not enough data
Decision Making
8.8
80
Not enough data
8.7
78
Not enough data
8.7
80
Not enough data
8.7
78
Not enough data
Generative AI
7.5
51
Not enough data
7.8
51
Not enough data
Marketing Operations
8.8
66
Not enough data
9.2
64
Not enough data
8.9
65
Not enough data
9.4
66
Not enough data
8.8
63
Not enough data
8.5
63
Not enough data
Campaign Activity
9.1
68
Not enough data
9.5
67
Not enough data
8.7
64
Not enough data
9.2
62
Not enough data
8.9
63
Not enough data
9.1
65
Not enough data
Agentic AI - Marketing Analytics
8.8
16
Not enough data
9.6
16
Not enough data
8.3
16
Not enough data
Database
8.8
178
Not enough data
8.9
176
Not enough data
8.8
170
Not enough data
Integrations
8.4
139
Not enough data
8.6
136
Not enough data
Platform
8.9
153
Not enough data
8.9
168
Not enough data
8.6
136
Not enough data
Processing
9.3
170
Not enough data
9.1
164
Not enough data
Data Transformation
8.8
288
Not enough data
9.3
295
Not enough data
Connectivity
8.1
256
Not enough data
8.2
254
Not enough data
8.7
283
Not enough data
8.8
274
Not enough data
Operations
8.5
283
Not enough data
8.7
282
Not enough data
8.3
260
Not enough data
8.4
267
Not enough data
8.5
259
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Google Cloud BigQuery and Informatica PowerCenter are categorized as ETL Tools
Unique Categories
Google Cloud BigQuery is categorized as Columnar Databases, Big Data Integration Platforms, Big Data Processing and Distribution, Big Data Analytics, Marketing Analytics, Predictive Analytics, Data Warehouse, and Data Clean Room
Informatica PowerCenter is categorized as Data Virtualization, On-Premise Data Integration, and Data Mapping
Reviews
Reviewers' Company Size
Google Cloud BigQuery
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Informatica PowerCenter
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
16.2%
Computer Software
13.5%
Retail
7.1%
Financial Services
6.5%
Marketing and Advertising
5.1%
Other
51.7%
Information Technology and Services
35.9%
Insurance
7.7%
Financial Services
6.4%
Banking
6.4%
Computer Software
5.1%
Other
38.5%
Alternatives
Discussions
Is Big Query free?
3 Comments
BG
noRead more
Is BigQuery part of Google Cloud Platform?
2 Comments
AY
Yes, Bigquery is a GCP product and a serveless data wharehouse.Read more
How BQ legacy SQl is different form the standard SQL?
1 Comment
OD
Legacy SQL is a non-standard SQL only used by BigQuery. Standard SQL is compliant with the SQL 2011.
Google recommends using Standard SQL and looking at the...Read more
Informatica PowerCenter has no discussions with answers
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
