Senior Pentaho

Position: Senior Pentaho Developer

Work Location: Washington D.C. (Must be 2 days On-site from Day One)

Duration: Long Term

Rate: Quote your best

Resource MUST provide LinkedIn ; valid Photo ID ; Professional References



Must have Experience:

Over 10 years of experience in Information Technology with expertise in Pentaho design/development and Data Warehouse Implementation/development.

Experience in Architecting and building DW and BI systems including ETL using Pentaho BI Suite (Pentaho Data Integration Designer / Kettle).

Experienced in Design, Development and Implementation of large - scale projects in Financial, Shipping and Retail industries using Data Warehousing Pentaho ETL tools.

Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling.

Experience in performing Data Masking/Protection using Pentaho Data Integration (Kettle).

Knowledge about Software Development Lifecycle (SDLC), Agile, CI/CD deployment.

Used various steps in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file.

Integrating Kettle with Hadoop and other various NoSQL data and loaded unstructured data into Hadoop File System (HDFS).

Hands on experience on the whole ETL (Extract Transformation & Load) process.

Strong development experience in writing PL/SQL Stored Procedures, Functions, packages and debugging the code.

Strong development experience working with Columnar DBs preferably HP Vertica.

Strong expertise in Developing and Debugging MSSQL or PostgreSQL SQL scripts, functions, stored procedures, views, complex SQL queries, cursors, and triggers.

Expertise in Performance tuning, Query optimization and exception handling.

Bachelor Degree with relevant certifications highly desired.