In person interview is needed directly with top 3 candidates. Interview Dates scheduled for April 2 & 3, 2015.
Location: Columbus, OH Duration: 3+ months Rate: Open This position will be responsible for taking requirements and designing, creating, tuning and supporting Oracle Data Warehouse databases. . Experience working as a data modeler in business intelligence, analytics and Enterprise Data Warehousing environments . Experience with design, development and support of normalized data structures (commonly referred to as Inmon) . Experience developing Data Warehouse databases using Oracle RDBMS platform and tools . Experience with Kimball (Dimensional Modeling) and Inmon methodologies . 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) . Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another . Experience with Data Warehouse tools and techniques (ETL tools, STAR schemas, etc.) . Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and Conceptual and Logical Data Design. . 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) . Software development experience with Oracle RDBMS 11g . Software development experience with IBM DB2 SQL . Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, PowerPoint, Visio, Clarity) . Experience performing peer reviews . Ability to effectively communicate with business and IT staff . Ability to effectively communicate with business and IT staff . Ability to quickly adapt to changes, enhancements, and new technologies . Ability to establish and maintain positive collaborative relationships with team members . High energy levels and tolerance for tight deadlines and time pressures Skills Needed: Experience working as a data modeler in business intelligence, analytics and Enterprise Data Warehousing environments Required 10 Years Experience with design, development and support of normalized data structures (commonly referred to as Inmon) Required 10 Years Experience developing Data Warehouse databases using Oracle RDBMS platform and tools Required 7 Years Experience with Kimball (Dimensional Modeling) and Inmon methodologies Required 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 c Required 5 Years Experience analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to an Required 5 Years Experience with Data Warehouse tools and techniques (ETL tools, STAR schemas, etc.) Required 5 Years Experience with STAR Schema structures, theories, principles, and best practices, Data Governance, Data Quality Management, Metadata Management, and C Required 5 Years Strong Data Modeling skills to include data quality, source systems analysis (DB2, Oracle, VSAM , etc) business rules validation, source to target map Required 5 Years Software development experience with Oracle RDBMS 11g Desired 3 Years Software development experience with IBM DB2 SQL Desired 1 Years Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, PowerPoint, Visio, Clarity) Desired 3 Years Experience performing peer reviews Desired 1 Years Ability to effectively communicate with business and IT staff Desired 4 Years Ability to quickly adapt to changes, enhancements, and new technologies Desired 1 Years Ability to establish and maintain positive collaborative relationships with team members Desired 2 Years High energy levels and tolerance for tight deadlines and time pressures Desired 2 Years Thanks Sandeep Sandeep Jain Software People Inc. [email protected] Ph: 631-863-0299, 631-410-4741, 631-921-2111 C Fax: 631-574-3122 Twitter: Software People @spincjobs Certifications: SBA 8a/SDB, NY MWBE, VA SWaM, DE OMWBE, MA MWBE -- You received this message because you are subscribed to the Google Groups "Exact Match" 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/exact-match. For more options, visit https://groups.google.com/d/optout.
