Description
Job Description:
5+ years of ETL experience, 2+ 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.