Role: Cognos Developer
*Client: State of OH*
*Interview Type: In Person*
*Interview Dates: Week of February 3rd*
*Location - Columbus, OH*
*Number of Openings: 1*
**
*JOB DESCRIPTION:*
BWC is implementing a 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
SKILLS (mandatory and desirable) with years of experience if applicable
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 Thanks and Regards
Amarinder Singh (Sr. IT Associate)
Kalven Technologies Inc. 2300, E Higgins Rd, Suite 211, ELK Grove
Village, IL-60007
1701, E.Wood Field Rd, Suite
300, Schaumburg, IL-60173
Work : 312-912-7248 | Email id : [email protected]
<mailto:[email protected]> | LinkedIn : Amar Singh | Skype id :
Amarinderkalven
http://www.kalventech.com
Product Engineering | Systems Integration | Professional Services.
Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress this
mail cannot be considered Spam as long as we include contact information
and a remove link for removal from our mailing list. To be removed from
our mailing list reply with "remove" and include your "original email
address/addresses" in the subject heading. Include complete
address/addresses and/or domain to be removed. We will immediately
update it accordingly. We apologize for the inconvenience caused..
--
You received this message because you are subscribed to the Google Groups "Oracle
Users" 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/oracle-users.
For more options, visit https://groups.google.com/groups/opt_out.
