Pentaho Database Developer (Remote)

Snap, Inc

Job Description

SNAP Inc. is looking for a remote Pentaho Database Developer that will be responsible for developing data solutions on a hadoop platform leveraging cutting-edge capabilities and emerging technologies.

Develops data solutions on a hadoop platform leveraging cutting-edge capabilities and emerging technologies. Collaborates with multiple contract vendors to create ETL processes using Pentaho for data ingest and data migration. Applies technical, data modeling, and analytical expertise to identify potential business rules, write scripts to transform, and clean data before ingestion. Works with and integrate multiple types of data, including unstructured and structured. Creates/Maintains jobs in Pentaho Data Integration. Builds Data Marts (includes tables, functions, stored procedures, Tablespaces, Partitions). Follows SDLC life cycle. Able to test the jobs for unit testing and SIT testing Converts from SAP Data Services to Pentaho.

  1. Expertise in Pentaho Data Integration 6/7 using relational database (4-5 years experience).

  2. Good Knowledge in SAP Data Services,

  3. Expertise in using relational databases like Oracle 11g/12C, MySQL 5/6, Sybase,SQL Server.

  4. Knowledge on AWS cloud.

  5. Expertise in writing complex SQLs.

6 . Good Understanding of Data Warehouse and Data Marts.

  1. Experience in writing custom plugins in PDI for expanding the pdi capabilities.

  2. Expertise in shell scripting in Linux.

  3. Experience in creating complex transformations, jobs in PDI.

  4. Experience in following SDLCs life cycle.

  5. Good understanding of Pentaho approach building good data warehouse.

  6. Experience with relational databases such as Oracle,MySQL.

Company Description SNAP Inc. provides professional services that empower Government and private industry clients to address tomorrow's challenges through better alignment of technology with their mission and business objectives. Employees of SNAP Inc. receive Paid Leave, Medical and Dental coverage (employee is paid for 100% by the company; dependents 50%), Life and Disability Coverage, and other benefits.

We are growing our business on a culture of employee engagement. If you are a team-centric, creative professional seeking a challenging and fulfilling career, come grow with us!

View this job on