Pentaho Data Integration - Transform/Job

The objective of the project is to implement Pentaho Data Integration solution in a pre-existing pentaho environment. Data needs to be extracted from a PostgreSQL database (SQL will be provided) and transform the data to a fixed length text file (format will be provided). Once the transformation is complete a job needs to be created to FTP the file and log all actions to an external file.

2) Environment

Operating System: Linux Enterprise Edition

Database: PostgreSQL 8.2

Report Server: Pentaho

3) Other

All user access to the preproduction and production environment will be provided to the developer. All documents/requirements will be provided initally and as needed during the project.