portal resources jobs companies i it data solutions oracle business intelligence developer

oracle Business Intelligence Developer 🔥


Title: Oracle Business Intelligence Developer

Location: 100% Remote

Duration: 6 Month Contract

Client: Federal Government Agency

Rate: Depends on Experience

Task Order: 2022-10

Must be able to pass a full background check

Qualifications:

  • Support for the complete OBIA upgrade from 11.1.10.2. to 11.1.1.10.3
  • Support the upgrade process for development, test, user acceptance testing, and production environments
  • Fix any issues with the HR analytics interface
  • Validate, test and fix any errors of the ODI ETL errors from source to target migration
  • Support the migration ODI packages from one environment to another
  • Strong experience in Project methodologies, Agile, SDLC, DW and BI infrastructure and architecture using middleware OBIEE, OBIA, data loading, schedule and monitor workflows/jobs, and dimensional modelling using Star schema in Data warehouse life cycle.
  • Hands on experience on metadata modeling Architecting BI/DW projects, configuring Data Warehouse Administration Console (DAC), Informatica ETL Process and a technocrat with expertise in systems design, implementation, and testing.
  • Responsible for the delivery of the DW/BI project and developing the solution architecture for the project.
  • Coordinate with the implementation partner and business functions to finalize the requirements and deliver them in a timely manner
  • Responsible for setting up the necessary infrastructure for the project and coordinating with various departments in IT for the interfacing requirements for developing the necessary extractions from source systems.
  • Hands-on experience in using SQL, PL/SQL, Oracle Stored Procedures, Packages and Object types to meet data integration and processing requirements.
  • Experience in handling Third party tools such as SQL Developer, SQL*Loader and Toad.
  • Knowledge on database design – Creation of data model, Tables, Indexes, Views, Materialized views, Synonyms, Sequences for better performance of the database.
  • Has Good knowledge on Oracle Data integrator, Oracle ADF and BI Publisher.
  • Leveraging BI Server Caching to get most benefits out of the Cached queries and return the same result without hitting the database multiple times.
  • Removing Snowflake across dimensions and create the Foreign Key for each Dimension into Fact to create Star model, where applicable
  • Applying Bitmap Index for all Foreign Key columns, and Bitmap Join Index
  • Ensuring that the RPD is in sync with the database to avoid full outer joins
  • Optimizing setting of NQSConfig.INI parameters such as sort memory size, sort buffer increment size, etc.
  • Managing optimally some key values like maximum session limit, and database and server execution
  • Fluency in SQL and dimensional modeling concepts
  • 7+ years of experience in Oracle Fusion Middleware Administration
  • Middleware Certification is preferred
  • Ability to work closely with business partners, TS, and project manager
  • Possess strong oral and written communication skills

About IT Data:

Since 2005, IT Data Solutions has been providing focused management consulting services specializing in Information Technology (IT) solutions and tools for large private and public sector clients. We specialize in Advisory, Analytics, Audio/Video Design and Implementation, Augmented/Virtual Reality, Cybersecurity, Human Capital Solutions, Managed Services, and Robotic Process Automation (RPA). We turn big data into actionable intelligence to help reach your mission objectives. Our IT data solutions help you to increase efficiencies, reduce costs, and streamline processes.

We are an Equal Opportunity Employer.

Job Category: Information Technology Job Type: 6 Month Contract Job Location: REMOTE

Let us send you new openings similar to oracle Business Intelligence Developer straight to your Inbox. Weekly or Daily. 7-day free trial 💌

The ability to work remotely increases employee happiness by 20 percent.