Data Warehouse Architect

Tennessee Valley Authority

Contract Chattanooga, Tennessee, United States Posted 7 years ago

 Write a Review Add Vendor   Add Contact  

About Position

Data Warehouse Architect (Contract)

$125.00 / Hourly

Chattanooga, Tennessee, United States

Data Warehouse Architect

Contract Chattanooga, Tennessee, United States Posted 7 years ago

Description

Analyzes business or scientific system specificationsInterface with users/customers to determine scope, business objectives and system requirementsDevelops technical specifications and the technical system designEstablish and design technical framework for systemDesign System components including user interfacesAble to integrate ideas and concepts into architectural designs for complex systemsDefine operational requirements including scheduling, capacity planning, and resource requirementsDefine test environment including development of test casesWork with customers/users to compile data dictionary for the design being implementedMay oversee the technical design of the systemBuilds and tests the application software and integrations and implements it for useDesign data conversion requirementsMay generate executable code based on accepted industry and TVA programming May unit test executable codeMay perform integration testing of executable codeImplement robust error handling and data quality processesDevelop operational proceduresFollows change control procedures and quality assurance standardsMay oversee the building and testing of the proposed systemResponsible for System testingVerification that the system meets all business requirementsVerify all components of the system and interfacing systems work together as designedVerify system will handle volume expected when placed in productionConduct data validation sessions with the customers to verify system resultsPerform system testing and document all resultsReceive approval from user that system is ready for productionStrong analysis and problem solving 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

Tennessee Valley Authority Vendors

CDI Corporation
Write a Review

10 Penn Center
Philadelphia
Pennsylvania
www.cdicorp.com ( 16 vendors)

BIAS Corporation
Write a Review

1100 Abernathy Road NE Suite 1025
Atlanta
Georgia
www.biascorp.com ( No vendors )

Job Summary

$125.00 / Hourly

Contract

Chattanooga, Tennessee, United States

Experience Required : 3 Year/s

Posted : 7 years ago

Deadline : April 21, 2017 7 years ago

Job ID : Job0000008811

Tennessee Valley Authority

400 W. Summit Hill Drive

865-632-2101

