Data Modeler/Business Intelligence Columbus, OH - Candidate MUST Be LOCAL to OH
6-12 Months Contract *Kindly Reply on: lisa.d...@itbtalent.com <lisa.d...@itbtalent.com> * Candidate will have to interview in person. Required Skills Most importantly the candidate must be proficient in data modeling/designing dimensional/starschema data structures including fact tables. To be proficient the candidate should have consistently spent 5 or more years analyzing, designing and modeling star-schema database designs using the AllFusion Erwin data modeling tool/Model Mart repository in a data warehouse environment. Minimum 10 years Experience working as a data modeler in business intelligence, analytics and Enterprise Data Warehouseing environments Minimum 10 years Experience with design, development and support of normalized data structures (commonly referred to as Inmon) Minimum 7 years Experience developing Data Warehouse databases using Oracle RDBMS platform and tools Minimum 5 years Experience with Kimball (Dimensional Modeling) and Inmon methodologies 5 years experience with the AllFusion Erwin modeling tool (7.3, 8 and 9.0.0), including Model Mart Repository advanced features (e.g. check in/out, complete compare, naming standards and reverse engineering) Minimum 5 years Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another Minimum 5 years Experience with Data Warehouse tools and techniques (ETL tools, STAR schemas, etc.) Minimum 5 years Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design. Minimum 5 years Strong Data Modeling skills to include data quality, source systems analysis (DB2, Oracle, VSAM , etc) business rules validation, source to target mapping design, prepare sample data example and data validation with ETL team (SCD 1, SCD 2 types tables and Fact tables) Minimum 5 years Software development experience with Oracle RDBMS 11g/12c, DB2, and/or Vertica Minimum 5 years Software development experience with SQL Minimum 3 years Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, PowerPoint, Visio, Clarity) Minimum 1 years Experience performing peer reviews Minimum 4 years Ability to effectively communicate with business and IT staff Minimum 1 years Ability to quickly adapt to changes, enhancements, and new technologies Minimum 2 years Ability to establish and maintain positive collaborative relationships with team members Minimum 2 years High energy levels and tolerance for tight deadlines and time pressures Nice to Have: Experience with Alternative Modeling (Data Vault, Anchor Modeling, Focal Point, etc.) Experience with R Experience with Data Virtualization Technologies *Regards,* *Lisa DuttDesk No # 609-935-3773 EXT 102 * * Email : lisa.d...@itbtalent.com <lisa.d...@itbtalent.com>* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.