DataStage ETL Engineer

Credit Suisse

Contract New York, New York, United States Posted 1 week ago

 Write a Review Add Vendor   Add Contact  

About Position

DataStage ETL Engineer (Contract)

$60.00 / Hourly

New York, New York, United States

DataStage ETL Engineer

Contract New York, New York, United States Posted 1 week ago

Description

• seeking consultants that will participate as seniors on their DataStage team. The team will ensure that the new database code meets company standards for readability, reliability, and performance.
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.
• Developing and maintaining ETL jobs using DataStage to load into the data warehouse.
• Work with business analysts and other stakeholders to understand business requirements and ETL jobs that meet those requirements.
Consultant must have experience:
• Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.
• Must specialize in creating, enhancing, and supporting multiple data pipelines.
• Perform 'Enhancements' to legacy platforms by providing scalable and maintainable solutions.
• Manage the development and deployment of New projects and enhancement in the ETL process using DataStage.
• Designing tables and picking datatypes o Using Profiler traces and other tools to find the most frequently run queries.
• On-call troubleshooting for SQL Server service outages.
• Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
• Must have 'Excellent and Articulate' communication skills are a must. Being able to easily identify and discuss with all team members any development needs or recommended approaches is critical.
MUST HAVE:
• Must have 8+ years of experience working for US companies in the US.
• Must have 4 + years of ‘Recent’ Banking experience (Since 2017).
• Must have at least 7+ years of experience with IBM Data Stage version 9.1 - 11.5.
• Must have min 5 years of experience with ETL using DataStage.
• Must have at least 5+ years of experience with different flavors of RDBMS such as SL Server, Oracle, DB2, and Vertica.
• Must have at least 5+ years of strong experience in coding using SQL, procedures, functions and triggers.
• Must have extensive experience writing complex mapping, operations scripts and triggers to load data in to data warehouses and database and integration.
• Must have at least 2+ years of working experience in agile development practices

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

Credit Suisse Vendors

( Login to see all the 24 vendors)
Wipro Technologies
Write a Review

