Qualifications:
Need candidates who can come for in-person interview.
- 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.
- Implement 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 vertical database experience.
Should have Bachelor degree and related experience.