Company DescriptionSpruce InfoTech, a leading IT firm, offers innovative and cost-effective solutions to help clients manage and transform their businesses. Our services are designed to guide companies of all sizes, from small businesses to Fortune 500 organizations, in maximizing their IT investment while reducing technology costs. Our team of experts has extensive technical knowledge in enterprise solutions, which helps organizations transform these solutions into a strategic asset that can drive new revenue and improve business operations.Websitehttp://www.spruceinfotech.comJob DescriptionAssignment: RQ09423 – BI Cognos Developer
Office Location: 222 Jarvis St. TorontoHybrid - 3 days in office, 2 days work from home DescriptionAnalysis of business requirement documents and liaison with clients.Facilitating IT development, design, construction, testing, promotion, implementation of web-based/n-tier, cloud-based and mainframe applicationsDefine standards for the integration and governance of enterprise dataDesign metadata management programs and scriptsDefine and evaluate conceptual, logical, and physical BI solution architecturesDesign healthcare business information structures (cubes, dimensions, facts, tables, etc.)Perform data quality assessments, data transformation, and data cleansingDevelop test scripts and perform testing of BI solutionsResponsible for Java based development utilizing a combination of WebSphere, JDBC, Oracle, DB2, DataPower and associated Web technologies including JavaScript and JSPResponsible for integration of Open Source Software (OSS) products into new and existing systemsCreation and walk-through of Systems Response documents, Technical Specifications, Application Inventory, and Implementation Plans.Preparation of test plans, test data, and unit-testing of programs.Preparation of implementation plans and promotion of programs.System Support/DocumentationAs assigned, response to client queries and troubleshooting of production incidents.Conduct/participate in design walkthroughs as well as test case and test results walkthroughs.Support testing of the changes by other team members.Weekly reporting on status, progress, and key issue/concerns as directed by the Project Lead/Project Manager or Portfolio Manager MUST HAVES 5 + more years of business intelligence experience· 5 + years of Cognos experience· 5+ years – Framework Manager and Report Studio· 5+ years – Active Reports, Transformer and dashboarding· 5+ years – Report Studio (including being a trainer/mentor)· 3+ years – Metrics Studio· 5 years data analysis experience· IBM Certified Designer – Cognos 11.2.1 BI Reports· IBM Certified Developer – Cognos 11.2.1 BI Metadata Models· IBM Certified Administrator – Cognos 11.2.1 BI? Experience with, and understanding of, relational databases (DB2, Oracle, MS-SQL)· Preparation of test plans, test data, and unit-testing of programs· Preparation of implementation plans and promotion of modules· Participate in business requirements walkthroughs· Conduct/participate in design walkthroughs
