Pentaho Developer

Medidata Solutions Worldwide

Contract New York, New York, United States Posted 4 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Pentaho Developer (Contract)

$65.00 / Hourly

New York, New York, United States

Pentaho Developer

Contract New York, New York, United States Posted 4 years ago

Description

Responsibilities

Create ETL pipelines that are highly optimized with very large datasets

Follow the standards and best practices to develop the ETL jobs.

Create basic data models and perform performance tuning

Work effectively using scrum with multiple team members to deliver analytical solutions to the business functions.

Perform Data analysis and validation


Skills

9+ years of exp in ETL tools

Strong expertise in SQL queries.

Prior experience Pentaho data integration tools

Communication Skills: Data Engineers are part of a team, working with database administrators, data analysts and management and need to be effective communicators.

Attention to Detail: Databases are complex, and a minute error can cause huge problems.

Problem-Solving Skills: Data Engineers look at an issue that needs to be solved and come up with solutions quickly.

Ability to take initiative and drive things on their own.

By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Job Summary

$65.00 / Hourly

Contract

New York, New York, United States

Posted : 4 years ago

Deadline : December 25, 2020 4 years ago

Job ID : Job0000024096

Medidata Solutions Worldwide

79 Fifth Avenue, 8th Floor

212-918-1800

www.mdsol.com

