ETL Consultant

LanceSoft; Toronto; On-site; CAD 125,000 - 150,000; Full time

Job summary

An established industry player is seeking a Specialized IT Consultant to enhance clients' information management and technology systems. This role involves advising organizations on optimizing their IT infrastructures and implementing effective solutions using tools like Oracle Data Integrator and Informatica ETL. The ideal candidate will have a strong background in solution design and experience with business intelligence reporting through Cognos and Microsoft Power BI. Join a dynamic team where your expertise will drive significant improvements in clients' operational efficiency and strategic initiatives.

Qualifications

• Experience in developing and designing solutions using Oracle, Informatica, and Cognos.
• Proven skills in designing and implementing ETL solutions and BI reports.

Responsibilities

• Advise clients on using information management and technology to meet business goals.
• Provide strategic guidance and subject matter expertise for IT infrastructures.

Skills

Oracle Data Integrator

Informatica ETL

Cognos

Microsoft Power BI

Solution Design

Tools

Informatica

Oracle

Cognos

Microsoft Power BI

Job description

Job Description:

Responsibilities:

1. Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organization's I&IT Systems including the use of Oracle Data Integrator and Informatica ETL tools.
2. The Specialized IT Consultant may be used to provide strategic guidance to organizations with regard to IM and Task-based IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT.
3. They can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance.

Must Have:

1. Demonstrated development and solution design experience in an environment where Oracle, Informatica and Cognos are used together.
2. Demonstrated experience designing, developing, and implementing Informatica ETL solutions.
3. Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.