Pentaho Data Integrator

Staffwing Inc; Columbus (OH); On-site; USD 80,000 - 100,000; Full time

Job summary

Staffwing Inc is seeking a Pentaho Data Integrator in Columbus, Ohio, for a long-term role. The position involves analyzing database tables, creating ETL mappings, and ensuring data quality through documentation and validation practices.

The ideal candidate should possess strong SQL skills, familiarity with ETL tools like Pentaho, and a background in law enforcement systems is a plus. A B.S. in Computer Science or a similar degree is required.

This role offers an opportunity for direct client engagement and professional growth.

Qualifications

• Strong SQL skills for database operations including queries, inserts, updates.
• Experience with ETL tools for data integration tasks.
• Competence in reading and reviewing XML output.

Responsibilities

• Analyze database tables related to data warehouse models.
• Create mappings for ETL processes and clean data.
• Document findings and ensure quality assurance of data.

Skills

SQL and Database skills

Experience with ETL tools

Scripting language knowledge

Documentation and communication skills

Understanding of XML outputs

Education

B.S. in Computer Science or similar degree

Tools

Pentaho Data Integration

SQL Server Integration Services

Job 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.
• This includes data cleaning and value mapping.
• Basic performance tuning 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: 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; capable of quickly translating database knowledge from one vendor to another.
• 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; expected to communicate with clients 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.