*Job Title:* Data Modeler *Location: *Northfield, IL, US
*Duration : **Long Term * *Qualifications:* Job Description: The Sales & Marketing Data Mart project needs a Data Modeler. Looking for someone that has done data modeling for a data warehouse and knows Oracle TCA. The ideal candidate would have the following experience: - 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. - Experience with Oracle TCA. - Working knowledge of EBS Sales and Marketing. - Experience with OBIEE RPD. - 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 data requirement 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 Oracle Data Integrator (ODI) and other tools. - Exceptional communication and presentation skills and established track record of client interactions - Experience in tools like BI APPS 11.1.1.7 components, Data Model, DWH, Informatica, Oracle and custom database. - Highly motivated, detail oriented, has ability to work independently and as a part of the team with excellent technical, analytical, and communication skills - This position requires excellent communication and interpersonal skills *Please send an email If i miss your phone call* *Thanks & Regards**..**..**?* *Nancy* *Technical Recruiter** | Blackapple Solutions LLC* Suite 4, 2 Division Street, Somerville, NJ 08876, U.S.A *Phone: 201-731-2034 X 934* *E-Mail* : [email protected] -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
