Data Engineer

Tokio Marine America

Contract Houston, Texas, United States Posted 3 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Engineer (Contract)

$50.00 / Hourly

Houston, Texas, United States

Data Engineer

Contract Houston, Texas, United States Posted 3 years ago

Description

Must have experience in ETL/DWH/MSBI/Data Modelling
Must have strong SQL writing experience.
Must have experience in building extraction logic.
SQL Server experience especially in Stored Procedures troubleshooting and development.
Exposure to Snowflake/AWS/Attinuity - Exposure to Insurance P&C domain.
8+ years of experience in handling Data related project.
Data integration and big data management experience.
Ability to demonstrate articulate solution for given requirements & ability to handle clients independently .
Good communication skills

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

Tokio Marine America Vendors

( Login to see all the 5 vendors)
NTT DATA Inc
Write a Review

100 City Square
Boston
Massachusetts
https://us.nttdata.com ( 36 vendors)

BirlaSoft Inc
Write a Review

2035 Lincoln Highway
Edison
New Jersey
www.birlasoft.com ( 15 vendors)

Coforge
Write a Review

502 Carnegie Center Drive Suite #301
Princeton
New Jersey
https://www.coforgetech.com/ ( 8 vendors)

Job Summary

$50.00 / Hourly

Contract

Houston, Texas, United States

Experience Required : 4 Year/s

Posted : 3 years ago

Deadline : October 14, 2021 3 years ago

Job ID : Job000003517

Tokio Marine America

1221 Avenue of the Americas Suite 1500

