ETL Tester

Genesee & Wyoming Inc

Contract Rochester, New York, United States Posted 4 years ago

 Write a Review Add Vendor   Add Contact  

About Position

ETL Tester (Contract)

$60.00 / Hourly

Rochester, New York, United States

ETL Tester

Contract Rochester, New York, United States Posted 4 years ago

Description

Job Description

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

$60.00 / Hourly

Contract

Rochester, New York, United States

Experience Required : 7 Year/s

Posted : 4 years ago

Deadline : July 21, 2020 4 years ago

Job ID : Job0000020565

Genesee & Wyoming Inc

20 West Ave

www.gwrr.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries10Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.38sRequest Duration689MBMemory UsageGET {slug}Route
    • Booting (1.92s)time
    • Application (460ms)time
    • 1 x Booting (80.72%)
      1.92s
      1 x Application (19.28%)
      460ms
      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 executed200ms
      • JobController.php#484clientfyi_final21.19msselect * from `jobs` where `job_slug` = 'Job0000020565' limit 1
        Bindings
        • 0: Job0000020565
        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_final80.51msselect `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_final600μsselect * from `users` where `users`.`id` = 4669 limit 1
        Bindings
        • 0: 4669
        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_final420μ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` = 4669
        Bindings
        • 0: 1
        • 1: 4669
        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_final310μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 4669
        Bindings
        • 0: 1
        • 1: 4669
        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.87msselect DISTINCT email from `job_applications` where `category_id` = 82 and `status` = 1
        Bindings
        • 0: 82
        • 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_final470μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 20565 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 20565
        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_final860μ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_final45.69msSELECT 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.17msSELECT 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
          dr9Yc9yokxc0NfIaDDZnLJrXaN7JTp5GOgXsHUbT
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000020565" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000020565
          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 => "52.14.75.150"
  ]
  "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 => "91b668ff9e7611a7-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "52.14.75.150"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.69.59.23"
  ]
  "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, 05 Mar 2025 03:08:42 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNtQVpVc3NXbjZsQUJRT3h2L0doVGc9PSIsInZhbHVlIjoiOGo2clo4cnRZMTJaYldITHRrWnJwS0hBYTMwN2NNT2lqZjBRcHJsTmFRYm1EanNoaUp0K1BSZTFnWXN4MU9tR0Z6c05RRWpGSktrWG5MYTJLdmV1SkV1Nk50bkNhVjFVZkxJR2lKU2lFZTM4MERyck5MNk42ZDlaSUVBRi9WbmwiLCJtYWMiOiJiZTczNDQ1ODZkZTYzZTM4NDg0OWQ2MzRlYjIzNGI3YmRkZDk3ZDc1MGY2YjdlOTE1OTE2NTk0Yzg0ZmI2MGQ1IiwidGFnIjoiIn0%3D; expires=Wed, 05 Mar 2025 05:08:42 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImNtQVpVc3NXbjZsQUJRT3h2L0doVGc9PSIsInZhbHVlIjoiOGo2clo4cnRZMTJaYldITHRrWnJwS0hBYTMwN2NNT2lqZjBRcHJsTmFRYm1EanNoaUp0K1BSZTFnWXN4MU9tR0Z6c05RR ▶"
    1 => "laravel_session=eyJpdiI6IlBzeVBlTStXREtsWU1NTE16aStzbHc9PSIsInZhbHVlIjoiaGJiNXhNTWlxVGRBQmp5MmNSMTBHZnJ3R3liSWY1a2krd3pQYnl6Titmb2RoWXo2VHc0WTBzcjBIcWljdlZMbVh5cytLRjhZTzFMc01rNWQwbWI3Ri9na295NkF4c3d6elhVNmttcDBNYWxNaDliaEdJWml2TkMxL200b3VPNzciLCJtYWMiOiJhYzI4MDVhZmQwNWE0ZGMwZWIzNjU0NWYxZDc1NmFhMTY3ODU0Njg4NzY2YTIzZDA0NjA5MzZlMjRmMjhjYzhlIiwidGFnIjoiIn0%3D; expires=Wed, 05 Mar 2025 05:08:42 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlBzeVBlTStXREtsWU1NTE16aStzbHc9PSIsInZhbHVlIjoiaGJiNXhNTWlxVGRBQmp5MmNSMTBHZnJ3R3liSWY1a2krd3pQYnl6Titmb2RoWXo2VHc0WTBzcjBIcWljdlZMbVh5 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNtQVpVc3NXbjZsQUJRT3h2L0doVGc9PSIsInZhbHVlIjoiOGo2clo4cnRZMTJaYldITHRrWnJwS0hBYTMwN2NNT2lqZjBRcHJsTmFRYm1EanNoaUp0K1BSZTFnWXN4MU9tR0Z6c05RRWpGSktrWG5MYTJLdmV1SkV1Nk50bkNhVjFVZkxJR2lKU2lFZTM4MERyck5MNk42ZDlaSUVBRi9WbmwiLCJtYWMiOiJiZTczNDQ1ODZkZTYzZTM4NDg0OWQ2MzRlYjIzNGI3YmRkZDk3ZDc1MGY2YjdlOTE1OTE2NTk0Yzg0ZmI2MGQ1IiwidGFnIjoiIn0%3D; expires=Wed, 05-Mar-2025 05:08:42 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImNtQVpVc3NXbjZsQUJRT3h2L0doVGc9PSIsInZhbHVlIjoiOGo2clo4cnRZMTJaYldITHRrWnJwS0hBYTMwN2NNT2lqZjBRcHJsTmFRYm1EanNoaUp0K1BSZTFnWXN4MU9tR0Z6c05RR ▶"
    1 => "laravel_session=eyJpdiI6IlBzeVBlTStXREtsWU1NTE16aStzbHc9PSIsInZhbHVlIjoiaGJiNXhNTWlxVGRBQmp5MmNSMTBHZnJ3R3liSWY1a2krd3pQYnl6Titmb2RoWXo2VHc0WTBzcjBIcWljdlZMbVh5cytLRjhZTzFMc01rNWQwbWI3Ri9na295NkF4c3d6elhVNmttcDBNYWxNaDliaEdJWml2TkMxL200b3VPNzciLCJtYWMiOiJhYzI4MDVhZmQwNWE0ZGMwZWIzNjU0NWYxZDc1NmFhMTY3ODU0Njg4NzY2YTIzZDA0NjA5MzZlMjRmMjhjYzhlIiwidGFnIjoiIn0%3D; expires=Wed, 05-Mar-2025 05:08:42 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlBzeVBlTStXREtsWU1NTE16aStzbHc9PSIsInZhbHVlIjoiaGJiNXhNTWlxVGRBQmp5MmNSMTBHZnJ3R3liSWY1a2krd3pQYnl6Titmb2RoWXo2VHc0WTBzcjBIcWljdlZMbVh5 ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "dr9Yc9yokxc0NfIaDDZnLJrXaN7JTp5GOgXsHUbT"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000020565"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-05 03:08:42GET/Job0000020565310140