Data Warehouse Architect Oracle - REMOTE PST

Data Warehouse Architect (Oracle)

Location Can work anywhere from the US but must work PST time zone

Duration Months

Day to day tasks

• Develop database solutions to store and retrieve company information
  
• Install and configure information systems to ensure functionality
  
• Analyze structural requirements for new software and applications
  
• Design conceptual and logical data models and flowcharts
  
• Improve system performance by conducting tests troubleshooting and integrating new elements
  
• Optimize new and current database systems
  
• This resource will be very hands on
  
• Must be able to set automations using power apps 
  

Required  years of working experience with Oracle in the field

Ideal experience

• ATL experience switches circuit breakers ect
  
• ETL knowledge Must have experience with
  
• Oracle DW Oracle C
  
• ODI Oracle Data Integrator
  
• SQL and PSQL
  
• SQL Server
  
• SSIS to push data into Oracle D
  
• MUST HAVE great Power BI experience Ideally years of POWER APPS
  

First Project OBI Metadata Improvement (this is the project currently being completed)

Purpose of this phase to identify the processes within PG&E and build those out for others who want to understand and learn them

• Phase
  
• Identify where to save the details/definitions
  
• Populate the details for all databases with relevant details
  
• Phase
  
• Identify which applications are accessing which data from which databases and the data flow
  
• Identify tool/system to capture this information
  
• Populate this data in the identified system/tool
  
• Building out Pivot Tables and Databases