Snowflake Developer

State Street Corporation

Contract Boston, Massachusetts, United States Posted 7 months ago

 Write a Review Add Vendor   Add Contact  

About Position

Snowflake Developer (Contract)

$70.00 / Hourly

Boston, Massachusetts, United States

Snowflake Developer

Contract Boston, Massachusetts, United States Posted 7 months ago

Description

Snowflake SnowPro Certification– required.

5-6 years’ experience in cloud-based solutions.

2+ years in hands on snowflake development.

Hands on experience in Design, build data pipelines on cloud-based infrastructure having extensively worked on Azure, snowflake, DBT, Airflow and cosmos db.

Having done end to end build from ingestion, transformation, and extract generation in Snowflake.

Experience in writing stored procedures in JavaScript.

Knowledge and experience in python, is a plus.

Optimize and tune snowflake performance including query optimization and have experience in scaling strategies.

Address data issues, root cause analysis and production support.

Experience working in a Financial Industry.

Understanding Agile methodologies.

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 Street Corporation Vendors

( Login to see all the 21 vendors)
Akkodis
Write a Review

1 Independent Drive
Jacksonville
Florida
https://www.akkodis.com/ ( 81 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)

Job Summary

$70.00 / Hourly

Contract

Boston, Massachusetts, United States

Experience Level : Medium

Experience Required : 9 Year/s

Only Any

Posted : 7 months ago

Deadline : September 10, 2024 7 months ago

Job ID : Job0000008931

State Street Corporation

State Street Financial Center , One Lincoln Street

617-786-3000

