Pentaho-ETL/BI Consultant

<p><b><span></span></b></p><p><b><b><span>Job Description: <br />• 8+ years of BI-ETL experience, 3+ years of ETL using Pentaho Data Integration (Kettle and Spoon)<br />• Pentaho integration with Cloudera Hadoop added advantage<br />• XML processing (SAX and DOM) is a Plus<br />• Having good BI Implementation experience by design<br />• Hadoop + Pentaho : Candidate having integration experience in Hadoop &amp; Pentaho is a plus<br />• Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps and hadoop-hdfs-hive based data transformations.<br />• Strong expertise in writing PL/SQL scripts, functions, stored procedures, complex SQL queries, PL/SQL analytical functions, hierarchical, parent-child queries.<br />• Expert in design and development of jobs to capture CDC(Change Data Capture) from source systems.<br />• Expertise in Java scripts, CSS, HTML &amp; Unix shell scripts to support custom functions or steps is a plus<br />• Expert in designing and setting up exception handling and performance tuning of jobs. </span></b><span></span></b></p><p><b> </b></p><p><span></span></p><p></p> <p><span> • Ownership of all the deliverables such as Pentaho PDI Job designs, process improvements and consolidation exercises<br />• Working with dependent teams such as DBA, Admin etc for tasks that require other team’s assistance<br />• Controlling Configuration Management to take care of multiple Pentaho PDI code versions and their management<br />• Monitoring History data, Initial Loadings and data reconciliation by working closely with Business users/stakeholders for validations<br /> Strong Customer Mgt/Documentation/time/team management and organizational skills<br /></span></p><p><span></span></p> <p>All your information will be kept confidential according to EEO guidelines.</p>