Pentaho-ETL/BI Consultant

Jobsbridge; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

A recruitment company is seeking a seasoned BI-ETL professional with 8+ years of experience, particularly in Pentaho Data Integration. The role involves designing and troubleshooting data integration jobs and collaborating with various teams for process improvements. Expert knowledge of PL/SQL and strong customer management skills are essential. The company values confidentiality and adheres to EEO guidelines. This position is based in New York City, offering a dynamic environment for skilled individuals.

Qualifications

• 8+ years of BI-ETL experience.
• Strong expertise in writing complex SQL queries.
• Expert in design and troubleshooting Pentaho data integration jobs.
• Monitor history loads and data reconciliation with business stakeholders.
• Strong customer management, documentation and team coordination.

Responsibilities

• Ownership of Pentaho PDI Job designs and process improvements.
• Monitoring History data and data reconciliation.
• Controlling Configuration Management for Pentaho PDI code.
• Write complex SQL queries and PL/SQL routines.
• Coordinate with IT and business stakeholders for validations.

Skills

BI-ETL experience

ETL using Pentaho Data Integration

XML processing

PL/SQL scripting

Hadoop integration

Java scripts

CSS

HTML

Unix shell scripts

Performance tuning

Tools

Pentaho Data Integration

Cloudera Hadoop

Hadoop ecosystem

Job description

We recruit for product development teams as well as IT teams; we understand the difference in skill sets and personnel needed for both back-end and front-end. We have the resources and access to a global network of talent across various technologies and industries to provide your company with the right candidates you need and just when you need them

Job Description

• 8+ years of BI-ETL experience, 3+ years of ETL using Pentaho Data Integration (Kettle and Spoon)
• Pentaho integration with Cloudera Hadoop added advantage
• XML processing (SAX and DOM) is a Plus
• Having good BI Implementation experience by design
• Hadoop + Pentaho: Candidate having integration experience in Hadoop & Pentaho is a plus
• Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps and hadoop-hdfs-hive based data transformations.
• Strong expertise in writing PL/SQL scripts, functions, stored procedures, complex SQL queries, PL/SQL analytical functions, hierarchical, parent-child queries.
• Expert in design and development of jobs to capture CDC(Change Data Capture) from source systems.
• Expertise in Java scripts, CSS, HTML & Unix shell scripts to support custom functions or steps is a plus
• Expert in designing and setting up exception handling and performance tuning of jobs.

Qualifications

• Ownership of all the deliverables such as Pentaho PDI Job designs, process improvements and consolidation exercises
• Working with dependent teams such as DBA, Admin etc for tasks that require other team’s assistance
• Controlling Configuration Management to take care of multiple Pentaho PDI code versions and their management
• Monitoring History data, Initial Loadings and data reconciliation by working closely with Business users/stakeholders for validations
• Strong Customer Mgt/Documentation/time/team management and organizational skills

Additional Information

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