Pentaho Data Integrator

StaffwingInc

Columbus, OH, United States contract

Posted: May 5, 2015

Required Skills

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.

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

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.

Interested in this position?