Multi platform, multi database, data modeling and profiling tool with support for PostgreSQL, Oracle, MS SQL Server etc.
It has features geared specifically to the data warehouse architect.
The Community edition is free.
Ranked in these QuestionsQuestion Ranking
Can convert databases and copy the data from tables.
Pro OLAP schema modeling
Cubes, Measures, Dimensions, Hierarchies & Levels.