Request history8.1.31PHP Version2.03sRequest Duration685MBMemory UsageGET {slug}Route
    • Booting (1.75s)time
    • Application (278ms)time
    • 1 x Booting (86.31%)
      1.75s
      1 x Application (13.69%)
      278ms
      3 templates were rendered
      • frontend.job-viewjob-view.blade.php#?blade
      • admin.flash_msgflash_msg.blade.php#?blade
      • layouts.themetheme.blade.php#?blade
      uri
      GET {slug}
      middleware
      web
      controller
      App\Http\Controllers\JobController@view
      namespace
      prefix
      where
      as
      job_view
      file
      app/Http/Controllers/JobController.php:482-507
      10 statements were executed208ms
      • JobController.php#484clientfyi_final23.41msselect * from `jobs` where `job_slug` = 'Job0000024096' limit 1
        Bindings
        • 0: Job0000024096
        Backtrace
        • app/Http/Controllers/JobController.php:484
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • User.php#78clientfyi_final84.37msselect `id`, `company` from `users` where `user_type` in ('employer', 'agent') order by `id` desc
        Bindings
        • 0: employer
        • 1: agent
        Backtrace
        • app/Models/User.php:78
        • app/Http/Controllers/JobController.php:491
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#493clientfyi_final610μsselect * from `users` where `users`.`id` = 20591 limit 1
        Bindings
        • 0: 20591
        Backtrace
        • app/Http/Controllers/JobController.php:493
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • Vendor.php#57clientfyi_final470μsselect count(*) as aggregate from `vendors` inner join `users` on `vendors`.`vendor_id` = `users`.`id` inner join `states` on `users`.`state_id` = `states`.`id` inner join `countries` on `states`.`country_id` = `countries`.`id` where `vendors`.`approve_status` = 1 and `vendors`.`employer_id` = 20591
        Bindings
        • 0: 1
        • 1: 20591
        Backtrace
        • app/Models/Vendor.php:57
        • app/Http/Controllers/JobController.php:495
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • JobController.php#500clientfyi_final330μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 20591
        Bindings
        • 0: 1
        • 1: 20591
        Backtrace
        • app/Http/Controllers/JobController.php:500
        • vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
        • vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
      • job-view.blade.php#17clientfyi_final10.04msselect DISTINCT email from `job_applications` where `category_id` = 211 and `status` = 1
        Bindings
        • 0: 211
        • 1: 1
        Backtrace
        • view::frontend.job-view:17
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • job-view.blade.php#450clientfyi_final360μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 22791 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 22791
        Backtrace
        • view::frontend.job-view:450
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#101clientfyi_final810μsselect * from `categories` where `job_count` >= 1 order by `job_count` desc
        Bindings
        • 0: 1
        Backtrace
        • view::layouts.theme:101
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#102clientfyi_final45.84msSELECT jobs.state_id,jobs.state_name, COUNT(*) AS numberOfSales FROM jobs JOIN states ON states.id = jobs.state_id GROUP BY jobs.state_id,jobs.state_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:102
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      • theme.blade.php#103clientfyi_final41.75msSELECT jobs.city_id,jobs.city_name, COUNT(*) AS numberOfcities FROM jobs JOIN cities ON cities.id = jobs.city_id GROUP BY jobs.city_id,jobs.city_name ORDER BY COUNT(*) DESC limit 15
        Backtrace
        • view::layouts.theme:103
        • vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Category
      138Category.php#?
      App\Models\Job
      1Job.php#?
      App\Models\User
      1User.php#?
          _token
          pXipbW99XMErhIefyNlvX3If3xLpVthKy5kE3uAl
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000024096" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000024096
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:25 [ "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "priority" => array:1 [ 0 => "u=0, i" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cf-connecting-ip" => array:1 [ 0 => "3.142.50.218" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "cf-ray" => array:1 [ 0 => "9172765b9c280013-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.142.50.218" ] "x-real-ip" => array:1 [ 0 => "172.70.127.94" ] "host" => array:1 [ 0 => "pingjob.com" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Mon, 24 Feb 2025 21:13:57 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImZKMWk2Yk93NDJNNmpOK3l5ME9WRlE9PSIsInZhbHVlIjoidno5TFprS3VKUEFLUHM5Nnp3ZDAvaUtjMXhLUnQvRXQ5VkRRMm5Ub3pGMXh0dkE3b254bmZNSlJMcWl3Ynh1NGtvL2NTZ1hjY1Q0cFRHbktKOWdsekhQSjVwK3VpTTJvdjVxbFhRdG5XbjVSLzF4MjdZVGtKeVBTaEtUeXRQdk4iLCJtYWMiOiIzMWI5NTAxYzFjMTFmYWZlNTQyMjE0NzA5NjdkZTU5MjRmZTRkZDI1NGZiYWE2NmI0ODA2N2Y4YjkwMTA5MGJhIiwidGFnIjoiIn0%3D; expires=Mon, 24 Feb 2025 23:13:57 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImZKMWk2Yk93NDJNNmpOK3l5ME9WRlE9PSIsInZhbHVlIjoidno5TFprS3VKUEFLUHM5Nnp3ZDAvaUtjMXhLUnQvRXQ5VkRRMm5Ub3pGMXh0dkE3b254bmZNSlJMcWl3Ynh1NGtvL2NTZ" 1 => "laravel_session=eyJpdiI6Im9hak14YmgyRlZaSGFHVkFla1N4NEE9PSIsInZhbHVlIjoieHlKSkFOOHBUSzlEbVFFbDNFQ29Halp4bDFNUnUwOEhINVB2dm91MVBBTTZYSklCMEN1c1hjYkJQV1cyelB6V01PTWtwVTU4VUZCVFNRMUErOUJoaWxUZ3V1OEFXcmMyNjgyS2Jpd05sU0RwMHpDQlFpRmhTZmNUOTh5SUhCaS8iLCJtYWMiOiI1MTBiMDMxMzBlYzYwZGE3MWJmMzlmMDVlMjM4NGE0Yjc0Y2Y3MzYwZjc3Y2Y1NzIyM2MyZjE4ZTZkYmMxNDUyIiwidGFnIjoiIn0%3D; expires=Mon, 24 Feb 2025 23:13:57 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6Im9hak14YmgyRlZaSGFHVkFla1N4NEE9PSIsInZhbHVlIjoieHlKSkFOOHBUSzlEbVFFbDNFQ29Halp4bDFNUnUwOEhINVB2dm91MVBBTTZYSklCMEN1c1hjYkJQV1cyelB6V01P" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImZKMWk2Yk93NDJNNmpOK3l5ME9WRlE9PSIsInZhbHVlIjoidno5TFprS3VKUEFLUHM5Nnp3ZDAvaUtjMXhLUnQvRXQ5VkRRMm5Ub3pGMXh0dkE3b254bmZNSlJMcWl3Ynh1NGtvL2NTZ1hjY1Q0cFRHbktKOWdsekhQSjVwK3VpTTJvdjVxbFhRdG5XbjVSLzF4MjdZVGtKeVBTaEtUeXRQdk4iLCJtYWMiOiIzMWI5NTAxYzFjMTFmYWZlNTQyMjE0NzA5NjdkZTU5MjRmZTRkZDI1NGZiYWE2NmI0ODA2N2Y4YjkwMTA5MGJhIiwidGFnIjoiIn0%3D; expires=Mon, 24-Feb-2025 23:13:57 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImZKMWk2Yk93NDJNNmpOK3l5ME9WRlE9PSIsInZhbHVlIjoidno5TFprS3VKUEFLUHM5Nnp3ZDAvaUtjMXhLUnQvRXQ5VkRRMm5Ub3pGMXh0dkE3b254bmZNSlJMcWl3Ynh1NGtvL2NTZ" 1 => "laravel_session=eyJpdiI6Im9hak14YmgyRlZaSGFHVkFla1N4NEE9PSIsInZhbHVlIjoieHlKSkFOOHBUSzlEbVFFbDNFQ29Halp4bDFNUnUwOEhINVB2dm91MVBBTTZYSklCMEN1c1hjYkJQV1cyelB6V01PTWtwVTU4VUZCVFNRMUErOUJoaWxUZ3V1OEFXcmMyNjgyS2Jpd05sU0RwMHpDQlFpRmhTZmNUOTh5SUhCaS8iLCJtYWMiOiI1MTBiMDMxMzBlYzYwZGE3MWJmMzlmMDVlMjM4NGE0Yjc0Y2Y3MzYwZjc3Y2Y1NzIyM2MyZjE4ZTZkYmMxNDUyIiwidGFnIjoiIn0%3D; expires=Mon, 24-Feb-2025 23:13:57 GMT; path=/; httponlylaravel_session=eyJpdiI6Im9hak14YmgyRlZaSGFHVkFla1N4NEE9PSIsInZhbHVlIjoieHlKSkFOOHBUSzlEbVFFbDNFQ29Halp4bDFNUnUwOEhINVB2dm91MVBBTTZYSklCMEN1c1hjYkJQV1cyelB6V01P" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "pXipbW99XMErhIefyNlvX3If3xLpVthKy5kE3uAl" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000024096" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-02-24 21:13:57GET/Job0000024096310140