ideaVat
Responsibilities
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 Expert 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 teams' 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.
#J-18808-Ljbffr
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 Expert 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 teams' 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.
#J-18808-Ljbffr