ETL SSIS Developer

Landmark Health LLC

Contract Huntington Beach, California, United States Posted 4 years ago

 Write a Review Add Vendor   Add Contact  

About Position

ETL SSIS Developer (Contract)

$100.00 / Hourly

Huntington Beach, California, United States

ETL SSIS Developer

Contract Huntington Beach, California, United States Posted 4 years ago

Description

Mandatory Skills Design, build and deploy effective SSIS packages
Implement stored procedures and effectively query a database
Translate requirements from the business and analyst into technical code
Identify and test for bugs and bottlenecks in the ETL solution Provide support and fix issues in the packages
Writes advanced SQL including some query tuning
Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing
Some Knowledge of C#/VB.NET a plus
Utilize adhoc techniques to perform onthefly analysis of data
Proficient in how to deploy to and debug a production SSIS environment.
Job Responsibilities Design, build and deploy effective SSIS packages
Implement stored procedures and effectively query a database
Translate requirements from the business and analyst into technical code
Identify and test for bugs and bottlenecks in the ETL solution
Ensure the best possible performance and quality in the packages
Provide support and fix issues in the packages

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
Job Summary

$100.00 / Hourly

Contract

Huntington Beach, California, United States

Experience Required : 3 Year/s

Posted : 4 years ago

Deadline : August 22, 2020 4 years ago

Job ID : Job0000021426

Landmark Health LLC

7755 Center Ave. Suite #630

https://www.landmarkhealth.org

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries10Models140MailsGateSessionRequest
Request history8.1.32PHP Version4.8sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (4s)time
    • Application (800ms)time
    • 1 x Booting (83.34%)
      4.00s
      1 x Application (16.66%)
      800ms
      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
      10 statements were executed360ms
      • JobController.php#484clientfyi_final19.72msselect * from `jobs` where `job_slug` = 'Job0000021426' limit 1
        Bindings
        • 0: Job0000021426
        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_final177msselect `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_final530μsselect * from `users` where `users`.`id` = 74894 limit 1
        Bindings
        • 0: 74894
        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_final780μ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` = 74894
        Bindings
        • 0: 1
        • 1: 74894
        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_final740μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 74894
        Bindings
        • 0: 1
        • 1: 74894
        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_final12.69msselect 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_final2.64msselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 21426 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 21426
        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_final4.68msselect * 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_final59.45msSELECT 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_final82.01msSELECT 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
          jPOy8rPb7c8JdijesWmp1rAIjoK505kGBb7dk3vw
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000021426" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000021426
          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.143.254.10"
  ]
  "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 => "92bb4e6de8960bf0-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.143.254.10"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.127.51"
  ]
  "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, 05 Apr 2025 19:03:39 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitBSkI0bnlveHl2S1ZTMDYvV1hpcmc9PSIsInZhbHVlIjoiVGZGTDE2VE5OSC94elZSMmFzMUw4SUZWM0FTa1pYMXprRXduaWQxanhicTN3TVhCVUVsVFJ4YkFqN1lIV1YyTUVwdkgvTEg2SGVPekwyVEY1SjFad2dXcjdveHE3SU00L1pWRDlOa3RXeDNjb0xpSDNrbFhwZTZDdFlVQ2o2OHIiLCJtYWMiOiI2MDg0ZmY4OTg5MzVkYjU1YThmNDg1MjA5ZGZiODA3YzA1YWFmNzZiZDQ1NTAyNjM2YmY3MWM5ODNlMjdmYzI1IiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 21:03:40 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IitBSkI0bnlveHl2S1ZTMDYvV1hpcmc9PSIsInZhbHVlIjoiVGZGTDE2VE5OSC94elZSMmFzMUw4SUZWM0FTa1pYMXprRXduaWQxanhicTN3TVhCVUVsVFJ4YkFqN1lIV1YyTUVwdkgvT ▶"
    1 => "laravel_session=eyJpdiI6ImdySmpXTTJ4aTBMMWpnaFBQV29JUUE9PSIsInZhbHVlIjoiamVGZjFuMUUrMzl4TkFkdmFFZXlmU3hvZi9KRjVZWUowUVgwSzN1Rk9mSm8vVlFEeG5FQmt0UnhYVGgwQ3hIbmZaSVFiYUJyUEQ3RVhoT3VYMDBlSG5hbm92R3RDSkU2UkRDeXBLWHpVMlZtNHU0QjFUb044RzBPSCtCMGNzUDAiLCJtYWMiOiI4MGIzMzE1NDBhNDUyOGFkNmM2OTc0NDYxYTE0Zjk4NzZlNWZkNGFiNDY1YzYwMGM0MDRiNTYwMjg5MmU1ODQyIiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 21:03:40 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6ImdySmpXTTJ4aTBMMWpnaFBQV29JUUE9PSIsInZhbHVlIjoiamVGZjFuMUUrMzl4TkFkdmFFZXlmU3hvZi9KRjVZWUowUVgwSzN1Rk9mSm8vVlFEeG5FQmt0UnhYVGgwQ3hIbmZa ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IitBSkI0bnlveHl2S1ZTMDYvV1hpcmc9PSIsInZhbHVlIjoiVGZGTDE2VE5OSC94elZSMmFzMUw4SUZWM0FTa1pYMXprRXduaWQxanhicTN3TVhCVUVsVFJ4YkFqN1lIV1YyTUVwdkgvTEg2SGVPekwyVEY1SjFad2dXcjdveHE3SU00L1pWRDlOa3RXeDNjb0xpSDNrbFhwZTZDdFlVQ2o2OHIiLCJtYWMiOiI2MDg0ZmY4OTg5MzVkYjU1YThmNDg1MjA5ZGZiODA3YzA1YWFmNzZiZDQ1NTAyNjM2YmY3MWM5ODNlMjdmYzI1IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 21:03:40 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IitBSkI0bnlveHl2S1ZTMDYvV1hpcmc9PSIsInZhbHVlIjoiVGZGTDE2VE5OSC94elZSMmFzMUw4SUZWM0FTa1pYMXprRXduaWQxanhicTN3TVhCVUVsVFJ4YkFqN1lIV1YyTUVwdkgvT ▶"
    1 => "laravel_session=eyJpdiI6ImdySmpXTTJ4aTBMMWpnaFBQV29JUUE9PSIsInZhbHVlIjoiamVGZjFuMUUrMzl4TkFkdmFFZXlmU3hvZi9KRjVZWUowUVgwSzN1Rk9mSm8vVlFEeG5FQmt0UnhYVGgwQ3hIbmZaSVFiYUJyUEQ3RVhoT3VYMDBlSG5hbm92R3RDSkU2UkRDeXBLWHpVMlZtNHU0QjFUb044RzBPSCtCMGNzUDAiLCJtYWMiOiI4MGIzMzE1NDBhNDUyOGFkNmM2OTc0NDYxYTE0Zjk4NzZlNWZkNGFiNDY1YzYwMGM0MDRiNTYwMjg5MmU1ODQyIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 21:03:40 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImdySmpXTTJ4aTBMMWpnaFBQV29JUUE9PSIsInZhbHVlIjoiamVGZjFuMUUrMzl4TkFkdmFFZXlmU3hvZi9KRjVZWUowUVgwSzN1Rk9mSm8vVlFEeG5FQmt0UnhYVGgwQ3hIbmZa ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "jPOy8rPb7c8JdijesWmp1rAIjoK505kGBb7dk3vw"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000021426"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-05 19:03:40GET/Job0000021426310140