*Job Title: Cognos Programmer* *Job Location: Columbus, OH*
*Job Duration: 10+ Months Contract* *Face to face **In-Person Interview Must.* *Job Description:* · BWC is implementing new claims, policy and billing system. This new implementation is shifting our data warehouse and reporting infrastructure from DB2/Hyperion to Oracle/Cognos. The nature of our data is also changing, as data elements are changing purpose and semantics as part of the transition. · BWC’s new system will have a transaction data store (TDS), operational data store (ODS) and a newly designed Oracle enterprise data warehouse. The Cognos developers will be primarily involved in developing reports using Cognos Report studio and performing Unit testing. They will collaborate with framework modelers, data analysts, business analysts, testing specialists, and business customers to create business reports that are accurate, reliable, attractive, timely, and relevant. *Day-in-the-Life: * *During a given day, this position will be expected to:* · Design and develop complex Report Studio objects (e.g. Active Reports, complex conditional formatting, and complex hierarchical development within list frames) based upon report specifications · Unit test developed reports and verify results against specifications · Serve as a reporting expert as needed during user and systems testing · Identify and document any inconsistencies between data model and report specifications · Identify and document any software issues encountered · Document functional specifications, technical specifications and unit testing requirements as assigned · Use Cognos and Oracle software and tools to perform required tasks · Perform knowledge transfer to BWC staff *Mandatory Skills:* · 8 or more years of experience with SQL programming against an Oracle RDBMS on data warehouse or business intelligence projects. · 7 or more years of experience with business intelligence tools such as IBM Cognos · 5 or more years of experience with development and support using dimensional/star-schema based data structures including fact tables (commonly referred to as Kimball). · 4 years or more experience designing and developing Cognos (version 8.2 and above) reports using Report Studio, Analysis Studio and Active Reports *Desired Skills:* · Proficiency with Cognos 10.2 and Workspace Advance features · Software development experience with Oracle RDBMS 11g · Software development experience with IBM DB2 SQL · Experience with HTML and JavaScript, as used for Cognos reporting · Experience writing design specifications, test scripts and other required documentation · Experience developing queries against normalized as well as dimensional data structures · Experience establishing standards based on industry best practices · Knowledge of property and casualty insurance systems · Knowledge of Ohio BWC business model and processes · Experience using Oracle SQL*Plus, Toad, Oracle SQL Developer · Experience in measuring and tuning the performance of Oracle data warehouse SQL queries · 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 quickly adapt to changes, enhancements, and new technologies · Ability to establish and maintain positive collaborative relationships with team members *Skill Matrix:* *Skills* *Importance* *Yrs of Exp* *Last Used* Experience with SQL programming against an Oracle RDBMS on data warehouse or business intelligence projects Required Experience with business intelligence tools such as IBM Cognos Required Experience with development and support using dimensional/star-schema based data structures including fact tables (commonly referred to as Kimball) Required Experience designing and developing Cognos (version 8.2 and above) reports using Report Studio, Analysis Studio and Active Reports Required Proficiency with Cognos 10.2 and Workspace Advance features Desired Software development experience with Oracle RDBMS 11g Desired Software development experience with IBM DB2 SQL Desired Experience with HTML and JavaScript, as used for Cognos reporting Desired Experience writing design specifications, test scripts and other required documentation Desired Experience developing queries against normalized as well as dimensional data structures Desired Experience establishing standards based on industry best practices Desired Knowledge of property and casualty insurance systems Desired Experience using Oracle SQL*Plus, Toad, Oracle SQL Developer Desired Experience in measuring and tuning the performance of Oracle data warehouse SQL queries Desired Skill in the use of organizational tools & methods (MS Excel, MS Word, MS Outlook, PowerPoint, Visio, Clarity) Desired Experience performing peer reviews Desired Ability to effectively communicate with business and IT staff Desired Ability to quickly adapt to changes, enhancements, and new technologies Desired Ability to establish and maintain positive collaborative relationships with team members Desired Please add [email protected] <[email protected]> to your mailing list for requirements and hot lists. Look forward to work with you -- -- Thank you Kevin Technical Recruiter ilogicnet Consulting [email protected] <[email protected]> Contact number: 781-688-1520 -- You received this message because you are subscribed to the Google Groups "Siebel jobs" 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/siebel-job. For more options, visit https://groups.google.com/groups/opt_out.
