SQL Server Data Engineer

Mizuho Bank (USA)

Contract New York, New York, United States Posted 9 months ago

 Write a Review Add Vendor   Add Contact  

About Position

SQL Server Data Engineer (Contract)

$0.00 / Hourly

New York, New York, United States

SQL Server Data Engineer

Contract New York, New York, United States Posted 9 months ago

Skills
SQL Server SSIS C# Python (Numpy Pandas) financial experience (Investment Banking)
Description

Microsoft SQL Server, including designing, developing, and implementing complex SQL queries, stored procedures, and functions.

Education: BS/BA in computer/data science/engineering or related fields

Responsibilities
  • - Strong knowledge of Microsoft SQL Server, including designing, developing, and implementing complex SQL queries, stored procedures, and functions.
  • - Expertise in Python programming, including experience with data analysis libraries such as NumPy, and Pandas.
  • - Proficiency in SSIS (SQL Server Integration Services) for ETL (Extract, Transform, and Load) processes.
  • - Proficient in C# programming, including experience with .NET framework.
  • - Strong analytical and problem-solving skills, with the ability to analyze complex data and identify trends, patterns, and insights.

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

Mizuho Bank (USA) Vendors

( Login to see all the 7 vendors)
Capgemini
Write a Review

5 Times Square
New York
New York
www.capgemini.com ( 42 vendors)

HCL Technologies America Inc
Write a Review

330 Potrero Avenue
Sunnyvale
California
www.hcltech.com ( 34 vendors)

Infinity Consulting Solutions Inc
Write a Review

462 7th Avenue 2nd Floor
New York
New York
http://infinity-cs.com ( No vendors )

Job Summary

Contract

New York, New York, United States

Experience Level : Medium

Only Any

Posted : 9 months ago

Deadline : June 21, 2024 9 months ago

Job ID : 82817G4GZ8A2Z

Mizuho Bank (USA)

1251 Avenue of the Americas

