Hi,
Please find the requirement below and let me know your interest... *POSITION* *Data Warehouse Architect* *5 months* *Columbus, OH (locals only)* *In person interview* *$75 per hr* -10 or more years of experience in design, development, modification and testing of databases designed to support Data Warehousing and BI business teams -10 or more years of experience with design, development and support of normalized data structures (commonly referred to as Inmon) -7 or more years of experience developing Data Warehouse databases using Oracle RDBMS platform and tools. -5 or more years of experience with design, development, tuning and support of dimensional/star-schema based data structures including fact tables. -5 or more years of experience with Kimball and Inmon methodologies -5 or more years of experience with the AllFusion Erwin modeling tool, including Model Mart Repository advanced features (e.g. checkin/out, complete compare) -3 or more years of experience in data profiling, data mining and data cleansing.3 or more years of experience in the use of organizational tools & methods (MS Excel, MS Word, MS outlook, VISIO, Clarity) -Experience developing complex sql against normalized as well as dimensional data structures -Experience using oracle SQL*Plus, Toad, Oracle PL/SQL Developer -Experience on an IBM/DB2 platform -Experience in measuring and tuning the performance of Oracle Data Warehouse databases -3 or more years of experience working with designers/developers who use the Cognos Business Intelligence tools. -Ability to effectively communicate with business and IT staff -Ability to quickly adapt to changes, enhancements, and new technologies -Knowledge of the PowerSuite Claims, Policy, and Billing application -Knowledge of Ohio BWC business model and processes -Knowledge of property and casualty insurance systems Typical Daily Activities: -Work with PowerSuite SME to understand the PowerSuite application business functionality and write complex queries to understand how the data is stored in the PowerSuite Transactional System. -Work with Cognos Framework Model SME, PowerSuite SME and other Data Architects to identify dimension and facts tables to be built. -After designing dimension and fact tables, hold design review sessions to obtain approval and sign off. -Deploy new tables directly to the test environment using the Erwin tool -Produce diagrams and table/column definitions reports from Erwin and upload to the project Sharepoint site. -Map the data from the Operational Data Store to the dimension/fact tables and create an ETL mapping document, using a predefined template, for the ETL developers. -Work with Business Analysts and potentially business customers to verify requirements Work with IT ETL and Report Developers to communicate database designs, answer questions and refine/update ETL mapping documents as needed. -Analysis and Performance tuning of queries developed to access dimensional and relational models -Work with Business Analysts and potentially business customers to verify requirements · Experience in design, development, modification and testing of databases designed to support Data Warehousing and BI business teams 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 design, development, tuning and support of dimensional/star-schema based data structures including fact tables. Required 5 Years · Experience with Kimball and Inmon methodologies Required 5 Years · Experience with the AllFusion Erwin modeling tool, including Model Mart Repository advanced features (e.g. checkin/out, complete compare) Required 5 Years · Experience in data profiling, data mining and data cleansing Required 3 Years · Experience in the use of organizational tools & methods (MS Excel, MS Word, MS outlook, VISIO, Clarity) Required 3 Years · Experience developing complex sql against normalized as well as dimensional data structures Required 3 Years · Experience using oracle SQL*Plus, Toad, Oracle PL/SQL Developer Required 3 Years · Experience on an IBM/DB2 platform Required 3 Years · Experience in measuring and tuning the performance of Oracle Data Warehouse databases Required 3 Years · Experience working with designers/developers who use the Cognos Business Intelligence tools. Desired 3 Years · Ability to effectively communicate with business and IT staff Desired 3 Years · Ability to quickly adapt to changes, enhancements, and new technologies Desired 3 Years · Exp with the PowerSuite Claims, Policy, and Billing application Desired · Exp with Ohio BWC business model and processes Nice to have · Exp with property and casualty insurance systems Nice to have *Thanks and Regards,* *Shilpi Bist* *Technical Recruiter* *[image: images]* <http://www.sageci.com/> email: [email protected] Phone: 732-851-1596/ 732-767-0010 Ext: 542 Gtalk: shilpi.recruiter1 Ymail: shilpi.recruiter *[image: Linkedin_Logo]* <http://www.linkedin.com/pub/shilpi-bist/82/944/7a7/> -- You received this message because you are subscribed to the Google Groups "Open Source Erp & Crm" 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/open-source-erp-crm. For more options, visit https://groups.google.com/d/optout.
