Tester (ETL, Data Warehouse)

Wyeth Pharmaceuticals

Contract Collegeville, Pennsylvania, United States Posted 8 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Tester (ETL, Data Warehouse) (Contract)

$70.00 / Hourly

Collegeville, Pennsylvania, United States

Tester (ETL, Data Warehouse)

Contract Collegeville, Pennsylvania, United States Posted 8 years ago

Description

Work with the functional and technical teams to plan one or more of the following assembly, system, data integrity and performance. Assess risk and document testing strategy to ensure appropriate testing coverage for each release and seek final signoff from stakeholders. Identify tasks and estimate work effort required to implement testing strategy, and collaborate with Test Lead to include testing effort in release work plan. Create Test cases, Test scripts and Data Integrity checks for data and ETL fixes and enhancements as well as routine ETL operational monitoring. Utilize SQL and Oracle PL/SQL to effectively identify and report defects, create testing data sets and assure data quality. Define and document all testing environment requirements and tools required to implement the testing strategy. Manage the defect tracking process to ensure that defect tracking is properly addressed (identification, fixing, retesting and migration of defects).

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

Wyeth Pharmaceuticals Vendors

( Login to see all the 9 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Kforce Professional Staffing Firm
Write a Review

1001 E Palm Avenue
Tampa
Florida
www.kforce.com ( 82 vendors)

Accenture Ltd
Write a Review

1345 Avenue of the Americas
New York
New York
www.accenture.com ( 51 vendors)

Job Summary

$70.00 / Hourly

Contract

Collegeville, Pennsylvania, United States

Experience Required : 5 Year/s

Posted : 8 years ago

Deadline : August 17, 2016 8 years ago

Job ID : Job0000005818

Wyeth Pharmaceuticals

Five Giralda Farms

www.wyeth.com

Request history8.1.32PHP Version2.17sRequest Duration694MBMemory UsageGET {slug}Route
    • Booting (1.88s)time
    • Application (291ms)time
    • 1 x Booting (86.6%)
      1.88s
      1 x Application (13.4%)
      291ms
      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 executed191ms
      • JobController.php#484clientfyi_final5.8msselect * from `jobs` where `job_slug` = 'Job0000005818' limit 1
        Bindings
        • 0: Job0000005818
        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_final78.29msselect `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_final670μsselect * from `users` where `users`.`id` = 6475 limit 1
        Bindings
        • 0: 6475
        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_final670μ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` = 6475
        Bindings
        • 0: 1
        • 1: 6475
        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` = 6475 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 6475
        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_final330μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 6475
        Bindings
        • 0: 1
        • 1: 6475
        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_final10.6msselect DISTINCT email from `job_applications` where `category_id` = 37 and `status` = 1
        Bindings
        • 0: 37
        • 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_final440μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 5818 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 5818
        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_final910μ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_final49.79msSELECT 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_final41.97msSELECT 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
          JGBQYtoptjge35tUbX4GVpfGdkBLUKxhkzhEmn05
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000005818" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000005818
          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.19.60.207" ] "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 => "92a22fc68aee2330-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "3.19.60.207" ] "x-real-ip" => array:1 [ 0 => "172.71.255.104" ] "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 => "Wed, 02 Apr 2025 17:53:37 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImxBeWQ4SHNZUzR2UmZ2S1FrYUVkb0E9PSIsInZhbHVlIjoiakpCTW9RcDVNM2poMkQ0NmlQaU5PQVZSKy93OFF5anZJZFFsRW1mM3ZtQ0llZUczQVgzbDV0dlQvVE1ITmQrODdOY0RtYytJdmpHaFdpdVNtaTlNRENIbzgrNEhJY3AvUlJ1ZGxiNjdwdHRGeVFSZEpBVUs3WEI3WkwvTG95VHEiLCJtYWMiOiJlMzZjOTk2OTFhZWRhNDEyMTBkYWNmMTE0YjI2YWQ2N2M2OTU2ZDY1NThkYjhhMGRjYzMyNWJjNTdkMTM4N2FlIiwidGFnIjoiIn0%3D; expires=Wed, 02 Apr 2025 19:53:37 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImxBeWQ4SHNZUzR2UmZ2S1FrYUVkb0E9PSIsInZhbHVlIjoiakpCTW9RcDVNM2poMkQ0NmlQaU5PQVZSKy93OFF5anZJZFFsRW1mM3ZtQ0llZUczQVgzbDV0dlQvVE1ITmQrODdOY0RtY" 1 => "laravel_session=eyJpdiI6InJVZk01ZW5IbFFVaUVWY1Z1c0VPZ1E9PSIsInZhbHVlIjoicmdDM055M0hKMmFkMEp5U0dOZkVMd1NkdFVUblhJN2NmVnZ6L1k0QXFMRVU5aWtVeGJMTzJwTUh3TlgyeWVra3dkLzJwVkJrNGxRdkdPSlRicGp4ZXJiQjVjdmMwRmhLYy9zWUY4bmF2NlFEdmMxUkthRWN2RTRRR05qN3F6RWwiLCJtYWMiOiI5Zjc4MGFjNmMyODEzOWUyYTZiNmI0NWJjODlmYTM3YjNkZWYyMDYxYTI5NmExYTczOTI0YWUyMjkzYmUxMTYxIiwidGFnIjoiIn0%3D; expires=Wed, 02 Apr 2025 19:53:37 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6InJVZk01ZW5IbFFVaUVWY1Z1c0VPZ1E9PSIsInZhbHVlIjoicmdDM055M0hKMmFkMEp5U0dOZkVMd1NkdFVUblhJN2NmVnZ6L1k0QXFMRVU5aWtVeGJMTzJwTUh3TlgyeWVra3dk" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImxBeWQ4SHNZUzR2UmZ2S1FrYUVkb0E9PSIsInZhbHVlIjoiakpCTW9RcDVNM2poMkQ0NmlQaU5PQVZSKy93OFF5anZJZFFsRW1mM3ZtQ0llZUczQVgzbDV0dlQvVE1ITmQrODdOY0RtYytJdmpHaFdpdVNtaTlNRENIbzgrNEhJY3AvUlJ1ZGxiNjdwdHRGeVFSZEpBVUs3WEI3WkwvTG95VHEiLCJtYWMiOiJlMzZjOTk2OTFhZWRhNDEyMTBkYWNmMTE0YjI2YWQ2N2M2OTU2ZDY1NThkYjhhMGRjYzMyNWJjNTdkMTM4N2FlIiwidGFnIjoiIn0%3D; expires=Wed, 02-Apr-2025 19:53:37 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImxBeWQ4SHNZUzR2UmZ2S1FrYUVkb0E9PSIsInZhbHVlIjoiakpCTW9RcDVNM2poMkQ0NmlQaU5PQVZSKy93OFF5anZJZFFsRW1mM3ZtQ0llZUczQVgzbDV0dlQvVE1ITmQrODdOY0RtY" 1 => "laravel_session=eyJpdiI6InJVZk01ZW5IbFFVaUVWY1Z1c0VPZ1E9PSIsInZhbHVlIjoicmdDM055M0hKMmFkMEp5U0dOZkVMd1NkdFVUblhJN2NmVnZ6L1k0QXFMRVU5aWtVeGJMTzJwTUh3TlgyeWVra3dkLzJwVkJrNGxRdkdPSlRicGp4ZXJiQjVjdmMwRmhLYy9zWUY4bmF2NlFEdmMxUkthRWN2RTRRR05qN3F6RWwiLCJtYWMiOiI5Zjc4MGFjNmMyODEzOWUyYTZiNmI0NWJjODlmYTM3YjNkZWYyMDYxYTI5NmExYTczOTI0YWUyMjkzYmUxMTYxIiwidGFnIjoiIn0%3D; expires=Wed, 02-Apr-2025 19:53:37 GMT; path=/; httponlylaravel_session=eyJpdiI6InJVZk01ZW5IbFFVaUVWY1Z1c0VPZ1E9PSIsInZhbHVlIjoicmdDM055M0hKMmFkMEp5U0dOZkVMd1NkdFVUblhJN2NmVnZ6L1k0QXFMRVU5aWtVeGJMTzJwTUh3TlgyeWVra3dk" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "JGBQYtoptjge35tUbX4GVpfGdkBLUKxhkzhEmn05" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000005818" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-02 17:53:37GET/Job0000005818311140