Oracle Business Intelligence Developer

OBIA, Agile, Project methodologies, Informatica, ETL, PL/SQL, Oracle, SQL Developer, SQL*Loader, Toad, Oracle Business Intelligence Developer
Contract W2, 12 Months
Depends on Experience
Work from home available

Job Description

Top Required Skills:
OBIEE Consultant shall have experience in:
• Support for the complete OBIA upgrade from
• 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
NOTE: Authorized to work within the United States
Interview: Selected candidates will participate in WebEx/MS Teams interviews
Karunish lal
Leading Edge Systems Richmond, Inc
Dice Id : lesr
Position Id : 2021-14
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

Lead SQL Developer / Lead Database Developer
  • Creative IT Inc
  • Fairfax, VA, USA
Senior Java Developer
  • Epic Systems, Inc,
  • Arlington, VA, USA
Senior Oracle DBA
  • E-Business International, Inc.
  • Suitland-Silver Hill, MD, USA
Informatica ETL Developer with Curam
  • MSYS Inc.
  • Washington, DC, USA
Sr Informatica ETL Developer (2 openings) (Min 11 years of exp) (Webcam interviews)
  • Advanced American Technologies, Inc
  • Washington, DC, USA
Production Support Engineer / Ashburn, Virginia
  • Intone Networks Inc.
  • Ashburn, VA, USA
Data Migration Analyst
  • ALTA IT Services
  • Woodlawn, MD, USA
System Analyst
  • ALTA IT Services
  • Woodlawn, MD, USA
React/Java Developer
  • Eliassen Group
  • Rockville, MD, USA