ideaVat LLC→

Pentaho-ETL/BI Consultant at ideaVat LLC in New York, NY

Mid LevelOn-siteContractNew York, NY

Skills

pentaho data integrationkettlespoonhadoophdfshivepl/sqlsqlcdcdata integrationbi implementationcustomer managementdocumentationteam managementorganizational skillscommunicationcloudera hadoopxml processingsaxdomjavacsshtmlunix shell scripts

Job Description

Company 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

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.