1300 Crittenden Lane
Mountain View
California
www.wipro.com ( 61 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

$60.00 / Hourly

Contract

New York, New York, 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 : Job0000015607

Credit Suisse

11 Madison Avenue

www.credit-suisse.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.29sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (1.98s)time
    • Application (309ms)time
    • 1 x Booting (86.51%)
      1.98s
      1 x Application (13.49%)
      309ms
      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 executed220ms
      • JobController.php#484clientfyi_final12.82msselect * from `jobs` where `job_slug` = 'datastage-etl-engineer' limit 1
        Bindings
        • 0: datastage-etl-engineer
        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_final700μsselect * from `users` where `users`.`id` = 16793 limit 1
        Bindings
        • 0: 16793
        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_final810μ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` = 16793
        Bindings
        • 0: 1
        • 1: 16793
        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.53msselect `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` = 16793 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 16793
        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_final410μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 16793
        Bindings
        • 0: 1
        • 1: 16793
        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.62msselect 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_final490μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 15607 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 15607
        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_final830μ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.62msSELECT 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.2msSELECT 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
          l0OkSbzxPgszU8eA4TIyUEZb6Ob5R4IV5IpglkRm
          _previous
          array:1 [ "url" => "https://pingjob.com/datastage-etl-engineer" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /datastage-etl-engineer
          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 => "18.216.0.219"
  ]
  "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 => "92cbed37af667fb0-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.216.0.219"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.126.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 => "Mon, 07 Apr 2025 19:28:13 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJHdm5iRmpUUUdzSmlkY1ZaL09PWXc9PSIsInZhbHVlIjoiNHRKbkxmd2kwaUp2b3F0alBLTlQvalViSEFGRTlVN09QR1lTWUEvSDNXTzJ6UHBkL0JNdjN2UTJuenhoVis5UDJ5ZDc1OWRUU1hFTDRJbHUxYy85eW02QmZSRHJ2Y3puSTVvWmxENkRGajhKdFdtRlJBVFNJUDBtbkhhNGpod2wiLCJtYWMiOiIzNWMxOTZmNzQ3YTg2NDhhMWJlN2NlYTA1ZmYxNWY0MjQyMDZiZTNjZTJkMzg1YzA5YjZhNmQ2YjJhMmYyMTc5IiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 21:28:13 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlJHdm5iRmpUUUdzSmlkY1ZaL09PWXc9PSIsInZhbHVlIjoiNHRKbkxmd2kwaUp2b3F0alBLTlQvalViSEFGRTlVN09QR1lTWUEvSDNXTzJ6UHBkL0JNdjN2UTJuenhoVis5UDJ5ZDc1O ▶"
    1 => "laravel_session=eyJpdiI6ImN1RGRwMzhvZGNYY1M5UGpIWU8velE9PSIsInZhbHVlIjoiRjRqSkcrcnlEMmk3T1JUQm93cWFJZFo2bXlGRnZoVVFGa2M4WXJVVk1HazI0RFN1ZEt5N0w0dlFFTE9tZks0UnBSc0NsMTZIbVNQTS9KM3JvRUNWY1ZRK1NTSXlrVWRlNFMvQllpSWg2RUZubE96WmI5bXkzczJHUkQrOG8wM0kiLCJtYWMiOiJjMGIxZDM5NDg2M2U3NDcyNjY0NjAwZWVkMDA1NzBhNzk3NzFlZWYzYTRkYjM3NGFlOWI5MDUxNWUwYjBkY2IwIiwidGFnIjoiIn0%3D; expires=Mon, 07 Apr 2025 21:28:13 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImN1RGRwMzhvZGNYY1M5UGpIWU8velE9PSIsInZhbHVlIjoiRjRqSkcrcnlEMmk3T1JUQm93cWFJZFo2bXlGRnZoVVFGa2M4WXJVVk1HazI0RFN1ZEt5N0w0dlFFTE9tZks0UnBS ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJHdm5iRmpUUUdzSmlkY1ZaL09PWXc9PSIsInZhbHVlIjoiNHRKbkxmd2kwaUp2b3F0alBLTlQvalViSEFGRTlVN09QR1lTWUEvSDNXTzJ6UHBkL0JNdjN2UTJuenhoVis5UDJ5ZDc1OWRUU1hFTDRJbHUxYy85eW02QmZSRHJ2Y3puSTVvWmxENkRGajhKdFdtRlJBVFNJUDBtbkhhNGpod2wiLCJtYWMiOiIzNWMxOTZmNzQ3YTg2NDhhMWJlN2NlYTA1ZmYxNWY0MjQyMDZiZTNjZTJkMzg1YzA5YjZhNmQ2YjJhMmYyMTc5IiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 21:28:13 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlJHdm5iRmpUUUdzSmlkY1ZaL09PWXc9PSIsInZhbHVlIjoiNHRKbkxmd2kwaUp2b3F0alBLTlQvalViSEFGRTlVN09QR1lTWUEvSDNXTzJ6UHBkL0JNdjN2UTJuenhoVis5UDJ5ZDc1O ▶"
    1 => "laravel_session=eyJpdiI6ImN1RGRwMzhvZGNYY1M5UGpIWU8velE9PSIsInZhbHVlIjoiRjRqSkcrcnlEMmk3T1JUQm93cWFJZFo2bXlGRnZoVVFGa2M4WXJVVk1HazI0RFN1ZEt5N0w0dlFFTE9tZks0UnBSc0NsMTZIbVNQTS9KM3JvRUNWY1ZRK1NTSXlrVWRlNFMvQllpSWg2RUZubE96WmI5bXkzczJHUkQrOG8wM0kiLCJtYWMiOiJjMGIxZDM5NDg2M2U3NDcyNjY0NjAwZWVkMDA1NzBhNzk3NzFlZWYzYTRkYjM3NGFlOWI5MDUxNWUwYjBkY2IwIiwidGFnIjoiIn0%3D; expires=Mon, 07-Apr-2025 21:28:13 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImN1RGRwMzhvZGNYY1M5UGpIWU8velE9PSIsInZhbHVlIjoiRjRqSkcrcnlEMmk3T1JUQm93cWFJZFo2bXlGRnZoVVFGa2M4WXJVVk1HazI0RFN1ZEt5N0w0dlFFTE9tZks0UnBS ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "l0OkSbzxPgszU8eA4TIyUEZb6Ob5R4IV5IpglkRm"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/datastage-etl-engineer"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-07 19:28:13GET/datastage-etl-engineer311140