www.tva.gov

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.31PHP Version2.47sRequest Duration691MBMemory UsageGET {slug}Route
    • Booting (2.15s)time
    • Application (314ms)time
    • 1 x Booting (87.27%)
      2.15s
      1 x Application (12.73%)
      314ms
      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 executed243ms
      • JobController.php#484clientfyi_final7.73msselect * from `jobs` where `job_slug` = 'Job0000008811' limit 1
        Bindings
        • 0: Job0000008811
        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_final139msselect `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_final570μsselect * from `users` where `users`.`id` = 11496 limit 1
        Bindings
        • 0: 11496
        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_final490μ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` = 11496
        Bindings
        • 0: 1
        • 1: 11496
        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_final720μ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` = 11496 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 11496
        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` = 11496
        Bindings
        • 0: 1
        • 1: 11496
        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.24msselect DISTINCT email from `job_applications` where `category_id` = 40 and `status` = 1
        Bindings
        • 0: 40
        • 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` = 8811 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 8811
        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_final840μ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_final44.45msSELECT 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_final40.29msSELECT 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
          FhYfpFZBSQbnN7HvwttpjPplEGAFaJjHeCVc21Zj
          _previous
          array:1 [ "url" => "https://pingjob.com/Job0000008811" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /Job0000008811
          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 => "13.58.129.138"
  ]
  "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 => "91f76c5e4ab37a44-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "13.58.129.138"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.69.17.84"
  ]
  "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 => "Thu, 13 Mar 2025 00:30:35 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InI1UURHaHM1MGRsNElyWDZuTXlJeGc9PSIsInZhbHVlIjoiUEt5QUxVOEhvazJxZmQwN1RDZUlLMldnYmRJRmZrY1NBQlpuOWU0b3BDMHFvMEQ4U2hmdC9vS2Rwb29vdi8wemJwSFY4eHZzRWJvbzNUdlFkcnVqbklUaWdLb0xsdkhlOXFaUGZEbnpWM3J3ZzNhVmRDbUVNY29McXBtSi9SUUwiLCJtYWMiOiJhODIzNWFmZmRiYTAyZjQwNjllMDFhNzhiNmRiODAzNDBiMDlmYzhhNGMzMTU0YWU2NDgzMzBjYWNkNmZkY2Q0IiwidGFnIjoiIn0%3D; expires=Thu, 13 Mar 2025 02:30:35 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InI1UURHaHM1MGRsNElyWDZuTXlJeGc9PSIsInZhbHVlIjoiUEt5QUxVOEhvazJxZmQwN1RDZUlLMldnYmRJRmZrY1NBQlpuOWU0b3BDMHFvMEQ4U2hmdC9vS2Rwb29vdi8wemJwSFY4e ▶"
    1 => "laravel_session=eyJpdiI6Ik9zb1lNRTQzZjJPSmlYVDlUUlZkQlE9PSIsInZhbHVlIjoiNkFnUTVDbVNmZkMwNE1WQ0ZMUFJTZVA3MXNNemRJU2NGMjhySytjVy9VMUpSZFdrd1FrajdCRjl2YXdweGlydGYxaXdXaE1SYlI2Q1hmOHpTQkJtby9ycVZIbFdOL2RwUzJSd1VsR3Rlbjl5bi93NlNmdkF3eFdSSGlWNVZzdU8iLCJtYWMiOiIzN2M0MjMyYzk1NzVhMjYzZGM5Yzk4M2I2MmU2MTY3YjU3YzRlMzc5NGI2NGNiY2RjZjE5MWNhZGVjMWVjMzBjIiwidGFnIjoiIn0%3D; expires=Thu, 13 Mar 2025 02:30:35 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ik9zb1lNRTQzZjJPSmlYVDlUUlZkQlE9PSIsInZhbHVlIjoiNkFnUTVDbVNmZkMwNE1WQ0ZMUFJTZVA3MXNNemRJU2NGMjhySytjVy9VMUpSZFdrd1FrajdCRjl2YXdweGlydGYx ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InI1UURHaHM1MGRsNElyWDZuTXlJeGc9PSIsInZhbHVlIjoiUEt5QUxVOEhvazJxZmQwN1RDZUlLMldnYmRJRmZrY1NBQlpuOWU0b3BDMHFvMEQ4U2hmdC9vS2Rwb29vdi8wemJwSFY4eHZzRWJvbzNUdlFkcnVqbklUaWdLb0xsdkhlOXFaUGZEbnpWM3J3ZzNhVmRDbUVNY29McXBtSi9SUUwiLCJtYWMiOiJhODIzNWFmZmRiYTAyZjQwNjllMDFhNzhiNmRiODAzNDBiMDlmYzhhNGMzMTU0YWU2NDgzMzBjYWNkNmZkY2Q0IiwidGFnIjoiIn0%3D; expires=Thu, 13-Mar-2025 02:30:35 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InI1UURHaHM1MGRsNElyWDZuTXlJeGc9PSIsInZhbHVlIjoiUEt5QUxVOEhvazJxZmQwN1RDZUlLMldnYmRJRmZrY1NBQlpuOWU0b3BDMHFvMEQ4U2hmdC9vS2Rwb29vdi8wemJwSFY4e ▶"
    1 => "laravel_session=eyJpdiI6Ik9zb1lNRTQzZjJPSmlYVDlUUlZkQlE9PSIsInZhbHVlIjoiNkFnUTVDbVNmZkMwNE1WQ0ZMUFJTZVA3MXNNemRJU2NGMjhySytjVy9VMUpSZFdrd1FrajdCRjl2YXdweGlydGYxaXdXaE1SYlI2Q1hmOHpTQkJtby9ycVZIbFdOL2RwUzJSd1VsR3Rlbjl5bi93NlNmdkF3eFdSSGlWNVZzdU8iLCJtYWMiOiIzN2M0MjMyYzk1NzVhMjYzZGM5Yzk4M2I2MmU2MTY3YjU3YzRlMzc5NGI2NGNiY2RjZjE5MWNhZGVjMWVjMzBjIiwidGFnIjoiIn0%3D; expires=Thu, 13-Mar-2025 02:30:35 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ik9zb1lNRTQzZjJPSmlYVDlUUlZkQlE9PSIsInZhbHVlIjoiNkFnUTVDbVNmZkMwNE1WQ0ZMUFJTZVA3MXNNemRJU2NGMjhySytjVy9VMUpSZFdrd1FrajdCRjl2YXdweGlydGYx ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "FhYfpFZBSQbnN7HvwttpjPplEGAFaJjHeCVc21Zj"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/Job0000008811"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-03-13 00:30:35GET/Job0000008811311140