Pentaho-ETL/BI Consultant

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.

• 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

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