www.tmamerica.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version3.29sRequest Duration692MBMemory UsageGET {slug}Route
    • Booting (2.83s)time
    • Application (463ms)time
    • 1 x Booting (85.95%)
      2.83s
      1 x Application (14.05%)
      463ms
      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 executed214ms
      • JobController.php#484clientfyi_final25.33msselect * from `jobs` where `job_slug` = 'Job000003517' limit 1
        Bindings
        • 0: Job000003517
        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_final82.03msselect `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_final580μsselect * from `users` where `users`.`id` = 5910 limit 1
        Bindings
        • 0: 5910
        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_final500μ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` = 5910
        Bindings
        • 0: 1
        • 1: 5910
        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_final970μsselect `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` = 5910 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 5910
        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` = 5910
        Bindings
        • 0: 1
        • 1: 5910
        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.56msselect DISTINCT email from `job_applications` where `category_id` = 211 and `status` = 1
        Bindings
        • 0: 211
        • 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_final380μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 80803 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 80803
        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_final830μ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_final46.12msSELECT 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_final46.65msSELECT 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
          1rOCqu5vo8HzuCK2LuWHFM77PNLWaSQWkRHcSUWz
          _previous
          array:1 [ "url" => "https://pingjob.com/Job000003517" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job000003517
          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.144.8.165"
  ]
  "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 => "9208e15f7c7dcf03-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.144.8.165"
  ]
  "x-real-ip" => array:1 [▶
    0 => "108.162.216.119"
  ]
  "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, 15 Mar 2025 03:21:26 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjJOVFhsMnl0czllQklaOHp6OHN1THc9PSIsInZhbHVlIjoiZmZCOHJKTHJ1TUVVSjVVY0ZVOXkyZFNtTS9UbWpnSmdNK3Q5VkFCQWE3eGVXRFlIOCs1VVRQZ0tCczdlTDRLMUdpeHpqMTlkdEpPK3llaTBDVDlLMGVXVHRsYkU1TUlYMDRFNG9OeGsvd0IwRWZ4aW52OHdnbDdqb1RDZ3hlYUUiLCJtYWMiOiJlYjM5M2E0ZDdmMDdjNTVhMTUwYjNiZTFjNjg2MjQwZTBkNDMzZjk5MDg1MjUzMTU5YzZjMGMzMzEyYzkyNTVkIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 05:21:26 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjJOVFhsMnl0czllQklaOHp6OHN1THc9PSIsInZhbHVlIjoiZmZCOHJKTHJ1TUVVSjVVY0ZVOXkyZFNtTS9UbWpnSmdNK3Q5VkFCQWE3eGVXRFlIOCs1VVRQZ0tCczdlTDRLMUdpeHpqM ▶"
    1 => "laravel_session=eyJpdiI6IjB1TE1HN241U3dWK0Roa05RKzBJN3c9PSIsInZhbHVlIjoiQVh4cFZIYXROQzZSRUt6M2E1QmVqVGhMM0U5MTQ0ZUhLZTVsS05SYy83ZEQwaUtrOUltNUNDWEtmZWpaSGpadWpFRHdrOS9Hd29DeVM1Q1JnM3BiY09rZUp1SS9yTit0MnZZb1RkUkc0aHUwWEIzNWY5OEx2VXhBS1k5Qlp2RzMiLCJtYWMiOiJiNzJhOGZjY2MyYjQwN2U0ZjMxY2I0MjQwNjg0ZjNjMWRkODA3MDNlZDZiMzU0ODA5OWUxNGZhNzM0ZDU0NmZkIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 05:21:26 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IjB1TE1HN241U3dWK0Roa05RKzBJN3c9PSIsInZhbHVlIjoiQVh4cFZIYXROQzZSRUt6M2E1QmVqVGhMM0U5MTQ0ZUhLZTVsS05SYy83ZEQwaUtrOUltNUNDWEtmZWpaSGpadWpF ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjJOVFhsMnl0czllQklaOHp6OHN1THc9PSIsInZhbHVlIjoiZmZCOHJKTHJ1TUVVSjVVY0ZVOXkyZFNtTS9UbWpnSmdNK3Q5VkFCQWE3eGVXRFlIOCs1VVRQZ0tCczdlTDRLMUdpeHpqMTlkdEpPK3llaTBDVDlLMGVXVHRsYkU1TUlYMDRFNG9OeGsvd0IwRWZ4aW52OHdnbDdqb1RDZ3hlYUUiLCJtYWMiOiJlYjM5M2E0ZDdmMDdjNTVhMTUwYjNiZTFjNjg2MjQwZTBkNDMzZjk5MDg1MjUzMTU5YzZjMGMzMzEyYzkyNTVkIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 05:21:26 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjJOVFhsMnl0czllQklaOHp6OHN1THc9PSIsInZhbHVlIjoiZmZCOHJKTHJ1TUVVSjVVY0ZVOXkyZFNtTS9UbWpnSmdNK3Q5VkFCQWE3eGVXRFlIOCs1VVRQZ0tCczdlTDRLMUdpeHpqM ▶"
    1 => "laravel_session=eyJpdiI6IjB1TE1HN241U3dWK0Roa05RKzBJN3c9PSIsInZhbHVlIjoiQVh4cFZIYXROQzZSRUt6M2E1QmVqVGhMM0U5MTQ0ZUhLZTVsS05SYy83ZEQwaUtrOUltNUNDWEtmZWpaSGpadWpFRHdrOS9Hd29DeVM1Q1JnM3BiY09rZUp1SS9yTit0MnZZb1RkUkc0aHUwWEIzNWY5OEx2VXhBS1k5Qlp2RzMiLCJtYWMiOiJiNzJhOGZjY2MyYjQwN2U0ZjMxY2I0MjQwNjg0ZjNjMWRkODA3MDNlZDZiMzU0ODA5OWUxNGZhNzM0ZDU0NmZkIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 05:21:26 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IjB1TE1HN241U3dWK0Roa05RKzBJN3c9PSIsInZhbHVlIjoiQVh4cFZIYXROQzZSRUt6M2E1QmVqVGhMM0U5MTQ0ZUhLZTVsS05SYy83ZEQwaUtrOUltNUNDWEtmZWpaSGpadWpF ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "1rOCqu5vo8HzuCK2LuWHFM77PNLWaSQWkRHcSUWz"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job000003517"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-15 03:21:26GET/Job000003517311140