Application Architect (Data warehouse)

Aetna Inc

Contract Hartford, Connecticut, United States Posted 6 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Application Architect (Data warehouse) (Contract)

$70.00 / Hourly

Hartford, Connecticut, United States

Application Architect (Data warehouse)

Contract Hartford, Connecticut, United States Posted 6 years ago

Description

Skills & Responsibilities APPLICATION ARCHITECT INFORMATICS candidate must have design and architecture experience with DATA WAREHOUSE, ETL and BUSINESS INTELLIGENCE and experience with LARGE DATABASES and a grasp of general Design Patterns and industry standard architectural principles related to data warehouse environments. Practical knowledge of DataStage and Business Objects is a plus, but not required. Conceptual knowledge of UML techniques and RSM tool is desired, but not required. Candidate should demonstrate knowledge of data integration, data mapping, and data conformance conceptually. Knowledge of key architectural principles surrounding data warehousing are required. Experience architecting, developing, deploying and supporting large scale computing applications across multiple operating systems, languages, and vendor middleware is necessary. Proven project experience and ability to lead a group through an architectural development process and collaborate with application development teams, architects, Business and other project constituents. Ability to discover and define technical requirements and their relationship to functional requirements and to determine the adequacy of documented requirements for architecture definition. Healthcare or Insurance/Financial services industry knowledge is preferred, but not required. Medical Management experience is a plus. Strong business/technology decision making skills. Prior experience in a technical leadership role. Outstanding written and verbal communication skills, Strong leadership skills to effectively influence decisions and positively impact progress

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

Aetna Inc Vendors

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

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

Cognizant Technology Solutions Corporation
Write a Review

500 Frank W. Burr Boulevard
Teaneck
New Jersey
www.Cognizant.com ( 50 vendors)

NTT DATA Inc
Write a Review

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

Job Summary

$70.00 / Hourly

Contract

Hartford, Connecticut, United States

Experience Required : 8 Year/s

Posted : 6 years ago

Deadline : September 22, 2018 6 years ago

Job ID : Job0000014445

Aetna Inc

151 Farmington Avenue

860-273-0123

www.aetna.com

