Company Description

Spruce 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.

Website

http://www.spruceinfotech.com

Job Description

Assignment: RQ09423 – BI Cognos Developer
Office Location: 222 Jarvis St. Toronto

Hybrid - 3 days in office, 2 days work from home

Description

• Analysis 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 applications
• Define standards for the integration and governance of enterprise data
• Design metadata management programs and scripts
• Define and evaluate conceptual, logical, and physical BI solution architectures
• Design healthcare business information structures (cubes, dimensions, facts, tables, etc.)
• Perform data quality assessments, data transformation, and data cleansing
• Develop test scripts and perform testing of BI solutions
• Responsible for Java based development utilizing a combination of WebSphere, JDBC, Oracle, DB2, DataPower and associated Web technologies including JavaScript and JSP
• Responsible for integration of Open Source Software (OSS) products into new and existing systems
• Creation 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/Documentation
• As 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