Oracle BI Architect

Job Description
  • Min 8-10 years of experience in Information Technology with
    Expertise in Data modeling for Data Warehouse/Data Mart development,
    Data Analysis for Online Transaction Processing (OLTP) and Data
    Warehousing (OLAP)/Business Intelligence (BI) applications.
  • Should
    have exposure in overall SDLC including requirement gathering,
    development, testing, debugging, deployment, documentation, production
    support and Extensive experience in Project Management methodologies,
    oracle database management, OBIEE.
  • Should have experience in
    various projects related Data Modeling, System/Data Analysis, Design and
    Development for both OLTP and Data warehousing environments.
  • Facilitate datarequirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
  • Extensive work experience on BI APPS in several projects in both OLAP and OLTP applications.
  • Practical
    understanding of the Data modeling (Dimensional & Relational)
    concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and
    Dimension tables.
  • Comprehensive knowledge and experience in process improvement,
    normalization/de-normalization, data extraction, data cleansing, data manipulation.
    Implemente experience on Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
  • Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
  • Experience with logical and physical database models
  • Familiarity
    and experience in the work environment consisting of Business analysts,
    Production Support teams, Subject Matter Experts, Database
    Administrators and Database developers.
  • Experience in
    extracting, transforming and loading (ETL) data from spreadsheets,
    database tables and other sources using Informatica and other tools.
  • Exceptional communication and presentation skills and established track record of client interactions
  • Experience in tools like BI APPS 7.9.6.x components, Data Model, DWH, Informatica, Oracle and custom database.
  • Good to have vertica database experience.
  • Should have Bachelor degree and related experience
Key Skill(s)
Bi
About Company
About Organisation:

NTT DATA Inc.NTT DATA is a Global IT Innovator delivering technology-enabled services and solutions to clients around the world and is part of the NTT Group - a Fortune 29 Global IT & Telecom services company. The company provides consulting, managed services, projects, outsourcing, and cloud-based solutions to mid-size and large enterprises in all major industries. We operate with over 57,000 professionals in more than 35 countries with corporate headquarters in Tokyo. Collectively, the integrated company generates $14B in annual revenues and is currently the 8th largest global IT services provider . Every day around the world we help clients explore new ways to respond to market dynamics with flexibility and speed, reduce costs with less risk, and increase productivity to enable growth.
At NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees have been key factors in our company"s growth and market presence. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA and for the people who work here.