Netezza Subject Matter Expert

Sogeti USA Corporation

Contract Philadelphia, Pennsylvania, United States Posted 8 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Netezza Subject Matter Expert (Contract)

$75.00 / Hourly

Philadelphia, Pennsylvania, United States

Netezza Subject Matter Expert

Contract Philadelphia, Pennsylvania, United States Posted 8 years ago

Description

1. Must have exp 23yrs exp leading/architecting Data Warehouse projects utilizing Netezza hardware within a Pharmaceutical environment. i. Must have SME architecting Data and ETL architectures on MPP Machines ii. Must have prior exp gathering business requirements and functional specifications2. Lead the architectural direction, influence design, development, implementation and maintenance of an entire infrastructure surrounding metadata management, revenue data, site performance data and click stream analytics 3. Must be able to perform database Architecture activities including i. creating data models ii. building ETL processes, iii. dimensional data modeling primarily star schema, iv. performing data migration, v. defining user interfaces, vi. executing large projects, 4. Ensure that all of the products and data within the platform are architected and integrated as a cohesive unit, ensure proper documentation, source control and change management practices 5. Must be able to interface effectively with all levels of the organization.6. Must have excellent interpersonal skills and be strong and effective communicator7. Good writing skills and ability to multi task in the support of this project

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

Sogeti USA Corporation Vendors

( Login to see all the 24 vendors)
Tektronix Inc
Write a Review

1500 North Greenville Avenue
Richardson
Texas
www.tek.com ( 5 vendors)

CyberSearch Ltd
Write a Review

3315 W Algonquin Road
Rolling Meadows
Illinois
www.cybsearch.com ( 5 vendors)

IK Solutions Inc
Write a Review

8850 Canpay Oaks Drive
Jacksonville
Florida
www.iksolutionsinc.com ( 1 vendors)

Job Summary

$75.00 / Hourly

Contract

Philadelphia, Pennsylvania, United States

Experience Required : 8 Year/s

Posted : 8 years ago

Deadline : February 28, 2017 8 years ago

Job ID : Job0000008424

Sogeti USA Corporation

7735 Paragon Road

