ETL DataStage Developer

State of New York

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

 Write a Review Add Vendor   Add Contact  

About Position

ETL DataStage Developer (Contract)

$90.00 / Hourly

New York, New York, United States

ETL DataStage Developer

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

Description

Client NYHRALocation or Zip Code of place of performance New York City, NYOn Site/Off Site 100 % OnsiteDuration 5 years + Extensions year on yearJob Description 8+ years of demonstrated expertise in database design and development including ETL processes5+ years hands on experience with IBM's Data Stage product3+ years in Data Stage Version 8.7 or higher.Strong understanding of RDBMS concepts and Modeling techniquesStrong background in Data Warehousing principles and methodologiesExperience with large scale development, data integration and analytical projects are requiredExperience with large/very large databases is requiredStrong SQL skills on the Oracle platform is requiredStrong UNIX scripting skills is requiredExperience with any Data Modeling tool preferably ERStudio is requiredWork effectively in a fast paced, high volume, deadline driven environmentKnowledge of IBM's Change Data Capture product is a plusKnowledge of Tibco's Spotfire product is a plus.Excellent communication skillsWork effectively in a fast paced, high volume, deadline driven environmentExperience with some of the following is a mustMicrosoft reporting products, including SharePoint, SQL Server Analysis Services, SQL Server Reporting Services, Excel Power Query, PowerPivot, Power Map,Cognos, OBIEE, SAS, Hyperion DW/ETL Tools Informatica, ODI, Datastage EPM Hyperion Essbase, Cognos Planning, Data Analytics Big data, ZoomData, Hadoop, machine learning, text analytics, Tableau, etc

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

State of New York Vendors

Deloitte Consulting
Write a Review

1633 Broadway 35th Fl
New York
New York
www.dc.com ( 48 vendors)

Nagarro
Write a Review

226 Airport Parkway, Suite 440
San Jose
California
www.nagarro.com ( No vendors )

Job Summary

$90.00 / Hourly

Contract

New York, New York, United States

Experience Required : 3 Year/s

Posted : 5 years ago

Deadline : September 30, 2019 5 years ago

Job ID : Job0000016952

State of New York

State Capitol

