Oracle Data Warehouse Architect with Snowflake

DIRECTV Inc

Contract Dallas , Texas, United States Posted 1 month ago

 Write a Review Add Vendor   Add Contact  

About Position

Oracle Data Warehouse Architect with Snowflake (Contract)

$90.00 / Hourly

Dallas , Texas, United States

Oracle Data Warehouse Architect with Snowflake

Contract Dallas , Texas, United States Posted 1 month ago

Skills
Minimum of 7-10 years of experience in data warehousing and data architecture. Extensive experience with Oracle databases and Snowflake data warehousing solutions. Proven experience with ETL tools and processes. Strong background in integrating data warehouses with analytics tools such as Oracle Analytics Power BI Tableau etc. Proficient in SQL and PL/SQL. Deep understanding of data modeling concepts and best practices. Experience with cloud-based data warehousing solutions. Familiarity with big data technologies and frameworks is a plus.
Description

We are seeking an experienced Oracle Data Warehouse Architect with a strong background in Snowflake and various analytics tools.
The ideal candidate will be responsible for architecting and designing data warehouse solutions that support our business intelligence and analytics needs.
This role requires a deep understanding of data architecture and warehousing principles, data modeling, ETL processes, and proficiency in Oracle and Snowflake environments.

Responsibilities
  • Data Warehouse Architecture: Design, develop, and maintain scalable data warehouse solutions using Oracle and Snowflake.
  • Data Modeling: Create and optimize logical and physical data models for data warehousing and analytics purposes.
  • ETL Processes: Develop, implement, and manage ETL processes to ensure accurate and timely data integration from various sources.
  • Performance Optimization: Monitor and optimize data warehouse performance, ensuring high availability and scalability.
  • Analytics Tools Integration: Integrate data warehouse solutions with various analytics tools (e.g., Oracle Analytics, Power BI, Tableau etc) to support business intelligence initiatives.
  • Data Governance: Implement data governance and best practices to ensure data quality, consistency, and security.
  • Collaboration: Work closely with business stakeholders, data analysts, and other IT teams to understand data requirements and deliver effective solutions.
  • Documentation: Maintain comprehensive documentation of data architecture, models, processes, and configurations.

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

DIRECTV Inc Vendors

( Login to see all the 10 vendors)
IBM Corporation
Write a Review

1133 Westchester Avenue
White Plains
New York
www.ibm.com/us ( 130 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)

Job Summary

$90.00 / Hourly

Contract

Dallas , Texas, United States

Experience Level : Medium

Experience Required : 9 Year/s

Only Any

Posted : 1 month ago

Deadline : February 20, 2025 1 month ago

Job ID : Job0000008071

DIRECTV Inc

P.O. Box 6550

www.DIRECTV.com

Share by E-Mail

Check all jobs of this employer

Flag this job