www.statestreet.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version8.26sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (7.07s)time
    • Application (1.19s)time
    • 1 x Booting (85.61%)
      7.07s
      1 x Application (14.39%)
      1.19s
      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 executed503ms
      • JobController.php#484clientfyi_final8.2msselect * from `jobs` where `job_slug` = 'snowflake-developer-7' limit 1
        Bindings
        • 0: snowflake-developer-7
        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_final263msselect `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_final51.01msselect * from `users` where `users`.`id` = 5341 limit 1
        Bindings
        • 0: 5341
        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_final12.78msselect 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` = 5341
        Bindings
        • 0: 1
        • 1: 5341
        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_final10.44msselect `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` = 5341 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 5341
        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_final1.07msselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 5341
        Bindings
        • 0: 1
        • 1: 5341
        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_final20.31msselect DISTINCT email from `job_applications` where `category_id` = 187 and `status` = 1
        Bindings
        • 0: 187
        • 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_final460μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 8931 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 8931
        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_final700μ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_final87.81msSELECT 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_final47.53msSELECT 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
          EbvVUnw8SX98LCvvfVAYHpidRLWS9w16Dvy7vhEa
          _previous
          array:1 [ "url" => "https://pingjob.com/snowflake-developer-7" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /snowflake-developer-7
          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:18 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "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"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-real-ip" => array:1 [▶
    0 => "3.142.174.206"
  ]
  "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, 28 Apr 2025 11:42:19 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImorOWRKcm8yT2ZHV3I2a1pnTDlJOHc9PSIsInZhbHVlIjoiWE4vMUpvR3RRUkxwSXBzcmswdi9zV2krdWJyZFNIN1g1NVRteHB1WGthOFNnQUN2aUgzcUt5ZUVlQlBiM01DTURpY01NT3ZqSmVLN2RiWk4rb0F5OUgzbGthR1dqYmcyK1FMUUxpVkNGaUxtRXVUVFZPVWpMQW4vYWdyQUR3SnMiLCJtYWMiOiI0Y2ZlM2NiODRkNmIxODNkMDk0OWRhZGExYjdjZTBiYzZhZTllNWZkNTM5ZTA2MzgwNDEyMmRiZGY2Y2FhYzQ3IiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 13:42:19 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImorOWRKcm8yT2ZHV3I2a1pnTDlJOHc9PSIsInZhbHVlIjoiWE4vMUpvR3RRUkxwSXBzcmswdi9zV2krdWJyZFNIN1g1NVRteHB1WGthOFNnQUN2aUgzcUt5ZUVlQlBiM01DTURpY01NT ▶"
    1 => "laravel_session=eyJpdiI6IkowRkhGc09JUE1WTzRiUmMwdzRVcmc9PSIsInZhbHVlIjoiaDAxUys1NHlKUk9ucThRQ0JUeDVFaWF0ZDNPeEQzbHdHTjlEczdKcGZTOW51OHpIM0xaenpvTnF6UlpLWFFDZzF0bHovNlo2WFFUL3pRQlRPY21HRTN4MXdqM1VqYkZmc2xOVFBaeXJ4QVdWekRwenVwNUNxSEp4cENaN0x1anoiLCJtYWMiOiIzNjU5YzVjNWMxOWY4NTQwMzk0NTQzNjBmNzlmNzg5YWIyYTM2YTY0MzZkNmYyYTZmZmI5ZTQ4YTNiMjVhMjAxIiwidGFnIjoiIn0%3D; expires=Mon, 28 Apr 2025 13:42:19 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IkowRkhGc09JUE1WTzRiUmMwdzRVcmc9PSIsInZhbHVlIjoiaDAxUys1NHlKUk9ucThRQ0JUeDVFaWF0ZDNPeEQzbHdHTjlEczdKcGZTOW51OHpIM0xaenpvTnF6UlpLWFFDZzF0 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImorOWRKcm8yT2ZHV3I2a1pnTDlJOHc9PSIsInZhbHVlIjoiWE4vMUpvR3RRUkxwSXBzcmswdi9zV2krdWJyZFNIN1g1NVRteHB1WGthOFNnQUN2aUgzcUt5ZUVlQlBiM01DTURpY01NT3ZqSmVLN2RiWk4rb0F5OUgzbGthR1dqYmcyK1FMUUxpVkNGaUxtRXVUVFZPVWpMQW4vYWdyQUR3SnMiLCJtYWMiOiI0Y2ZlM2NiODRkNmIxODNkMDk0OWRhZGExYjdjZTBiYzZhZTllNWZkNTM5ZTA2MzgwNDEyMmRiZGY2Y2FhYzQ3IiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 13:42:19 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImorOWRKcm8yT2ZHV3I2a1pnTDlJOHc9PSIsInZhbHVlIjoiWE4vMUpvR3RRUkxwSXBzcmswdi9zV2krdWJyZFNIN1g1NVRteHB1WGthOFNnQUN2aUgzcUt5ZUVlQlBiM01DTURpY01NT ▶"
    1 => "laravel_session=eyJpdiI6IkowRkhGc09JUE1WTzRiUmMwdzRVcmc9PSIsInZhbHVlIjoiaDAxUys1NHlKUk9ucThRQ0JUeDVFaWF0ZDNPeEQzbHdHTjlEczdKcGZTOW51OHpIM0xaenpvTnF6UlpLWFFDZzF0bHovNlo2WFFUL3pRQlRPY21HRTN4MXdqM1VqYkZmc2xOVFBaeXJ4QVdWekRwenVwNUNxSEp4cENaN0x1anoiLCJtYWMiOiIzNjU5YzVjNWMxOWY4NTQwMzk0NTQzNjBmNzlmNzg5YWIyYTM2YTY0MzZkNmYyYTZmZmI5ZTQ4YTNiMjVhMjAxIiwidGFnIjoiIn0%3D; expires=Mon, 28-Apr-2025 13:42:19 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkowRkhGc09JUE1WTzRiUmMwdzRVcmc9PSIsInZhbHVlIjoiaDAxUys1NHlKUk9ucThRQ0JUeDVFaWF0ZDNPeEQzbHdHTjlEczdKcGZTOW51OHpIM0xaenpvTnF6UlpLWFFDZzF0 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "EbvVUnw8SX98LCvvfVAYHpidRLWS9w16Dvy7vhEa"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/snowflake-developer-7"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-28 11:42:19GET/snowflake-developer-7311140