Pentaho Data Integrator

One of our direct client, a BigData & Data Science major is looking for a strong Pentaho Data Integrator. This is a permanent position with client and would be a 6 months contract to hire. 

• 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 process to move the data from the source system to the target system.  

o This includes data cleaning and value mapping

• Basic Performance turning of queries and tables.

• Documentation of source schemas to be used by other Data Analysts.

• Quality assurance validation of the transformed data output, often in XML format.

• Strong SQL and Database skills

o Queries, Inserts, Updates, Indexes, Stored Procedures, Triggers, and performance tuning

• Experience with an ETL tool such as Pentaho Data Integration or SQL Server Integration Services   

• Experience working with multiple relational databases

o Capable of quickly translating database knowledge from one vendor to another

o Worked with a variety of vendor tools and competent with a variety of tool sets.  

• Competence in reading and reviewing XML output; XML Schema experience is a plus.

• Experience writing basic scripts in any scripting language

• Strong documentation, organization and communication skills

o Expected to communicate with client(s) and actively work with other members

• Familiarity with the domain of law enforcement and related systems is a big plus

• B.S. in Computer Science or similar degree is required

• U.S. Citizenship is highly desired. Candidate will need to have one or more background checks performed as directed by the end client.

All your information will be kept confidential according to EEO guidelines.