Job Seekers, Please send resumes to resumes@hireitpeople.com
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.
