Connexion Inscription gratuite
Postuler

Publié il y a 169 mois

BI-Informatica Developer

@ system canada technologies

Toutes ses offres

Toronto, Ontario

Sur placeContrat
Postuler
SIGNAUX

En bref

SCT resources is hiring a contract BI-Informatica Developer to build and maintain ETL processes for large OLAP and OLTP data sets. The role involves Informatica PowerCenter workflows, Oracle SQL and performance tuning, and gathering requirements from end users. Healthcare industry knowledge is a plus.

Responsabilités :

  • Create, tune and test complex ETL processes for OLAP/OLTP data sets
  • Create and maintain Informatica 8.x/9.x workflows
  • Gather requirements with end users
  • Validate business rules and transformations

Résumé des exigences :

  • Expertise in Informatica PowerCenter 8.6 and 9.x suite
  • Strong Oracle SQL and query optimization skills
  • Experience with incremental loads and performance tuning
  • Healthcare industry knowledge a plus

Outils et compétences

Informatica PowerCenterOracle 11gMSSQLASG-Rochade
Source et dates

Site carrière / système de candidatures · smartrecruiters

Date publiée par l’employeur
2012-12-31
Première détection par notre source
2026-10-14
Mise à jour du dossier source
2026-10-14

Ces dates décrivent le dossier source, pas une vérification en direct du recrutement. Consultez l’offre originale.

Détails du poste

DomaineDéveloppement logiciel
Déplacementsavion : aucun · route : aucun
Milieu de travailBureau
PositionSurtout assis
Exigences physiquesphysique faible · ordinateur élevé
LanguesEnglish

Résumé et détails rédigés par l’IA à partir de l’offre; l’offre de l’employeur fait foi.

Postuler

system canada technologies

Toutes ses offres
ChampValeur
Offres sur Jobsy399
Description

Company Description

SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

Job Description

Job Responsibilities:

Create, tuning and testing complex ETL processes for large and complex OLAP/OLTP data sets
Create and maintain Informatica 8.x/9.x workflows
Create ETL processes from business requirements.
Participate in requirement meetings with end-users to understand and collect requirements.
Validate the accuracy of business rules and transformations

Required Skills/Qualification:

Informatica
Strong knowledge of HealthCare industry, a plus
8.6 and 9.x suite of products
Expertise in the entire PowerCenter suite (Repository Manager, Designer, Workflow Manager, and Workflow Monitor)
Conforming and merging data from multiple data source types (ie MSSQL, Oracle, flat files, etc.)
o Incrementally loading large tables with complex keys
o Using transformations to implement complex business rules
Workflow management
o Designing incremental load logic
o Error handling
o Using Informatica to restart failed jobs
o Tracking performance and job status and job scheduling
Performance tuning
o Workflow optimization
o Mapping optimization
o Transformation optimization
ETL documentation
o Experience using ASG-Rochade is a plus
Oracle
Experience with Oracle 11g preferred
Experience writing complex SQL queries against large data sets
Query optimization (indexing, partitioning, Oracle configuration, etc.)
o Experience capturing and interpreting Oracle performance based statistics is a plus
Creating, modifying and optimizing stored procedures and packages
Familiarity with dimensional models and Operational Data Stores
Experience gathering and implementing business rules
Experience reconciling data output to existing reports and source data
Excellent oral and written communication
Self Starter who takes initiative

Emplois semblables

  • Director, Marketing Partnerships Lead – NBA Canada

    Toronto, ON
    Temps plein

    CAN NBA Canada

    Best-in-class partner experience; Required Skills/Knowledge; Ability to build and maintain strong, long-term partnerships

    Senior Manager, Licensing & Account Management – NBA Canada

    Toronto, ON
    Temps plein

    CAN NBA Canada

    Success in this role requires a strategic and market-driven mindset, strong relationship management skills, and the ability to identify innovative growth opportunities while collaborating…; · Monitor royalty reporting,…

  • Veterinary Reception, Animal Care Attendant, Secord Animal Hospital

    Toronto, ON
    19–25 $/hTemps plein

    VCA Animal Hospitals

    Compensation: $19.00 to $25.00 per hour, depending on experience and skills; Exceptional customer service skills with a natural ability to show empathy, comfort, and patience under pressure; Outstanding multitasking…

    Communication skills, Scheduling, Patient care, Process payments, Customer service, Show empathy

    Veterinary Technician, RVT, Secord Animal Hospital

    Toronto, ON
    22–30 $/hTemps plein

    VCA Animal Hospitals

    Compensation: $22.00 to $30.00 per hour, depending on experience and skills; Team Collaboration: Work with team members to deliver an exceptional patient and client experience; Completion of a Veterinary Technician or…

    Patient care, Communicate with customers, Collaboration, Pharmacology, Phlebotomy, Patient assessment

  • Senior Manager, Strategic Project Management

    Toronto, ON
    TélétravailTemps plein

    Datasite LLC

    Lead business systems implementations and transformations (e.g., CRM, ERP, finance, HR, and data platforms), including requirements alignment, vendor management, change management, and…; Apply AI tools and automation…

  • Project Manager

    Toronto, ON
    75k–90k $/anSur placeTemps plein

    Design Works Engineering

    5+ ansCandidates need an engineering, architecture, construction management or related degree or diploma and 5+ years managing building projects. They must handle several projects at once in a fast pace, be confident with clients, and be proficient with Microsoft 365 and project tracking tools.

    Microsoft 365, project tracking tools

  • Grant Writer, Government, Foundation & Corporate Grants

    Toronto, ON
    HybrideTemps plein

    CivicAction Leadership Foundation

    · Research prospective funders, including their priorities, eligibility requirements, previous funding and areas of interest; · Assess opportunities based on eligibility, strategic fit, potential funding value, timing…

    Marketing and Communications Volunteer

    Toronto, ON
    HybrideBénévolat

    CivicAction Leadership Foundation

    This is an opportunity to gain hands-on experience across a range of marketing and communications functions, from social media and content development to email marketing, website updates,…; ● Ability to manage tasks,…

Lieux et modes de travail

Lieux

Tout le CanadaTélétravail · Hybride · Sur place · Sur le terrain

Astuce : ajoutez le télétravail pour élargir la recherche.

Exclure des lieux

Mode de travail

Offres de cette entreprise dans les résultats

Voici les offres de cette entreprise chargées dans votre recherche. Elle peut avoir d’autres postes ouverts.