Jobs in Canada
  Job-seekers
     Job search
  Employer search

  Add your resume
  Update resume
  Remove resume

  Set-up job alert
  Modify job alert
  Remove job alert

  Employers
     New account
  Employer log-in
  Control panel
  Post a job
  Resume search
  Employer F.A.Q.

  Resources
     F.A.Q.
  International
  Privacy policy
  Contact us





Queue IT Professionals
 
ETL Specialist
 


The role is responsible for providing architectural, technical and analytic support to the company. The role would provide guidance towards establishing best practices in ETL standards, methodology and architecture. The role also conducts assessment of the business’ informational requirements and data sources and converts them into design specifications for reports and dashboards and then, builds them. The role requires the individual to work independently and to effectively work in teams, with a high level of initiative and motivation to ensure that deliverables are met.
The deliverables include: system architecture design and documentation, business analysis from an information usage perspective; data usage guidelines; procuring new sources of data; analyzing the data and supplying value added information to optimize processes and tracking trends for statistical purposes.

The incumbent will support usage of databases utilized by various reporting and analytical tools. Specific responsibilities include:
• Development, tuning and optimization of the ETL packages, with emphasis on Microsoft SSIS;
• Database tuning and optimization, specifically Microsoft SQL Server 2012;
• Develop change management methodology leveraging TFS;
• Gather and document information from business users regarding their reporting and analytical requirements;
• Working with UI team to translate the business requirements into technical data requirements;
• Develop source to target mapping documentation;
• Data analysis of source systems to validate rules/assumptions;
• Ensure accuracy and integrity of data and applications; and
• Provide in-depth insights, where required, for root-cause analysis and historical trending.
Specific qualifications include:
• Minimum 5 years’ experience in developing Data Warehouses;
• Strong experience with T-SQL and the development/optimization of queries, specifically with SQL Server;
• Strong experience with ETL tools, specifically with SSIS;
• Proven experience with the administration and tuning of SQL Server databases;
• Knowledge/experience of data modeling;
• Knowledge/experience with a BI or Reporting applications such as Cognos, Business Objects, Microstrategy, etc.;
• Knowledge/experience working with Team Foundation Services (TFS);
• Experience with JD Edwards or some other ERP system is an asset; and
• Strong communication and documentation skills.

 
Date: July 11, 2014
City/Town:Toronto
Location:ON/Toronto/GTA
Wage/Salary: $80K-$90K
Start: asap
Duration: ft
Type: Full Time
How to apply:email
Company: Queue IT Professionals
Contact: Ross Pestell
Phone:
Fax:
Email:

Eligibility note:

It is unlawful to employ a person who does not have permission to live and work in Canada. Unless the advert states otherwise, please ensure you have this permission before applying.





This site accepts

Click here to add Best Jobs Canada to your favorites

Click here to make Best Jobs Canada your home page

Copyright © DGNET LTD.