Data Warehouse Testers Writing SQL Queries

RCG Global Services

Contract Portsmouth , New Hampshire, United States Posted 9 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Warehouse Testers Writing SQL Queries (Contract)

$85.00 / Hourly

Portsmouth , New Hampshire, United States

Data Warehouse Testers Writing SQL Queries

Contract Portsmouth , New Hampshire, United States Posted 9 years ago

Description

Data Warehouse Testers Writing SQL Queries

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

RCG Global Services Vendors

( Login to see all the 6 vendors)
Vedicsoft Solutions Inc
Write a Review

100 Wood Avenue Suite 105
Iselin
New Jersey
www.vedicsoft.com ( 1 vendors)

Princeton Edge Solutions LLC
Write a Review


South Bend
Indiana
www.princetonedge.com ( No vendors )

Fourth Technologies Inc
Write a Review

1816 Springdale Road
Cherry Hill
New Jersey
www.fortek.com ( No vendors )

Job Summary

$85.00 / Hourly

Contract

Portsmouth , New Hampshire, United States

Experience Required : 8 Year/s

Posted : 9 years ago

Deadline : November 27, 2015 9 years ago

Job ID : Job0000001392

RCG Global Services

170 South Wood Avenue, 4th Floor

www.rcgit.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version4.91sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (4.01s)time
    • Application (892ms)time
    • 1 x Booting (81.81%)
      4.01s
      1 x Application (18.19%)
      892ms
      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 executed302ms
      • JobController.php#484clientfyi_final9.05msselect * from `jobs` where `job_slug` = 'Job0000001392' limit 1
        Bindings
        • 0: Job0000001392
        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_final160msselect `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_final610μsselect * from `users` where `users`.`id` = 4697 limit 1
        Bindings
        • 0: 4697
        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_final680μ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` = 4697
        Bindings
        • 0: 1
        • 1: 4697
        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.07msselect `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` = 4697 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 4697
        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_final450μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 4697
        Bindings
        • 0: 1
        • 1: 4697
        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_final9.98msselect DISTINCT email from `job_applications` where `category_id` = 39 and `status` = 1
        Bindings
        • 0: 39
        • 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_final500μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 1392 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 1392
        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_final66.07msSELECT 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_final51.88msSELECT 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
          3Kgw4gO92oVf4GaurCQWEy8VFVPFOf6JonoaaycV
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000001392" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000001392
          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"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.144.222.234"
  ]
  "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"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "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 => "92dca934af2789f7-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.144.222.234"
  ]
  "x-real-ip" => array:1 [▶
    0 => "108.162.216.194"
  ]
  "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, 09 Apr 2025 20:12:47 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZTZlUwTm1RWEFGaWJubWlTdVZWWXc9PSIsInZhbHVlIjoiZHBqSnNOcjhTUkpwajZGZUxGSXdJdTZIQ01BM0pXdEViMXZWZmlSSEdtRTlIMW9wdXZPV3U4QkYyMXFubW9hc2U5RC9mTFFqNGI5TkpiZ3BBUkZBOU9VY1VZb3ltTWh5NC9PZmZaNW53cSt0WFVKNGZQV3JXanBUNFRSL0JSZ24iLCJtYWMiOiI4ZGQwOGUzYjM0OTUyOThlMGJmYTNkNWVlODUwYjlkMmU1MWVhYzVlN2VhZDNkZDU4MzllMWU0M2M0MTQwMTkyIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 22:12:48 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImZTZlUwTm1RWEFGaWJubWlTdVZWWXc9PSIsInZhbHVlIjoiZHBqSnNOcjhTUkpwajZGZUxGSXdJdTZIQ01BM0pXdEViMXZWZmlSSEdtRTlIMW9wdXZPV3U4QkYyMXFubW9hc2U5RC9mT ▶"
    1 => "laravel_session=eyJpdiI6IlVPTUZFREI5QW5mN0YvT21JRlBZZ0E9PSIsInZhbHVlIjoiaXFhL0xrRGpvSUtpR3kzc2tiQm90U3Jvdm04L1FDZU5yTTR0TzE2dWpSbXR5dzE3MEE4NEVIdzBBeTlRZ1lDMmxXdkRjaXV5aXJyRXV4ZlBJWXdPOThWbkNDSzBsWU1RSjNkZ2RrejJSejZVUVFnMGkyaXZhdlBEb3VsUWVRejEiLCJtYWMiOiJlZGFjMmY4NzBmNGFiNzFlOWZiYzdiN2VkODVjYjRhODBkY2I3YmUxODI0YTBmNmJmMjViNTM5ZjRhOWQwMjJlIiwidGFnIjoiIn0%3D; expires=Wed, 09 Apr 2025 22:12:48 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlVPTUZFREI5QW5mN0YvT21JRlBZZ0E9PSIsInZhbHVlIjoiaXFhL0xrRGpvSUtpR3kzc2tiQm90U3Jvdm04L1FDZU5yTTR0TzE2dWpSbXR5dzE3MEE4NEVIdzBBeTlRZ1lDMmxX ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZTZlUwTm1RWEFGaWJubWlTdVZWWXc9PSIsInZhbHVlIjoiZHBqSnNOcjhTUkpwajZGZUxGSXdJdTZIQ01BM0pXdEViMXZWZmlSSEdtRTlIMW9wdXZPV3U4QkYyMXFubW9hc2U5RC9mTFFqNGI5TkpiZ3BBUkZBOU9VY1VZb3ltTWh5NC9PZmZaNW53cSt0WFVKNGZQV3JXanBUNFRSL0JSZ24iLCJtYWMiOiI4ZGQwOGUzYjM0OTUyOThlMGJmYTNkNWVlODUwYjlkMmU1MWVhYzVlN2VhZDNkZDU4MzllMWU0M2M0MTQwMTkyIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:12:48 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImZTZlUwTm1RWEFGaWJubWlTdVZWWXc9PSIsInZhbHVlIjoiZHBqSnNOcjhTUkpwajZGZUxGSXdJdTZIQ01BM0pXdEViMXZWZmlSSEdtRTlIMW9wdXZPV3U4QkYyMXFubW9hc2U5RC9mT ▶"
    1 => "laravel_session=eyJpdiI6IlVPTUZFREI5QW5mN0YvT21JRlBZZ0E9PSIsInZhbHVlIjoiaXFhL0xrRGpvSUtpR3kzc2tiQm90U3Jvdm04L1FDZU5yTTR0TzE2dWpSbXR5dzE3MEE4NEVIdzBBeTlRZ1lDMmxXdkRjaXV5aXJyRXV4ZlBJWXdPOThWbkNDSzBsWU1RSjNkZ2RrejJSejZVUVFnMGkyaXZhdlBEb3VsUWVRejEiLCJtYWMiOiJlZGFjMmY4NzBmNGFiNzFlOWZiYzdiN2VkODVjYjRhODBkY2I3YmUxODI0YTBmNmJmMjViNTM5ZjRhOWQwMjJlIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:12:48 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlVPTUZFREI5QW5mN0YvT21JRlBZZ0E9PSIsInZhbHVlIjoiaXFhL0xrRGpvSUtpR3kzc2tiQm90U3Jvdm04L1FDZU5yTTR0TzE2dWpSbXR5dzE3MEE4NEVIdzBBeTlRZ1lDMmxX ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "3Kgw4gO92oVf4GaurCQWEy8VFVPFOf6JonoaaycV"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000001392"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-09 20:12:48GET/Job0000001392311140