Pentaho Data Integrator

Columbus, OH · 139 months ago

About the job

Job Description • Analysis of database tables as they relate to a data warehouse model and determination of likely intra and inter-database relationships. • Assess the quality and consistency of data stored in a source database and develop recommendations for data cleansing based upon data warehouse business rules. • Prepare a Data Quality and Schema Analysis Report which documents findings regarding the database analysis work performed. ER diagramming will be a part of this activity. • Create mappings between the fields in the source and target systems as well as identifying relationships within a source (implicit foreign keys, lookup tables, etc.). • Leverage mappings to create an ETL...