Cognos/ETL Developer

Description

RESPONSIBILITIES The Report Developer will participate in the design, development, and deployment of the Cognos environment and reports for a multiterabyte data warehouse. This will involve development and deployment of Cognos packages and reports, development of Cognos landing and administration pages, integrating the Cognos namespace with existing security architecture and with application security tables, identifying, researching, and resolving performance and data quality issues. The Report Developer will perform the unit testing and assist the Business Analysts with integration, performance, and user acceptance testing. They will document the Cognos design and test results. The selected candidate should be selfmotivated and have a proven record of managing their own time and work. He/She will need to provide regular status reporting to their manager and be able to assess potential issues and risks to project timelines. REQUIREMENTS The ideal candidate must be experienced in the following areas Experience reporting from high volume databases with partitioned data. Extensive experience with Cognos Report DesignerExperience in package development and development of presentation layer objects and landing pagesExperience integrating Cognos security in a complex security environmentDemonstrated experience ensuring report and presentation layer code delivered is running, conforms to specifications and design guidelines and is within estimated timelinesDemonstrated experience in clearly documenting Cognos components and reportsStrong knowledge of Data Warehousing methodologies and concepts, including and not limited to star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools (e.g. Cognos a plus) Experience working with and within cross functional Development, QA, Test and Functional TeamsExcellent analytical skills, the ability to integrate information from multiple sources to execute effectively and efficiently in a dynamic environment and pursue a proactive approach to problem solvingStrong exposure in data quality identification and remediation and data conversion requirementsAble to work flexible hours as required by business priorities EDUCATION/REVELEVANT EXPERIENCE 7+ years of Cognos development and data warehousing experience Strong ability in reports performance tuning in an Oracle environmentExperience integrating Cognos security components with external security components (LDAP, OAM, AD)Knowledge of Oracle security structures, OAM and OID, preferredFamiliarity with ad hoc and pregenerated reports testing and quality assurance methodsWebbased application development, framework object development experience, Oracle Relational Databases and J2EE platform development a plus