This site uses cookies. To find out more, see our Cookies Policy

Pentaho ETL Consultant in Toronto at Procom

Date Posted: 7/9/2018

Job Snapshot

Job Description

Job ID: 253924

Pentaho ETL Consultant

On behalf of our client in the Consulting Sector, PROCOM is looking for a Pentaho ETL Consultant for a contract or contract to hire role.

Pentaho ETL Consultant - Job Description

  • Defining and Driving Over all ETL + Big Data Solutioning / Architecture Standards
  • Integration of the Pentaho (PDI) with Hadoop associated tech stack
  • Architecture Solutioning in Pentaho PDI landscape
  • Driving ETL Development by adhering the Customer specific standards
  • Analytical, problem-solving, and conceptual skills and ability to work with a technical team
  • Performing Code Review with industry known best practices
  • Performance Tuning
  • Designing or Defining ETL strategy
  • Gathering requirements from Business Users
  • Conversion of business requirements to Pentaho PDI designs
  • Managing End to End ETL activities (analyze, build, test and deploy)
  • Developing re-usable framework / methodology / components for ETL environment
  • Pentaho PDI Job governance – Consolidation / Recommendations
  • Good Knowledge on Data warehousing Design approach
  • Excellent Knowledge in ETL Testing Methodologies
  • Performance Improvements for Pentaho PDI Jobs
  • Understand Change control Management and drive changes by performing Impact Analysis
  • 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 Documentation/time/team management and organizational skills
  • Strong communication skills
  • Strong leadership skills and work with offshore team to co-ordinate

Pentaho ETL Consultant - Mandatory Skills

  • 10+ years of BI-ETL experience, 3+ years of ETL using Pentaho Data Integration (Kettle and Spoon)
  • Hadoop (Hortonworks) and its associated tools + Pentaho (PDI) : Candidate must have 3+ years of experience in Hadoop & Pentaho integration
  • Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps and hadoop-hdfs-hive based data transformations.
  • Strong expertise in writing SQL, PL/SQL queries.
  • Expert in design and development of jobs to capture CDC(Change Data Capture) from source systems.
  • Equally experienced in Development  / Support ETL projects
  • Experience with ETL loads for Facts and Dimension tables.
  • Expert in designing and setting up exception handling and performance tuning of jobs.
  • Analyzing, designing, testing and coding of BI front end applications and backend engines

Pentaho ETL Consultant - Assignment Start Date

ASAP - Contract or Contract to Hire.

Pentaho ETL Consultant - Assignment Location

Downtown Toronto