Pentaho ETL & Data Integration Specialist

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

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.