Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowFirst seen 3 days ago

RQ08199 - Specialized IT Consultant - Senior

Rubicon Path638 open roles

Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ08199 - Specialized IT Consultant - SeniorRubicon Path

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Rubicon Path's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

12.3% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.1%1 day
  2. 4.5%3 days
  3. 12.3%7 days
  4. 19.3%14 days
  5. 35.6%30 days
  6. 57.8%60 days
This job: first seen 3 days ago

The posting

Responsibilities:

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. 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. they can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance.

Knowledge Transfer

  • Transfer From Specialized IT Consultant to Designated CSC Resource

When Knowledge Will Be Transferred:

  • Knowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministry.

What Knowledge Will Be Transferred:

  • All deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint). All final documents and working drafts related to project requirements or solution design must be stored on designated project repositories (for example, SharePoint site, HPQC, TFS, etc.)
  • Project manager and designated ministry staff must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.

How Knowledge Will Be Transferred:

  • Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team.

SkillsExperience and Skill Set Requirements

Technical Skills - 45%

  • Working knowledge of the entire Data Dictionary, data mapping.
  • Working knowledge of the Business Process Design Re-engineering for applications.
  • 5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools.
  • Experience enhancing performance of ETL code and SQL Queries.
  • Experience developing ETL routines using Informatica and/or SSIS in a data warehousing environment or large data migration.
  • Experience Designing Data warehouse components and ETL Scripts.
  • Experience using PowerDesigner to review data models, as well as make changes and generate DDL's.
  • 5+ years of experience with Unix scripting.
  • Experience working with Oracle Databases (version 10.x or higher), DB2 Database, and with complex korn-shell scripts.
  • Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.
  • Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.
  • Experience in developing the Application Code package using MS Visual Source Safe Demonstrated experience performing system testing, unit testing, and user acceptance testing.
  • Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
  • Demonstrate experience designing, developing and implementing Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
  • Experience in leading development and modelling of applications, specifically hierarchical data model applications.

Core Skills - 35%

  • Experience performing the design of data warehouse and related components, including working knowledge of SQL Server, Oracle SQL, PL/SQL, and their optimization techniques.
  • Experience with systems design and development, and related methods, techniques, practices and standards.
  • Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects.
  • Experience documenting application designs and specifications, and drafting policies and procedures for ETL processes and Power BI-compatible formats.
  • Working knowledge of aggregate reporting and ETL processes, specifically using tools like Informatica, SSIS , and Fabric Data Factory.
  • Troubleshooting of production issues and creating fixes for any unplanned deployments.
  • Defect investigation, resolution and assignment to team members using defect/issue management tools, e. g. HP ALM or HP Service Manager.
  • Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.
  • Proven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).

Communication Skills - 15%

  • Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.
  • Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives.

Public Sector Experience - 5%

  • Previous public sector experience in an organization of equivalent size.

MUST HAVE:

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

  • Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Rubicon Path's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Rubicon Path's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Rubicon Path's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.