https://www.mizuhobank.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.01sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (1.7s)time
    • Application (304ms)time
    • 1 x Booting (84.86%)
      1.70s
      1 x Application (15.14%)
      304ms
      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 executed218ms
      • JobController.php#484clientfyi_final23.8msselect * from `jobs` where `job_slug` = 'sql-server-data-engineer' limit 1
        Bindings
        • 0: sql-server-data-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_final90.36msselect `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_final710μsselect * from `users` where `users`.`id` = 16457 limit 1
        Bindings
        • 0: 16457
        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_final620μ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` = 16457
        Bindings
        • 0: 1
        • 1: 16457
        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.19msselect `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` = 16457 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 16457
        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_final440μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 16457
        Bindings
        • 0: 1
        • 1: 16457
        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.92msselect DISTINCT email from `job_applications` where `category_id` = 63 and `status` = 1
        Bindings
        • 0: 63
        • 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_final400μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 82817 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 82817
        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_final950μ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_final48.35msSELECT 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.57msSELECT 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
          TRrf659PGeWgVUJjmpswTgYRyZ9ClIxHzdmRpBsX
          _previous
          array:1 [ "url" => "https://pingjob.com/sql-server-data-engineer" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /sql-server-data-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 => "3.148.106.39"
  ]
  "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 => "92ac3130ff6811fb-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.148.106.39"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.69.17.16"
  ]
  "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 => "Thu, 03 Apr 2025 23:02:13 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImtBQmlXRVB0UHlabk9teEZESWVjTFE9PSIsInZhbHVlIjoicmVwOUdxV3g5ei85RXBSd3FSeUUrdlBHVFA1OFpZTldFbjUvTmcxODdMc3QvUkxFKytFRTRlS3hNOHBVNVNsTit3ZjZiUU9NUE5reGdXSk9WbFNNVjZ2UzA2clFYSWVONWZYbUR3MjdSZllzVnVLd21PUVQvUlBSVGVWN0tObngiLCJtYWMiOiI5NmQ1YTJhZDFjYTFjMTI1ODI3OGNjNTczYTRlZDEwMzBmN2ExMGY3ZTY5OTdkNzJjMTIxYzk5N2E1ZjFjMTQ4IiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 01:02:13 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImtBQmlXRVB0UHlabk9teEZESWVjTFE9PSIsInZhbHVlIjoicmVwOUdxV3g5ei85RXBSd3FSeUUrdlBHVFA1OFpZTldFbjUvTmcxODdMc3QvUkxFKytFRTRlS3hNOHBVNVNsTit3ZjZiU ▶"
    1 => "laravel_session=eyJpdiI6IkdRMWVoWDRQUGVOczhsRE1pVVpKWlE9PSIsInZhbHVlIjoiUXg4ZDBpUElTV25sR0Y3cFBxSW4xMk4wTVhnOWNRWFhIZnN0V2tLT3ZrTXBXaUZpdEZQbTFLa3hoNG1QckdwTVlsaDRIYjl4bmRmMngyRmM2WFd4UE4wNENHTmdQQ2pWZ2NOS24wNFZxVWVCai9ESFYrS2ZWTjBzMUROY0FiVzUiLCJtYWMiOiJlNDgwMDQyZmY4MTc0Njg2YTM1ZDg0MWE1OTU3Y2IxMzQyMjJiMzcwZGQ0NmM3ZDBhNTliYjYxNWZmZmY3ODliIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 01:02:13 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkdRMWVoWDRQUGVOczhsRE1pVVpKWlE9PSIsInZhbHVlIjoiUXg4ZDBpUElTV25sR0Y3cFBxSW4xMk4wTVhnOWNRWFhIZnN0V2tLT3ZrTXBXaUZpdEZQbTFLa3hoNG1QckdwTVls ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImtBQmlXRVB0UHlabk9teEZESWVjTFE9PSIsInZhbHVlIjoicmVwOUdxV3g5ei85RXBSd3FSeUUrdlBHVFA1OFpZTldFbjUvTmcxODdMc3QvUkxFKytFRTRlS3hNOHBVNVNsTit3ZjZiUU9NUE5reGdXSk9WbFNNVjZ2UzA2clFYSWVONWZYbUR3MjdSZllzVnVLd21PUVQvUlBSVGVWN0tObngiLCJtYWMiOiI5NmQ1YTJhZDFjYTFjMTI1ODI3OGNjNTczYTRlZDEwMzBmN2ExMGY3ZTY5OTdkNzJjMTIxYzk5N2E1ZjFjMTQ4IiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 01:02:13 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImtBQmlXRVB0UHlabk9teEZESWVjTFE9PSIsInZhbHVlIjoicmVwOUdxV3g5ei85RXBSd3FSeUUrdlBHVFA1OFpZTldFbjUvTmcxODdMc3QvUkxFKytFRTRlS3hNOHBVNVNsTit3ZjZiU ▶"
    1 => "laravel_session=eyJpdiI6IkdRMWVoWDRQUGVOczhsRE1pVVpKWlE9PSIsInZhbHVlIjoiUXg4ZDBpUElTV25sR0Y3cFBxSW4xMk4wTVhnOWNRWFhIZnN0V2tLT3ZrTXBXaUZpdEZQbTFLa3hoNG1QckdwTVlsaDRIYjl4bmRmMngyRmM2WFd4UE4wNENHTmdQQ2pWZ2NOS24wNFZxVWVCai9ESFYrS2ZWTjBzMUROY0FiVzUiLCJtYWMiOiJlNDgwMDQyZmY4MTc0Njg2YTM1ZDg0MWE1OTU3Y2IxMzQyMjJiMzcwZGQ0NmM3ZDBhNTliYjYxNWZmZmY3ODliIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 01:02:13 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkdRMWVoWDRQUGVOczhsRE1pVVpKWlE9PSIsInZhbHVlIjoiUXg4ZDBpUElTV25sR0Y3cFBxSW4xMk4wTVhnOWNRWFhIZnN0V2tLT3ZrTXBXaUZpdEZQbTFLa3hoNG1QckdwTVls ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "TRrf659PGeWgVUJjmpswTgYRyZ9ClIxHzdmRpBsX"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/sql-server-data-engineer"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-03 23:02:13GET/sql-server-data-engineer311140