Top Benefits
About the role
The resource provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource is ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment
There is a requirement for the resource to work on weekend and holidays (on a rotation) from 9:00AM to 11:00AM and be available on-call during this period for incidents that may arise
**Remote in Canada **
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;
- 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.
Requirements
- Minimum of eight years of related experience and knowledge;
- 3-5 years’ experience with IBMs ETL tool, IBM InfoSphere DataStage;
- Relational data base concepts and design;
- Technical testing techniques and tools;
- Logical and physical data modeling;
- Requirements analysis;
- Technical design skills;
- Proficient technical writing skills;
- Ability to translate business questions and requirements into technical solutions;
- Demonstrated application of technical problem solving and analytical tools and techniques;
- Experience with SQLServer;
Assets:
- Bilingualism in both official languages (English and French).
- Experience with Cognos Data Manager
- Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio
About IT Chapter
Our mission is to empower businesses and individuals worldwide by delivering superior training solutions that build trust, drive value, and foster inclusivity. With over 200 courses ranging from IT Best Practices to data management, cloud technologies, AI, and cybersecurity among others, we tailor our offerings to meet the specific needs of our clients, ensuring their success in an evolving digital landscape.
Founded in Montreal in 2003, IT Chapter has become a leader in IT training, providing technical courses with practical labs and flexible learning options such as online instructor-led sessions, on-site training, and e-learning.
We offer a wide range of training modalities, including public courses, private customized training, onsite sessions, online courses, e-learning, and hybrid formats to suit diverse learning preferences and organizational needs. Our portfolio includes certifications in ITIL®, BRMP®, Agile®, SCRUM®, DevOps®, COBIT® and more, covering critical IT domains such as data, cloud, and cybersecurity.
Contact us to define your path to success in the IT world. We’re here to guide you every step of the way.
Top Benefits
About the role
The resource provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource is ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment
There is a requirement for the resource to work on weekend and holidays (on a rotation) from 9:00AM to 11:00AM and be available on-call during this period for incidents that may arise
**Remote in Canada **
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;
- 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.
Requirements
- Minimum of eight years of related experience and knowledge;
- 3-5 years’ experience with IBMs ETL tool, IBM InfoSphere DataStage;
- Relational data base concepts and design;
- Technical testing techniques and tools;
- Logical and physical data modeling;
- Requirements analysis;
- Technical design skills;
- Proficient technical writing skills;
- Ability to translate business questions and requirements into technical solutions;
- Demonstrated application of technical problem solving and analytical tools and techniques;
- Experience with SQLServer;
Assets:
- Bilingualism in both official languages (English and French).
- Experience with Cognos Data Manager
- Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio
About IT Chapter
Our mission is to empower businesses and individuals worldwide by delivering superior training solutions that build trust, drive value, and foster inclusivity. With over 200 courses ranging from IT Best Practices to data management, cloud technologies, AI, and cybersecurity among others, we tailor our offerings to meet the specific needs of our clients, ensuring their success in an evolving digital landscape.
Founded in Montreal in 2003, IT Chapter has become a leader in IT training, providing technical courses with practical labs and flexible learning options such as online instructor-led sessions, on-site training, and e-learning.
We offer a wide range of training modalities, including public courses, private customized training, onsite sessions, online courses, e-learning, and hybrid formats to suit diverse learning preferences and organizational needs. Our portfolio includes certifications in ITIL®, BRMP®, Agile®, SCRUM®, DevOps®, COBIT® and more, covering critical IT domains such as data, cloud, and cybersecurity.
Contact us to define your path to success in the IT world. We’re here to guide you every step of the way.