Business Intelligence Specialist

  • unknown, Canada
  • Contract

Company Description

 

Job Description

Position: Business Intelligence Specialist
Location: Toronto, ON
Contract: 7 Months


Scope of Services and Deliverables – The Services and Deliverables to be provided by the Vendor will include the following:

The Vendor shall provide a qualified BI Specialist, Role 5, Level 3 to perform the following Services and Deliverables:


- Design, Build (i.e. Develop code, Unit Test and document design documents and other related documents) and complete deployment packages including related documentation to fulfill business requirements for MPI.
- Document all changes to the MPI carried out for review and approval by the Client.
- Prepare and document the Deployment Guide for deployment of the solution to production environment and other environments in the format required by the Client.
- Review all application design decisions pertaining to the Application with the Client staff before proceeding to make changes.
- Work with the Business Analyst to ensure requirements are fully understood and complete, design and ensure implemented solution fulfills requirements.
- Work with the Client technical staff to identify performance or availability issues and provide solutions for the Application.
- Support resolving day to day programming issues.
- Assist in code and design reviews.
- Provide improvements, changes or Defect Fixes identified during Quality Assurance (QA) Testing and User Acceptance Testing (UAT) of the Application and Application enhancements.
- Provide systems designs and program code which conform to Client ETL Informatica and Client Cognos BI Coding Standards and to Client Project Interface Design.
- Obtain Client application architect approval for all Application program code changes.
- Revise relevant Application documentation, as determined by the Client.


- 10 or more years of experience as a BI Specialist.
- Experience with Informatica 8/9/9.5: Power Centre, Metadata Manager.
- Experience developing ETL mappings and workflows using the PowerCenter solutions: Designer, Workflow Manager, Workflow Monitor, Repository Manager.
- Experience with Oracle SQL and PL/SQL.
- Working knowledge of Cognos 8.4.1/10.2: Framework Manager, Report Studio, Query Studio, Analysis Studio.
- Experience with OLTP and OLAP data modeling.
- Experience in understanding and updating UML based design documents.
- Experience with Lotus Notes/LEI 7/8.5.
- Experience with developing monitoring and error notification processes to ensure data is updated as designed Experience with developing monitoring and error notification processes to ensure data is updated as designed.
- Demonstrated skills and experience as a BI Specialist in application design, development and implementation project.

- Experience with the development of common utility components.
- Experience in contributing to large, complex, IT system development and implementation projects.
- A team player with a track record for meeting deadlines.
- Experience in the development of distributed applications.
- Demonstrated skills and experience with presentation and server-side frameworks and SQL.

- Web development experience, including HTML, JavaScript.
- Experience with Cognos 8.4.1/10.2: Framework Manager, Report Studio, Query Studio, Analysis Studio.
- Experience with developing Framework Manager metadata model development, Report Studio Development, Cognos Transformer Cube model development and administration for deployment purposes.


- Experience with OLAP analysis and design.
- Experience with Oracle SQL schemas and PL/SQL procedures, packages and Functions.
- Java development experience especially in web applications and web services.
- Demonstrated familiarity with systems development for OPS program areas.
- Experience within the OPS in projects of a similar nature.
- Demonstrated analytical and communication skills.

- Excellent analytical, problem solving and decision making skills.
- Excellent English language verbal and written communication skills.
- Excellent interpersonal and negotiation skills.
- Experience in Cognos/Informatica reviews.


- RUP Methodology, Enterprise Architecture (Zachman Framework), specifically rows 3-5.
- IBM® Rational Rose® Version 2003.06.00.
- IBM® Cognos® Framework Manager v8.4 and v10.2 Informatica Power Centre Advanced Edition 9.1/9.5.
- IBM® WebSphere® v 5.0.2, v 6.1 and v 7.0, Cognos v8.4 and v10.2.
- IBM® HTTP Version 1.3.26 and IIS.
- Oracle® v 10gR2 and v11gR2.
- Oracle® SQL Developer, TOAD.
- Cognos v8.4 and v10.2: Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio.
- Informatica v8, v9, v9.5 PowerCentre Advanced Edition; Metadata Manager.
- Lotus Notes 7.5/8, SQL, PL/SQL.
- Knowledge of Java™ 1.3.1/1.5; J2EE v1.3 /1.4 an advantage.
- Windows 2003 and Oracle® Solaris.
- Internet Explorer 6.0 AND I.E. 8.0.


- Microsoft Office®, including Exchange/Outlook.
- IBM® Rational Functional Tester – Version 8.2.1.1 or higher, Jmeter.
- IBM® AppScan – Version 8.5.
- IBM® Rational Quality Manager – Version 4.0.
- IBM® Rational Performance Tester – Version 8.2.
- IBM® Rational Team Concert – Version 4.0.
- IBM® Rational Quality Manager – Version 4.0.

- Experience with Informatica 8/9/9.5: Power Centre, Metadata Manager.
- Experience with developing ETL mappings and workflows using the PowerCenter solutions: Designer, Workflow Manager, Workflow Monitor, Repository Manager.
- Experience with Cognos 8.4.1/10.2: Framework Manager, Report Studio, Query Studio, Analysis Studio.
- Experience with Oracle SQL and PL/SQL.
- Experience with OLTP and OLAP data modeling.
- Experience with Lotus Notes/LEI 7/8.5.


contract@3kc.ca


http://3kconsulting.ca/business-intelligence-specialist/

Additional Information

Here, write anything about the job that is not included in company, job description, and qualifications, such as travel requirements. And ensure your potential co-worker, "All your information will be kept confidential according to EEO guidelines".