Request history8.1.31PHP Version2.62sRequest Duration687MBMemory UsageGET {slug}Route
    • Booting (2.35s)time
    • Application (276ms)time
    • 1 x Booting (89.46%)
      2.35s
      1 x Application (10.54%)
      276ms
      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 executed206ms
      • JobController.php#484clientfyi_final13.64msselect * from `jobs` where `job_slug` = 'Job0000014445' limit 1
        Bindings
        • 0: Job0000014445
        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_final89.41msselect `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_final690μsselect * from `users` where `users`.`id` = 161 limit 1
        Bindings
        • 0: 161
        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_final790μ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` = 161
        Bindings
        • 0: 1
        • 1: 161
        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.64msselect `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` = 161 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 161
        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_final440μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 161
        Bindings
        • 0: 1
        • 1: 161
        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.98msselect DISTINCT email from `job_applications` where `category_id` = 71 and `status` = 1
        Bindings
        • 0: 71
        • 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_final420μsselect * from `comments` where `comments`.`commentable_type` = 'App\\Models\\Job' and `comments`.`commentable_id` = 14445 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 14445
        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.48msSELECT 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_final42.53msSELECT 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
          SY2sOc7qjnj3fRWvpvZul6pnqLj3h1C1gK3Df55m
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000014445" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000014445
          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 => "18.191.122.218" ] "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 => "917d02f85ed21134-ORD" ] "connection" => array:1 [ 0 => "close" ] "x-accel-internal" => array:1 [ 0 => "/internal-nginx-static-location" ] "x-forwarded-for" => array:1 [ 0 => "18.191.122.218" ] "x-real-ip" => array:1 [ 0 => "172.69.59.156" ] "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, 26 Feb 2025 03:57:35 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjhjOTliWjZJdGZRcXRMWTlyd091WVE9PSIsInZhbHVlIjoiSUZEN3RJd2RQTm9qYVNxRFl3NUdyS2pnN0JiNWx4Y3VoK0V1Y3MzekJCeXY3R3hoNjQrbGk4UmptV1d3czljamt2NGUvUWl5bDdpTUphbnNHb2VhSGJYSVc5NFRUWVoxRDl5UjFXOUhHSlBSUUQzdGcvOXUzamIvR3kxOXVYTU8iLCJtYWMiOiI3MDg1YTQ3MDE4OTQ1ZjJkYjVhYjc2ZGU3ZTgyODJiNzM3NDgyMGQ3NzJjNjI5OTJkMjQ4YzVjMDEwZmQ5MTc0IiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 05:57:35 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IjhjOTliWjZJdGZRcXRMWTlyd091WVE9PSIsInZhbHVlIjoiSUZEN3RJd2RQTm9qYVNxRFl3NUdyS2pnN0JiNWx4Y3VoK0V1Y3MzekJCeXY3R3hoNjQrbGk4UmptV1d3czljamt2NGUvU" 1 => "laravel_session=eyJpdiI6IllFdlJvZldRUDJyTjZrZjliRlBldUE9PSIsInZhbHVlIjoiVU0zY3BuRXk3Z0lmWWlsNzk2WnFUYlRRMGNVOVNLeUhUMjltdkIzRk16NXlOUEVPdG1VZkFFQ0JTeTFrazRvaW83S253QUd4S0Q2TCt3TnVjYm12ZCtyMXRqdVVWbDFsT05iUHVtcnJkZVhJRllLWXp1RzA5UjVFa0pwZWVhQi8iLCJtYWMiOiJmYmZiM2JmMzhlNTgzNmQ0YzE5OGQ4YmQ4ZDBlMTU3ZTgxMWI5NzYzZGY2MmQxNGU4NmYxODRhMmQ3MzVjYmY3IiwidGFnIjoiIn0%3D; expires=Wed, 26 Feb 2025 05:57:35 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6IllFdlJvZldRUDJyTjZrZjliRlBldUE9PSIsInZhbHVlIjoiVU0zY3BuRXk3Z0lmWWlsNzk2WnFUYlRRMGNVOVNLeUhUMjltdkIzRk16NXlOUEVPdG1VZkFFQ0JTeTFrazRvaW83" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IjhjOTliWjZJdGZRcXRMWTlyd091WVE9PSIsInZhbHVlIjoiSUZEN3RJd2RQTm9qYVNxRFl3NUdyS2pnN0JiNWx4Y3VoK0V1Y3MzekJCeXY3R3hoNjQrbGk4UmptV1d3czljamt2NGUvUWl5bDdpTUphbnNHb2VhSGJYSVc5NFRUWVoxRDl5UjFXOUhHSlBSUUQzdGcvOXUzamIvR3kxOXVYTU8iLCJtYWMiOiI3MDg1YTQ3MDE4OTQ1ZjJkYjVhYjc2ZGU3ZTgyODJiNzM3NDgyMGQ3NzJjNjI5OTJkMjQ4YzVjMDEwZmQ5MTc0IiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 05:57:35 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IjhjOTliWjZJdGZRcXRMWTlyd091WVE9PSIsInZhbHVlIjoiSUZEN3RJd2RQTm9qYVNxRFl3NUdyS2pnN0JiNWx4Y3VoK0V1Y3MzekJCeXY3R3hoNjQrbGk4UmptV1d3czljamt2NGUvU" 1 => "laravel_session=eyJpdiI6IllFdlJvZldRUDJyTjZrZjliRlBldUE9PSIsInZhbHVlIjoiVU0zY3BuRXk3Z0lmWWlsNzk2WnFUYlRRMGNVOVNLeUhUMjltdkIzRk16NXlOUEVPdG1VZkFFQ0JTeTFrazRvaW83S253QUd4S0Q2TCt3TnVjYm12ZCtyMXRqdVVWbDFsT05iUHVtcnJkZVhJRllLWXp1RzA5UjVFa0pwZWVhQi8iLCJtYWMiOiJmYmZiM2JmMzhlNTgzNmQ0YzE5OGQ4YmQ4ZDBlMTU3ZTgxMWI5NzYzZGY2MmQxNGU4NmYxODRhMmQ3MzVjYmY3IiwidGFnIjoiIn0%3D; expires=Wed, 26-Feb-2025 05:57:35 GMT; path=/; httponlylaravel_session=eyJpdiI6IllFdlJvZldRUDJyTjZrZjliRlBldUE9PSIsInZhbHVlIjoiVU0zY3BuRXk3Z0lmWWlsNzk2WnFUYlRRMGNVOVNLeUhUMjltdkIzRk16NXlOUEVPdG1VZkFFQ0JTeTFrazRvaW83" ] ]
          session_attributes
          0 of 0
          array:3 [ "_token" => "SY2sOc7qjnj3fRWvpvZul6pnqLj3h1C1gK3Df55m" "_previous" => array:1 [ "url" => "https://pingjob.com/Job0000014445" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-02-26 03:57:35GET/Job0000014445311140