RQ09328 - Specialized IT Consultant - Senior

Rubicon Path; Toronto; On-site; CAD 90,000 - 130,000; Full time

Job summary

A leading consulting firm is seeking a Senior IT Consultant in Toronto, specializing in Oracle technologies such as APEX, PL/SQL, and ODI. The role involves providing expert advice on IT systems, ensuring quality deliverables, and enhancing business processes. Candidates should possess substantial experience in infrastructure management and ETL solutions, focusing on Oracle applications. This opportunity offers a competitive salary and a challenging work environment.

Qualifications

• At least five years experience developing and maintaining ETL solutions with ODI.
• Experience with Hyperion Planning and dedicated infrastructure management.
• Ability to analyze I&IT requirements and design complex systems.

Responsibilities

• Provide consulting services as a full stack Oracle developer specialized in APEX and PL/SQL.
• Work with clients to improve IT efficiency and strategic guidance.
• Manage software installations and configurations in Linux and Windows environments.

Skills

ETL

ODI

Infrastructure Management

Hyperion Planning

Data Extraction and Loading

Project Scope Definition

Job description

The main responsibility of this resource is to provide the services of a full stack Oracle developer specialized in APEX, PL / SQL with some exposure to the other Oracle development tools being used in these applications such as ODI and the relational database.

• Works in partnership with clients, advising them on information technology in order to meet their business objectives or overcome problems, work to improve structure and efficiency of an organizations I&IT systems.
• The I&IT Consultant may be used to provide strategic guidance to organizations with regard to Information Management & IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.
• Provides subject matter expertise in their field and highly expert technical assistance.

General Skills :

• Acts as the technical advisor / expert on all aspects of a specific deliverable
• Provide the quality assurance / quality control of specific deliverables
• Anticipates and resolves problems to ensure that the deliverables are completed within budget, to the highest quality, meeting or exceeding expectations
• Develops processes and procedures for implementing deliverables
• Prepares reports and presentations including options, recommendations, implementation plans, etc.
• Works with clients to define the scope of a project and to determine requirements
• Defines software, hardware and network requirements
• Analyzes I&IT requirements giving independent and objective advice on the use of I&IT
• Designs, tests, installs and monitors new systems and develops solutions and implementation of new systems
• Familiar with change-management principles and methodology
• Knowledge and understanding of Information Management principles, concepts, policies and practices

SkillsExperience and Skill Set Requirements

Evaluation based on price 30%.

Skills and Experience accounts for 70% apportioned as follows :

Core Technical Skills (35%)

• At least five years experience developing and maintaining ETL solutions with at least two years experience using ODI as the ETL tool for loading and extracting data from Essbase cubes. Some experience in Informatica also desirable.
• Demonstrated experience installing, configuring and maintaining Hyperion Planning (Oracle EPM) software stack with some experience installing Hyperion Planning 11.2, and at least three years of dedicated infrastructure experience or equivalent across a longer time period.
• Demonstrated experience installing and configuring EPM to work in an OAM single-sign on configuration.
• Demonstrated experience managing software and infrastructure components in the following environments : Linux, Windows Server.
• Demonstrated experience installing and configuring Word Press in a Linux load-balance environment.
• Demonstrated experience managing network components in a complex, load-balance environment.

Application-Specific Experience (35%) :

• Demonstrated expertise in loading and extracting data from Hyperion applications that utilize a large number of Plan Types.
• Demonstrated experience working in a load-balanced, highly available hardware and software configuration.
• Demonstrated experience working with applications exposed to external access via a Proxy Server.
• Demonstrated experience designing, specifying and implementing complex computing platforms.
• Demonstrated experience developing high quality documentation of complex infrastructure implementations.
• Demonstrated experience working with data centre staff to manage a complex platform extending across multiple operating systems and integrating multiple application development tools.

MUST HAVE :

Looking for : experience with Infrastructure related roles - set up the software in operating environments, stalling and configuring software properly. Not so much a developer. Also looking for ETL with a focus on ODI.

• At least five years experience developing and maintaining ETL solutions with some experience using ODI as the ETL tool. Some experience in Informatica also desirable.
• Demonstrated experience installing, configuring and maintaining Hyperion Planning (Oracle EPM) software stack with some experience installing Hyperion Planning 11.2, and at least three years of dedicated infrastructure experience or equivalent across a longer time period.

Create a job alert for this search

Senior It Consultant • Toronto, ON, Canada