Location: Augusta,ME, USA
Title: Data Warehouse Engineer
Location: Hybrid, Augusta, Maine
Contract W2
Note: Only USC/GC candidates are accepted.
Responsibilities:
​Develop, monitor, and maintain a variety of automated DB processes. - Research and resolve database issues as they arise. - This individual will be assigned a variety of database management and maintenance tasks. - Serve as a trusted technical advisor and will serve as a technical mentor to other IT staff. - Collaborate with other developers, analysts, and DBAs. - Work closely with IT vendors, IT leadership, and business partners. - Play a key role in upcoming system migrations, system expansions, and data modernization efforts.
Top 3 Skills:
Developing automated ETL Designing & Implementing Enterprise-class data repositories built upon Oracle on-prem and cloud-hosted databases
Expertise in dimensional modeling and ability to act as a technical mentor
Requirements:-
Extensive practical experience with the modern Oracle platforms and technologies.
This includes the following:
Significant senior DBA-level experience with regards to designing and implementing enterprise-class data repositories built upon Oracle on-prem and cloud-hosted databases.
Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.
Practical experience utilizing API calls for automated data refreshes.Practi
cal experience with Oracle Analytics Cloud (OAC)
Mastery of SQL and PL/SQL and the ability to develop complex procedures, functions, views, and scripts.
Expertise in dimensional modeling.
Experience with tabular data models.