ETL Programmer Analyst

Medtronic Inc

Contract Mounds View , Minnesota, United States Posted 6 years ago

 Write a Review Add Vendor   Add Contact  

About Position

ETL Programmer Analyst (Contract)

$90.00 / Hourly

Mounds View , Minnesota, United States

ETL Programmer Analyst

Contract Mounds View , Minnesota, United States Posted 6 years ago

Description

The resource will work with customers (process teams and business contacts) to collect and verify requirements. The resource will design the data architecture and ETL definitions to enable the handoff to the delivery organization. The resource will also participate in code reviews, unit testing, and production trouble shooting. The resource will need to handle multiple assignments at the same time. Only individuals with 10+ years experience in Oracle, Data Warehouseing Development, Informatica and Data Modeling should be presented. Required Skill Sets The following are the required skillsDatabase Oracle Data Movement/ETL Informatica Written/Oral Communication Skills Excellent Modeling Tool PowerDesigner Additional Information The position is for an Oracle Customer Data Warehouse Data Architect. The person will have solid Data Warehousing background with excellent skillsets in Oracle DB, Informatica, Data Analysis, and Modeling. The resource must also have a good understanding of UNIX. Interpersonal skills of communication are essential for a candidate to be successful; this is both written and oral.The person will work closely with the Process Teams, Project Teams, Business Customer, and BI Teams to delivery projects on time and budget. They will also be responsible for leading smaller projects/enhancements. They must me competent in working with Project managers to track progress, issues, and coordinate work.The person should be able to recommend improvements in development, maintenance, system standards, and process. They will follow Medtronic standards, procedures, methodologies, and protocols.Position Responsibilities

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

Medtronic Inc Vendors

( Login to see all the 22 vendors)
IBM Corporation
Write a Review

1133 Westchester Avenue
White Plains
New York
www.ibm.com/us ( 130 vendors)

BearingPoint Inc
Write a Review

1676 International Drive
McLean
Virginia
www.bearingpoint.com ( 47 vendors)

HCL Technologies America Inc
Write a Review

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

Job Summary

$90.00 / Hourly

Contract

Mounds View , Minnesota, United States

Experience Required : 6 Year/s

Posted : 6 years ago

Deadline : February 21, 2019 6 years ago

Job ID : Job0000014791

Medtronic Inc

710 Medtronic Pkwy NE

763-514-4000