www.sogeti.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version5.82sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (5.02s)time
    • Application (798ms)time
    • 1 x Booting (86.28%)
      5.02s
      1 x Application (13.72%)
      798ms
      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
      11 statements were executed337ms
      • JobController.php#484clientfyi_final24.72msselect * from `jobs` where `job_slug` = 'Job0000008424' limit 1
        Bindings
        • 0: Job0000008424
        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_final105msselect `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_final670μsselect * from `users` where `users`.`id` = 6569 limit 1
        Bindings
        • 0: 6569
        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_final770μ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` = 6569
        Bindings
        • 0: 1
        • 1: 6569
        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
      • Vendor.php#57clientfyi_final1.13msselect `vendors`.*, `users`.`website`, `users`.`company`, `users`.`address`, `users`.`city`, `states`.`state_name`, `countries`.`country_name`, (SELECT (SUM(ratings)/COUNT(id)) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_rating, (SELECT COUNT(id) FROM reviews WHERE reviews.employer_id = vendors.vendor_id AND reviews.approve_status = 1) as review_count, (SELECT COUNT(id) FROM vendors as b WHERE b.employer_id = vendors.vendor_id) as vendor_count 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` = 6569 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 6569
        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_final390μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 6569
        Bindings
        • 0: 1
        • 1: 6569
        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_final8.17msselect DISTINCT email from `job_applications` where `category_id` = 72 and `status` = 1
        Bindings
        • 0: 72
        • 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_final480μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 8424 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 8424
        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_final7.59msselect * 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_final118msSELECT 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_final69.74msSELECT 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
          jeyjRtFr2nSklr7w8fKPt1dx6s5GQ4yJkI4zOEDI
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000008424" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000008424
          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"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "18.223.29.51"
  ]
  "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"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "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 => "92dc7fbc2cb400fc-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.223.29.51"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.179.52"
  ]
  "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 => "Wed, 09 Apr 2025 19:44:30 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitVazJ3WldhSkxNclFGMHVFdHR0bEE9PSIsInZhbHVlIjoiMnR6SzRVenRRRVdkbXFQejhDSUlrWGRLYnF4eGNwNHh0ZmRxRXBSTkdFVm1TZ25uTmVhS3BjRUxmUlF1QXIybEFPVHcxRHNzZ0g4emw1Z3FtczBZdkF3bTYwejNTN2Y2UzZOWTJ5TnlKMHEzd3FqVXBTUnk2Y2pJWG9Qd1dscTIiLCJtYWMiOiJmODBiMzg0MzA5MjVmNjA0NGY1MzZhNGZmYWRhMDQxNTA4YjAzMTJmOTlkZTM1NWUxN2JiYWMxMWViODVlYzUzIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 21:44:30 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IitVazJ3WldhSkxNclFGMHVFdHR0bEE9PSIsInZhbHVlIjoiMnR6SzRVenRRRVdkbXFQejhDSUlrWGRLYnF4eGNwNHh0ZmRxRXBSTkdFVm1TZ25uTmVhS3BjRUxmUlF1QXIybEFPVHcxR ▶"
    1 => "laravel_session=eyJpdiI6IkZhWlRraWVXMlRuV2xueHlnQ3kvamc9PSIsInZhbHVlIjoiQ2c1WDhtS2xEeVlkSVFiRWdWWjh3THpma0RRUUY1MFUrb3VVWDNNS05CelVMdW84UmU4SHNqRjB5SEdicXJJVFQrdlRKb3FreDRRRjZ0QVRERHRBRlorMUZCSnl5WkxuU2F2WlFyTVlsSHNhYk55T2NBK2VVSlB0M1ozc0NmK2UiLCJtYWMiOiIwMDU4OTE5ZjQ2NzIwN2Y4NTg2MWYzOTUyMzJjZmUzZWI5NDdiMzliNGE3OWRmY2ZjZWVhZjQyMjU1NWIwOGVjIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 21:44:30 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkZhWlRraWVXMlRuV2xueHlnQ3kvamc9PSIsInZhbHVlIjoiQ2c1WDhtS2xEeVlkSVFiRWdWWjh3THpma0RRUUY1MFUrb3VVWDNNS05CelVMdW84UmU4SHNqRjB5SEdicXJJVFQr ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitVazJ3WldhSkxNclFGMHVFdHR0bEE9PSIsInZhbHVlIjoiMnR6SzRVenRRRVdkbXFQejhDSUlrWGRLYnF4eGNwNHh0ZmRxRXBSTkdFVm1TZ25uTmVhS3BjRUxmUlF1QXIybEFPVHcxRHNzZ0g4emw1Z3FtczBZdkF3bTYwejNTN2Y2UzZOWTJ5TnlKMHEzd3FqVXBTUnk2Y2pJWG9Qd1dscTIiLCJtYWMiOiJmODBiMzg0MzA5MjVmNjA0NGY1MzZhNGZmYWRhMDQxNTA4YjAzMTJmOTlkZTM1NWUxN2JiYWMxMWViODVlYzUzIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 21:44:30 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IitVazJ3WldhSkxNclFGMHVFdHR0bEE9PSIsInZhbHVlIjoiMnR6SzRVenRRRVdkbXFQejhDSUlrWGRLYnF4eGNwNHh0ZmRxRXBSTkdFVm1TZ25uTmVhS3BjRUxmUlF1QXIybEFPVHcxR ▶"
    1 => "laravel_session=eyJpdiI6IkZhWlRraWVXMlRuV2xueHlnQ3kvamc9PSIsInZhbHVlIjoiQ2c1WDhtS2xEeVlkSVFiRWdWWjh3THpma0RRUUY1MFUrb3VVWDNNS05CelVMdW84UmU4SHNqRjB5SEdicXJJVFQrdlRKb3FreDRRRjZ0QVRERHRBRlorMUZCSnl5WkxuU2F2WlFyTVlsSHNhYk55T2NBK2VVSlB0M1ozc0NmK2UiLCJtYWMiOiIwMDU4OTE5ZjQ2NzIwN2Y4NTg2MWYzOTUyMzJjZmUzZWI5NDdiMzliNGE3OWRmY2ZjZWVhZjQyMjU1NWIwOGVjIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 21:44:30 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkZhWlRraWVXMlRuV2xueHlnQ3kvamc9PSIsInZhbHVlIjoiQ2c1WDhtS2xEeVlkSVFiRWdWWjh3THpma0RRUUY1MFUrb3VVWDNNS05CelVMdW84UmU4SHNqRjB5SEdicXJJVFQr ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "jeyjRtFr2nSklr7w8fKPt1dx6s5GQ4yJkI4zOEDI"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000008424"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-09 19:44:30GET/Job0000008424311140