ETL Datastage Developer

Verizon Business

Contract Miami , Florida, United States Posted 1 week ago

 Write a Review Add Vendor   Add Contact  

About Position

ETL Datastage Developer (Contract)

$55.00 / Hourly

Miami , Florida, United States

ETL Datastage Developer

Contract Miami , Florida, United States Posted 1 week ago

Description

Skill Required
• Should have 10+years of IT experience and minimum 4 years of DataStage experience
• Experience in as Business Intelligence & Analytics in reporting and data analysis will be advantage
• Preferably should have worked on DataStage 11.x
• Should have worked on at least 1 end to end DW Projects
• Should be able to create ETL Design Documents & Mapping Specification Documents
• Should be able to understand Data Models
• Should have enough experience to work on UNIX & Shell Scripting
• Should have strong PL/SQL & SQL Tuning skills
• Exposure to Github/QA/Jenkins/Python/Hadoop is preferable
• Need to Work with Business & IT to convert the functional requirement into DataStage ETL Business requirement and specifications - Requirement analysis.
• Develop DS Wrapper Unix scripts to invoke the DataStage job
Nice to have
• Telecom domain exposure
• Azure/AWS Cloud experience
• DataStage certification

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

Verizon Business Vendors

( Login to see all the 12 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Cognizant Technology Solutions Corporation
Write a Review

500 Frank W. Burr Boulevard
Teaneck
New Jersey
www.Cognizant.com ( 50 vendors)

Brillio
Write a Review

5201 Great America Parkway
Santa Clara
California
www.brillio.com ( 24 vendors)

Job Summary

$55.00 / Hourly

Contract

Miami , Florida, United States

Experience Level : Medium

Experience Required : 6 Year/s

Only Any

Posted : 1 week ago

Deadline : March 26, 2025 1 week ago

Job ID : Job0000003286

Verizon Business

140 West Street

www.verizonbusiness.com

Request history8.1.32PHP Version3.31sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.83s)time
    • Application (484ms)time
    • 1 x Booting (85.37%)
      2.83s
      1 x Application (14.63%)
      484ms
      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 executed199ms
      • JobController.php#484clientfyi_final3.36msselect * from `jobs` where `job_slug` = 'etl-datastage-developer-1' limit 1
        Bindings
        • 0: etl-datastage-developer-1
        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_final88.72msselect `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_final830μsselect * from `users` where `users`.`id` = 6219 limit 1
        Bindings
        • 0: 6219
        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_final630μ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` = 6219
        Bindings
        • 0: 1
        • 1: 6219
        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.82msselect `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` = 6219 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 6219
        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_final320μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 6219
        Bindings
        • 0: 1
        • 1: 6219
        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_final9.76msselect DISTINCT email from `job_applications` where `category_id` = 161 and `status` = 1
        Bindings
        • 0: 161
        • 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_final500μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 3286 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 3286
        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_final1.05msselect * 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_final48.06msSELECT 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_final43.65msSELECT 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
          v9ZADNVO6OVx2ePWZLj4Z2lJaWcfO9UVp9T9ur8B
          _previous
          array:1 [ "url" => "https://pingjob.com/etl-datastage-developer-1" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /etl-datastage-developer-1
          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.129.218.43" ] "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 => "92ce364c1815813d-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.129.218.43" ] "x-real-ip" => array:1 [ 0 => "172.70.131.68" ] "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 => "Tue, 08 Apr 2025 02:07:39 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ims5UU14TFJQQWkyS1hBOGhOSVYvV2c9PSIsInZhbHVlIjoiWVBlMGVzMDVVOGJTQVpoRERvdjVRaHFaYU9lZ3Vyb2F4TjBnWFh1WVg4UWFCcnZNbFNBOHYwejJqbFg3aHV1VExFL3EvR3VZT3Mwbm9yUmFkK2tQR2FnVE9ZVFY0aEQxdVZ1Z2pSWmJqYm1yVDBVaVpsOEpxaDk1c2NuK1RQODMiLCJtYWMiOiJjNWMyOGE5ZjM2ZDc2YTNkZmFhNjg4NTk5NDJkNGVlZGE0ZmEzZTNmZGZmMjc3YWVjNzUyODk5YTFkY2E5NmRiIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 04:07:39 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6Ims5UU14TFJQQWkyS1hBOGhOSVYvV2c9PSIsInZhbHVlIjoiWVBlMGVzMDVVOGJTQVpoRERvdjVRaHFaYU9lZ3Vyb2F4TjBnWFh1WVg4UWFCcnZNbFNBOHYwejJqbFg3aHV1VExFL3EvR" 1 => "laravel_session=eyJpdiI6InlIODNlWU9aUnFQaExQdmY3WXFpVmc9PSIsInZhbHVlIjoiZEpBdVliN1UzblNtT1pSSFRzamVYZGcvR0tXeVlvYVhYY1gvZEtnMndCakVBYVlyR3BsYmNHVTBhM29BRUUwRG1FaGhHdnhPbkRsV21zTUJxRTVOeGpxZGxueFlTTWlpRkJiS29KVFMwY3d5dmd3RUlHanVZQXFVV0lWV1R6SkwiLCJtYWMiOiI2ZDAwMjZiNWNkMTYyYzQ3MWRlMjkxYmM4NzA2MTM0ODk3MWRiMjNkMGJiZWUwNWUyODkzODFkM2NjZDM0YmNhIiwidGFnIjoiIn0%3D; expires=Tue, 08 Apr 2025 04:07:39 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6InlIODNlWU9aUnFQaExQdmY3WXFpVmc9PSIsInZhbHVlIjoiZEpBdVliN1UzblNtT1pSSFRzamVYZGcvR0tXeVlvYVhYY1gvZEtnMndCakVBYVlyR3BsYmNHVTBhM29BRUUwRG1F" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ims5UU14TFJQQWkyS1hBOGhOSVYvV2c9PSIsInZhbHVlIjoiWVBlMGVzMDVVOGJTQVpoRERvdjVRaHFaYU9lZ3Vyb2F4TjBnWFh1WVg4UWFCcnZNbFNBOHYwejJqbFg3aHV1VExFL3EvR3VZT3Mwbm9yUmFkK2tQR2FnVE9ZVFY0aEQxdVZ1Z2pSWmJqYm1yVDBVaVpsOEpxaDk1c2NuK1RQODMiLCJtYWMiOiJjNWMyOGE5ZjM2ZDc2YTNkZmFhNjg4NTk5NDJkNGVlZGE0ZmEzZTNmZGZmMjc3YWVjNzUyODk5YTFkY2E5NmRiIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 04:07:39 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6Ims5UU14TFJQQWkyS1hBOGhOSVYvV2c9PSIsInZhbHVlIjoiWVBlMGVzMDVVOGJTQVpoRERvdjVRaHFaYU9lZ3Vyb2F4TjBnWFh1WVg4UWFCcnZNbFNBOHYwejJqbFg3aHV1VExFL3EvR" 1 => "laravel_session=eyJpdiI6InlIODNlWU9aUnFQaExQdmY3WXFpVmc9PSIsInZhbHVlIjoiZEpBdVliN1UzblNtT1pSSFRzamVYZGcvR0tXeVlvYVhYY1gvZEtnMndCakVBYVlyR3BsYmNHVTBhM29BRUUwRG1FaGhHdnhPbkRsV21zTUJxRTVOeGpxZGxueFlTTWlpRkJiS29KVFMwY3d5dmd3RUlHanVZQXFVV0lWV1R6SkwiLCJtYWMiOiI2ZDAwMjZiNWNkMTYyYzQ3MWRlMjkxYmM4NzA2MTM0ODk3MWRiMjNkMGJiZWUwNWUyODkzODFkM2NjZDM0YmNhIiwidGFnIjoiIn0%3D; expires=Tue, 08-Apr-2025 04:07:39 GMT; path=/; httponlylaravel_session=eyJpdiI6InlIODNlWU9aUnFQaExQdmY3WXFpVmc9PSIsInZhbHVlIjoiZEpBdVliN1UzblNtT1pSSFRzamVYZGcvR0tXeVlvYVhYY1gvZEtnMndCakVBYVlyR3BsYmNHVTBhM29BRUUwRG1F" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "v9ZADNVO6OVx2ePWZLj4Z2lJaWcfO9UVp9T9ur8B" "_previous" => array:1 [ "url" => "https://pingjob.com/etl-datastage-developer-1" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-08 02:07:39GET/etl-datastage-developer-1311140