Oracle Fusion Analytics Warehouse Administrator/Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Oraapps Inc, is seeking the following. Apply via Dice today!

Job Title - Oracle Fusion Analytics Warehouse Administrator/Developer

Contract Duration - 6+ Months

Location - Remote

Responsibilities:

Support of FAW Operations including monitoring & troubleshooting issues.Creation tables, views, & stored procedures as directed. Identify and test for bugs and bottlenecks in the environment.Adhere to and develop Standard Operating Procedures including those in support of FAW Standards and Change Control processes. Working closely with the EDA team ensure proper data governance and quality systems are in place. Combine ADW with Oracle out of the box content to create reporting models.Support the Oracle Patch release cycle ensuring continuous operations with limited impact to the environment. Collaborate with stakeholders to understand analytical needs and translate them into technical requirements.Ensure data integrity, security, and optimal performance within the Oracle Fusion Analytics Warehouse environment.Conduct performance tuning, troubleshooting, and optimization of database queries and processes.Stay updated with industry trends and best practices in data warehousing, analytics, and Oracle Fusion technologies.

Requirements:

Bachelor s degree in computer science or related field and 7-10 years of relevant work experience or equivalent combination of education and IT work experience with in-depth knowledge with Oracle Fusion Products with an emphasis on FAW development and Support.Certifications (or relevant course work if no certification available) in Oracle Fusion Technologies.Data Warehouse Operations Support experience5+ years of experience working with Oracle Fusion technologies, including Oracle Fusion Analytics Warehouse, Oracle Data Integrations Services, and Oracle Integration Cloud.Proficiency in Oracle SQL, PL/SQL, and data modeling tools.Strong understanding of cloud-based data warehousing concepts, methodologies, and best practices.Strong SQL Scripting skills

Additional knowledge, skills, and abilities:

Demonstrated knowledge or skills in interfacing with end users.Advanced troubleshooting techniques and software design.Ability to work well with others.Ability to listen and communicate well in English both verbally and in writing.Excellent knowledge of MS Word, Outlook, PowerPoint, Excel.Ability to multi-task.Ability to work independently.Attention to detail and accuracy.

Key Skills

• SQL