(Référence :17000187)

ETL Developer

Description du poste

  • Location TORONTO , Ontario, Canada

    Category Information Technology

    Job Opened 04/24/2017

    Education Associate's Degree/College Diploma

    Job Number 17000187

    Job Type Full Time

    Company Description

    Hudson’s Bay Company is one of the fastest-growing department store retailers in the world. In North America, HBC’s leading banners include Hudson’s Bay, Lord & Taylor, Saks Fifth Avenue, Gilt, Saks OFF 5TH, Find @ Lord & Taylor, and Home Outfitters. In Europe, HBC’s banners include GALERIA Kaufhof (the largest department store group in Germany), Galeria INNO (Belgium’s only department store group), and Sportarena. At HBC we are a company of adventurers who explore uncharted territory, challenge convention, and work with imagination and fun.

    Summary –

    Responsible for ETL program design, coding, unit testing, integration testing and implementation of ETL programs, primarily using Informatica PowerCenter.

    Main Accountabilities

    Performs design and development of ETL processes to support project requirements
    Develop Informatica mappings, SQL/stored procedures as well as data maps for PowerExchange, or Unix shell scripts.
    Performs unit testing, QA, and work with business partners to resolve any issues discovered during UAT.
    Maintains development and test data environments by populating the data based on project requirements.
    Maintains all applicable documentation pertaining to specific SDLC phases
    Responsible for peer-review of mappings and workflows when required.
    Works with production control and operations as needed to promote mappings/workflows, implement schedules and resolve the issues
    Reviews ETL performance and conducts performance tuning as required on mappings / workflows or SQL.
    Other tasks as defined by manager.


    A bachelors degree in Information Technology or related field (preferred) or equivalent experience
    Strong knowledge of technology platforms and environments
    A minimum of 3-5 years’ experience in Data Warehouse ETL Development. You must be legally eligible to work in Canada
    Proven ability to work independently in a dynamic environment with multiple assigned projects and tasks
    Strong skills in Teradata / Oracle / Informatica / SQL and preferable with Mainframe / PowerExchange experience.
    Strong analytical and problem solving skills
    Strong understanding of ETL Development best practices.
    Strong understanding of Database Concepts, Performance Tuning in SQL and Informatica.
    Outstanding ability to communicate, both verbally and in writing
    Ability to develop complex mappings and workflows in accordance with requirements.

Description de l'entreprise

Autres offres de l'entreprise


Nouveau sur Jobboom

Votre profil et votre CV seront désormais visibles par les employeurs.

  • Soyez repéré et contacté directement par les recruteurs
  • Augmentez vos chances de trouver l’emploi de vos rêves

N’oubliez pas de compléter votre profil et de mettre à jour votre CV pour aider les employeurs à vous trouver.