Job Description

Title: Data Warehouse Engineer (Contract) - Job#5350

Location: Hybrid, Augusta, Maine

Job Type : Contract

Our client in Augusta, Maine is looking for a Data Warehouse Engineer to join their team. This individual will serve as a daily subject-matter expert for all Oracle technologies and toolsets. Much of the work will focus on data modeling and developing automated ETL processes that pull data from a variety of data sources.

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.

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.
• Practical 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.
• Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust, performant, scalable, reliable, and expandable.
• Demonstrates a disciplined approach to process and error logging.
• Maintains excellent work habits when it comes to coding comments, system documentation, and metadata creation.
• Ability to serve as a technical mentor to both senior and junior IT staff.
• Ability to develop architectural diagrams and system documentation, and train others on the content.
• Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.
• Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.

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

Avinash Kumar Sr. IT Recruiter

Email- [email protected]

Phone Number : +1 321 7856 062

STELLENT IT A Nationally Recognized Minority Certified Enterprise

" Happiness can be found, even in the darkest of times, if one only remembers to turn on the light ."
- JK Rowling

Job Tags

Similar Jobs