www.medtronic.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.33sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.01s)time
    • Application (327ms)time
    • 1 x Booting (85.97%)
      2.01s
      1 x Application (14.03%)
      327ms
      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 executed235ms
      • JobController.php#484clientfyi_final24.54msselect * from `jobs` where `job_slug` = 'Job0000014791' limit 1
        Bindings
        • 0: Job0000014791
        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_final104msselect `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_final590μsselect * from `users` where `users`.`id` = 3539 limit 1
        Bindings
        • 0: 3539
        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_final1.75msselect 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` = 3539
        Bindings
        • 0: 1
        • 1: 3539
        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.45msselect `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` = 3539 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 3539
        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_final300μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 3539
        Bindings
        • 0: 1
        • 1: 3539
        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.29msselect 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_final550μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 14791 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 14791
        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.03msselect * 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.27msSELECT 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_final44.02msSELECT 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
          Q6FcpQkDIcqDeNCbJbIQRyWSLInuuoSalDC5cMYF
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000014791" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000014791
          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 => "18.221.228.143"
  ]
  "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, 22 Apr 2025 08:38:26 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJlYVNDWFkrNVpuSHpjTGNzbFJ1bFE9PSIsInZhbHVlIjoiRWM5ZFlScXp4dWJVN2lVQUFycnBqVTg4VEU4Z0MvL3NSekZURFNyL0ZiRDRUYWVFbHV3T0lBVFpQOHFtRkZCbkhNbGN2SUlPTldSdnJjWDJuL2M5dWdTV040YTlEckdYdWRuZWhuUVdaVlV0V2huR2pDRkJKQU1Lbk9RbDFISUYiLCJtYWMiOiI1ZTllZjk2NGZiNzdmZWM1NDA3MTJlMGZmMGU0NjFmNjA0NGU3NTc5MjIxYzI1M2M2YzVmYzg5ZTNjZjVjN2RmIiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 10:38:26 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlJlYVNDWFkrNVpuSHpjTGNzbFJ1bFE9PSIsInZhbHVlIjoiRWM5ZFlScXp4dWJVN2lVQUFycnBqVTg4VEU4Z0MvL3NSekZURFNyL0ZiRDRUYWVFbHV3T0lBVFpQOHFtRkZCbkhNbGN2S ▶"
    1 => "laravel_session=eyJpdiI6IllxcUVPU29RemtvWEMrNzN1V05uUkE9PSIsInZhbHVlIjoieTZUUnlPc3Urc0s2Z2RTZWVGQzdFazJuK2FHeXBoSFppdGNlTW05VDFQRXJNSzliYVBpREhKYTVTQmhndUo4c295VnliTldZbjA0RksxdXRSMmNIQ2F2QWI3Z3JCUlVhdDVnWUdiZVhCTFJPUFlOSjdlOC9XRXR5Q0kyWlA0M1oiLCJtYWMiOiIwMTY5MTlkZTMwYmJlMTY4NzFhMGViNmRmZmQ2NjI2MzVkN2FmMzhkNDNlM2VjYTRhMTMwNDQ0YWZiMDU4ZDJmIiwidGFnIjoiIn0%3D; expires=Tue, 22 Apr 2025 10:38:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IllxcUVPU29RemtvWEMrNzN1V05uUkE9PSIsInZhbHVlIjoieTZUUnlPc3Urc0s2Z2RTZWVGQzdFazJuK2FHeXBoSFppdGNlTW05VDFQRXJNSzliYVBpREhKYTVTQmhndUo4c295 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlJlYVNDWFkrNVpuSHpjTGNzbFJ1bFE9PSIsInZhbHVlIjoiRWM5ZFlScXp4dWJVN2lVQUFycnBqVTg4VEU4Z0MvL3NSekZURFNyL0ZiRDRUYWVFbHV3T0lBVFpQOHFtRkZCbkhNbGN2SUlPTldSdnJjWDJuL2M5dWdTV040YTlEckdYdWRuZWhuUVdaVlV0V2huR2pDRkJKQU1Lbk9RbDFISUYiLCJtYWMiOiI1ZTllZjk2NGZiNzdmZWM1NDA3MTJlMGZmMGU0NjFmNjA0NGU3NTc5MjIxYzI1M2M2YzVmYzg5ZTNjZjVjN2RmIiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 10:38:26 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlJlYVNDWFkrNVpuSHpjTGNzbFJ1bFE9PSIsInZhbHVlIjoiRWM5ZFlScXp4dWJVN2lVQUFycnBqVTg4VEU4Z0MvL3NSekZURFNyL0ZiRDRUYWVFbHV3T0lBVFpQOHFtRkZCbkhNbGN2S ▶"
    1 => "laravel_session=eyJpdiI6IllxcUVPU29RemtvWEMrNzN1V05uUkE9PSIsInZhbHVlIjoieTZUUnlPc3Urc0s2Z2RTZWVGQzdFazJuK2FHeXBoSFppdGNlTW05VDFQRXJNSzliYVBpREhKYTVTQmhndUo4c295VnliTldZbjA0RksxdXRSMmNIQ2F2QWI3Z3JCUlVhdDVnWUdiZVhCTFJPUFlOSjdlOC9XRXR5Q0kyWlA0M1oiLCJtYWMiOiIwMTY5MTlkZTMwYmJlMTY4NzFhMGViNmRmZmQ2NjI2MzVkN2FmMzhkNDNlM2VjYTRhMTMwNDQ0YWZiMDU4ZDJmIiwidGFnIjoiIn0%3D; expires=Tue, 22-Apr-2025 10:38:26 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IllxcUVPU29RemtvWEMrNzN1V05uUkE9PSIsInZhbHVlIjoieTZUUnlPc3Urc0s2Z2RTZWVGQzdFazJuK2FHeXBoSFppdGNlTW05VDFQRXJNSzliYVBpREhKYTVTQmhndUo4c295 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "Q6FcpQkDIcqDeNCbJbIQRyWSLInuuoSalDC5cMYF"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000014791"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-22 08:38:26GET/Job0000014791311140