Staffwing

8 jobs near Columbus, OH

Company Description 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 ...

Company Description 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 ...

Company Description One of our direct client, a BigData & Data Science major is implementing BigData solution at end client site and is looking for a strong Postgres DBA to implement Postgres in ...

Company Description One of our direct client, a BigData & Data Science major is looking for a Lead Data Scientist to join their team of Data Scientists. This is a permanent position with client.

Company Description One of our direct client, a BigData & Data Science major is looking for a Lead Data Scientist to join their team of Data Scientists. This is a permanent position with client.

Company Description One of our direct client, a BigData & Data Science major is implementing BigData solution at end client site and is looking for a strong Postgres DBA to implement Postgres in ...

Pentaho Data Integrator

Staffwing Inc

Columbus, OH • On-site

Contractor

Posted 11 days ago


Job description

Company Description

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. 

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 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.


Qualifications

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.


Additional Information

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