MessagesTimelineExceptionsViews3RouteQueries11Models140MailsGateSessionRequest
Request history8.1.32PHP Version2.56sRequest Duration695MBMemory UsageGET {slug}Route
    • Booting (2.22s)time
    • Application (339ms)time
    • 1 x Booting (86.78%)
      2.22s
      1 x Application (13.22%)
      339ms
      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 executed261ms
      • JobController.php#484clientfyi_final8.06msselect * from `jobs` where `job_slug` = 'oracle-data-warehouse-architect-with-snowflake' limit 1
        Bindings
        • 0: oracle-data-warehouse-architect-with-snowflake
        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_final94.13msselect `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` = 1667 limit 1
        Bindings
        • 0: 1667
        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_final670μ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` = 1667
        Bindings
        • 0: 1
        • 1: 1667
        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.61msselect `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` = 1667 order by `vendor_count` desc limit 3 offset 0
        Bindings
        • 0: 1
        • 1: 1667
        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_final380μsselect (sum(ratings)/count(id)) AS review_rating, count(id) as review_count from `reviews` where `approve_status` = 1 and `employer_id` = 1667
        Bindings
        • 0: 1
        • 1: 1667
        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.85msselect DISTINCT email from `job_applications` where `category_id` = 187 and `status` = 1
        Bindings
        • 0: 187
        • 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` = 8071 and `comments`.`commentable_id` is not null and `parent_id` is null
        Bindings
        • 0: App\Models\Job
        • 1: 8071
        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_final970μ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_final69.36msSELECT 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_final76.31msSELECT 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
          AzZbxaQam2SOqQuJsDGYNRasSwzgQUwfn78KF5wU
          _previous
          array:1 [ "url" => "https://pingjob.com/oracle-data-warehouse-architect-with-snowflake" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          path_info
          /oracle-data-warehouse-architect-with-snowflake
          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:18 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "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"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.118.218.112"
  ]
  "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 => "Fri, 18 Apr 2025 04:36:03 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkU3aWw4NjJhbG1BbnFxQ0ptYVZSRmc9PSIsInZhbHVlIjoiSHc0Nnc1bXRJNmsyVmVWQkN0ZElVNFN1bFhLK1lTdS9vSlZHNmc1TTFzcTNBaWQyKzZkMEV4b3VZQ3ZxTjRXMzMxcUdQZzhtMzNHZ3RMZjJBb243Ym5EbkVJYzgvOWJidS9RZVBjMWpJN2p0a0dpU3NXZ0I5aGEwUDl5SlU2dm4iLCJtYWMiOiJlYTliZGUxZGZkYjNlOGQyNTAyMmNiZWI4MDFmYWYzZjY0ODE2M2I4OTc0YTRmYTgyMGMxM2UzYTgxOWY4Y2E1IiwidGFnIjoiIn0%3D; expires=Fri, 18 Apr 2025 06:36:03 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkU3aWw4NjJhbG1BbnFxQ0ptYVZSRmc9PSIsInZhbHVlIjoiSHc0Nnc1bXRJNmsyVmVWQkN0ZElVNFN1bFhLK1lTdS9vSlZHNmc1TTFzcTNBaWQyKzZkMEV4b3VZQ3ZxTjRXMzMxcUdQZ ▶"
    1 => "laravel_session=eyJpdiI6Ikw0R3JqM3h6a3E3L0dYV2VpMGRRSmc9PSIsInZhbHVlIjoiRTRMME5vYUVYRXYxNnZQaFBTSnplRW5kMzJxRmo4VENFbHFIcHZXc3R5UE13Uk5iMTRtMG1HZEhaRXFzYmtxNmpDTXAwMXVNV2FaR0VZVkQ4T3RZZlo0VFZwd3pSbHJQWGRrQUpKWHhmRGx4b0VjS0J5MUQ1YysrTnNxWGZ4cGkiLCJtYWMiOiI4YmY4NWU2OWY1NjMzYTFlOTBkYjZmNjlhM2Q1YWUwNGU2NmQ2ZTRlY2VjNDhmNDFlZDkyMzgwZmQ2YzAyNWJjIiwidGFnIjoiIn0%3D; expires=Fri, 18 Apr 2025 06:36:03 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ikw0R3JqM3h6a3E3L0dYV2VpMGRRSmc9PSIsInZhbHVlIjoiRTRMME5vYUVYRXYxNnZQaFBTSnplRW5kMzJxRmo4VENFbHFIcHZXc3R5UE13Uk5iMTRtMG1HZEhaRXFzYmtxNmpD ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkU3aWw4NjJhbG1BbnFxQ0ptYVZSRmc9PSIsInZhbHVlIjoiSHc0Nnc1bXRJNmsyVmVWQkN0ZElVNFN1bFhLK1lTdS9vSlZHNmc1TTFzcTNBaWQyKzZkMEV4b3VZQ3ZxTjRXMzMxcUdQZzhtMzNHZ3RMZjJBb243Ym5EbkVJYzgvOWJidS9RZVBjMWpJN2p0a0dpU3NXZ0I5aGEwUDl5SlU2dm4iLCJtYWMiOiJlYTliZGUxZGZkYjNlOGQyNTAyMmNiZWI4MDFmYWYzZjY0ODE2M2I4OTc0YTRmYTgyMGMxM2UzYTgxOWY4Y2E1IiwidGFnIjoiIn0%3D; expires=Fri, 18-Apr-2025 06:36:03 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IkU3aWw4NjJhbG1BbnFxQ0ptYVZSRmc9PSIsInZhbHVlIjoiSHc0Nnc1bXRJNmsyVmVWQkN0ZElVNFN1bFhLK1lTdS9vSlZHNmc1TTFzcTNBaWQyKzZkMEV4b3VZQ3ZxTjRXMzMxcUdQZ ▶"
    1 => "laravel_session=eyJpdiI6Ikw0R3JqM3h6a3E3L0dYV2VpMGRRSmc9PSIsInZhbHVlIjoiRTRMME5vYUVYRXYxNnZQaFBTSnplRW5kMzJxRmo4VENFbHFIcHZXc3R5UE13Uk5iMTRtMG1HZEhaRXFzYmtxNmpDTXAwMXVNV2FaR0VZVkQ4T3RZZlo0VFZwd3pSbHJQWGRrQUpKWHhmRGx4b0VjS0J5MUQ1YysrTnNxWGZ4cGkiLCJtYWMiOiI4YmY4NWU2OWY1NjMzYTFlOTBkYjZmNjlhM2Q1YWUwNGU2NmQ2ZTRlY2VjNDhmNDFlZDkyMzgwZmQ2YzAyNWJjIiwidGFnIjoiIn0%3D; expires=Fri, 18-Apr-2025 06:36:03 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ikw0R3JqM3h6a3E3L0dYV2VpMGRRSmc9PSIsInZhbHVlIjoiRTRMME5vYUVYRXYxNnZQaFBTSnplRW5kMzJxRmo4VENFbHFIcHZXc3R5UE13Uk5iMTRtMG1HZEhaRXFzYmtxNmpD ▶"
  ]
]
          session_attributes
            0 of 0   
          array:3 [▼
  "_token" => "AzZbxaQam2SOqQuJsDGYNRasSwzgQUwfn78KF5wU"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/oracle-data-warehouse-architect-with-snowflake"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-18 04:36:03GET/oracle-data-warehouse-architect-with-snowflake311140