www.ny.gov

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.22sRequest Duration688MBMemory UsageGET {slug}Route
    • Booting (1.94s)time
    • Application (284ms)time
    • 1 x Booting (87.24%)
      1.94s
      1 x Application (12.76%)
      284ms
      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 executed201ms
      • JobController.php#484clientfyi_final17.3msselect * from `jobs` where `job_slug` = 'Job0000016952' limit 1
        Bindings
        • 0: Job0000016952
        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_final81.68msselect `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_final620μsselect * from `users` where `users`.`id` = 11605 limit 1
        Bindings
        • 0: 11605
        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_final570μ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` = 11605
        Bindings
        • 0: 1
        • 1: 11605
        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.3msselect `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` = 11605 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 11605
        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_final360μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 11605
        Bindings
        • 0: 1
        • 1: 11605
        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.31msselect DISTINCT email from `job_applications` where `category_id` = 64 and `status` = 1
        Bindings
        • 0: 64
        • 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_final390μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 16952 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 16952
        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_final850μ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_final46.76msSELECT 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_final42.55msSELECT 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
          RKHmGNInRbXY7KhJcrcwavHn06DjQ7V1kcLn0u4W
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000016952" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000016952
          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.201.19"
  ]
  "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 => "9198a5cfca9a86e7-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.142.201.19"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.131.222"
  ]
  "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 => "Sat, 01 Mar 2025 12:27:20 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZvWWxmeDNNOUlFTlFrS282ZE9pTXc9PSIsInZhbHVlIjoicVhDb3ZXTWxGNWxKYjhaRThtNjFiVE12Z0lnUHJzL0FIWDVrZUluQ2lyeVN1SzhsMWo0cC9vb2NTYXltL0VwclVqdXVxNTVuMko4dTlXWTVOVUFjWFppMXFIQWZuYXNDYTk0a3ZhSVNMcFZPbXVxM0U5bU9BYjM5MXJKOXZHRjgiLCJtYWMiOiIxNGU4ZjI0ZDU4MjUxYjY1OGVkYjFkZDgxYjFlMGNkOTc4ZDAwMjAxMTE3NThmYWViYWY2MDFhM2M4MDQ4NmYyIiwidGFnIjoiIn0%3D; expires=Sat, 01 Mar 2025 14:27:20 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImZvWWxmeDNNOUlFTlFrS282ZE9pTXc9PSIsInZhbHVlIjoicVhDb3ZXTWxGNWxKYjhaRThtNjFiVE12Z0lnUHJzL0FIWDVrZUluQ2lyeVN1SzhsMWo0cC9vb2NTYXltL0VwclVqdXVxN ▶"
    1 => "laravel_session=eyJpdiI6IitycUZBam9XZlRSdzZ4bDlSaForVlE9PSIsInZhbHVlIjoiS1hnWEJOU28rb2FYc3g3bWZvSGdlZzFTMXM1NVZSaFVmWnlPT3JoeHcxa283dU43YUJjOWVpQ2xHVXh2V0FEb09kbFVRZmMxMHNsMnQ2SVBGOHRoQWJKZmtZZnZiOXhVNE1BTENuZUw0MEdYbmt1UVk2UmtGYnNqMzhhODVLbWIiLCJtYWMiOiIxYTUwMTg3MzUzNDUzZDBiN2VjNjg2MTU1MjE3YWI2MzFkZWVkNTc3ZjlkMGVkZTI4YzhhM2I2MDJiZjI0ZDM3IiwidGFnIjoiIn0%3D; expires=Sat, 01 Mar 2025 14:27:20 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IitycUZBam9XZlRSdzZ4bDlSaForVlE9PSIsInZhbHVlIjoiS1hnWEJOU28rb2FYc3g3bWZvSGdlZzFTMXM1NVZSaFVmWnlPT3JoeHcxa283dU43YUJjOWVpQ2xHVXh2V0FEb09k ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZvWWxmeDNNOUlFTlFrS282ZE9pTXc9PSIsInZhbHVlIjoicVhDb3ZXTWxGNWxKYjhaRThtNjFiVE12Z0lnUHJzL0FIWDVrZUluQ2lyeVN1SzhsMWo0cC9vb2NTYXltL0VwclVqdXVxNTVuMko4dTlXWTVOVUFjWFppMXFIQWZuYXNDYTk0a3ZhSVNMcFZPbXVxM0U5bU9BYjM5MXJKOXZHRjgiLCJtYWMiOiIxNGU4ZjI0ZDU4MjUxYjY1OGVkYjFkZDgxYjFlMGNkOTc4ZDAwMjAxMTE3NThmYWViYWY2MDFhM2M4MDQ4NmYyIiwidGFnIjoiIn0%3D; expires=Sat, 01-Mar-2025 14:27:20 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImZvWWxmeDNNOUlFTlFrS282ZE9pTXc9PSIsInZhbHVlIjoicVhDb3ZXTWxGNWxKYjhaRThtNjFiVE12Z0lnUHJzL0FIWDVrZUluQ2lyeVN1SzhsMWo0cC9vb2NTYXltL0VwclVqdXVxN ▶"
    1 => "laravel_session=eyJpdiI6IitycUZBam9XZlRSdzZ4bDlSaForVlE9PSIsInZhbHVlIjoiS1hnWEJOU28rb2FYc3g3bWZvSGdlZzFTMXM1NVZSaFVmWnlPT3JoeHcxa283dU43YUJjOWVpQ2xHVXh2V0FEb09kbFVRZmMxMHNsMnQ2SVBGOHRoQWJKZmtZZnZiOXhVNE1BTENuZUw0MEdYbmt1UVk2UmtGYnNqMzhhODVLbWIiLCJtYWMiOiIxYTUwMTg3MzUzNDUzZDBiN2VjNjg2MTU1MjE3YWI2MzFkZWVkNTc3ZjlkMGVkZTI4YzhhM2I2MDJiZjI0ZDM3IiwidGFnIjoiIn0%3D; expires=Sat, 01-Mar-2025 14:27:20 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IitycUZBam9XZlRSdzZ4bDlSaForVlE9PSIsInZhbHVlIjoiS1hnWEJOU28rb2FYc3g3bWZvSGdlZzFTMXM1NVZSaFVmWnlPT3JoeHcxa283dU43YUJjOWVpQ2xHVXh2V0FEb09k ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "RKHmGNInRbXY7KhJcrcwavHn06DjQ7V1kcLn0u4W"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000016952"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-01 12:27:20GET/Job0000016952311140