| ETL with data warehouse (Senior Pentaho Developer) at Washington, DC at Washington, DC, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=675718&uid= From: Harsh Goyal, Tek inspirations [email protected] Reply to: [email protected] Job Description - ETL / data warehouse (Senior Pentaho Developer) (Onsite) Location: Washington, DC Visa: USC/GC/GC-EAD Need 2 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. Keywords: continuous integration continuous deployment business intelligence hewlett packard green card procedural language http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=675718&uid= |
| [email protected] View All |
| 06:52 PM 25-Sep-23 |