DataWarehouse / ETL Developer

Location: Ottawa, ON, Canada
Date Posted: 11-10-2018
RESPONSIBILITIES:
  • Designs, maintains, and provides support for data warehouse systems and related data marts
  • Translates business requirements into viable technical solutions
  • Participates in the testing of developed technical solutions
  • Helps in the design, development, testing and implementation of reports and OLAP cubes
  • Participates in the investigation and resolution of complex Data Warehouse issues
  • Proactively identifies opportunities for process, systems, and other efficiency improvements
  • Works effectively in the team and contributes to team effectiveness through personal style
  • Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment
 
QUALIFICATIONS:
  • Bachelor of Computer Science Degree or equivalent and relevant work experience
  • Capability in understanding various data structures and formats and common techniques in data transformation
  • 3-5 years experience with IBMs ETL tool, IBM InfoSphere DataStage;
  • Demonstrated application of technical problem solving and analytical tools and techniques;
  • Experience with SQLServer
  • Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio)
  • Must have Government of Canada Enhanced clearance
 
DURATION:  2 years
 
or
this job portal is powered by CATS