Develop, implement, and maintain ETL processes using IBM InfoSphere DataStage and Cognos Data Manager.
Design and optimize relational database structures to support business intelligence and reporting needs.
Conduct requirements analysis and translate business requirements into technical specifications.
Perform logical and physical data modeling to enhance data integration and reporting capabilities.
Utilize technical testing techniques and tools to ensure data accuracy and reliability.
Collaborate with business stakeholders to provide technical solutions that address organizational needs.
Produce comprehensive technical documentation and reports to support data management processes.
Troubleshoot and resolve data-related issues using SQL Server and other relevant tools.
Work with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer, and Query Studio) to develop and maintain reporting solutions.
Ensure data integrity, security, and compliance with organizational policies.
Provide mentorship and guidance to junior team members in data management best practices.
Qualifications and Skills
Minimum of eight years of related experience and knowledge.
Recent experience working with Cognos Data Manager.
At least five years of experience with IBM InfoSphere DataStage.
Strong understanding of relational database concepts and design.
Expertise in logical and physical data modeling.
Proficiency in technical testing techniques and tools.
Strong requirements analysis and technical design skills.
Excellent technical writing skills for documentation and reports.
Ability to translate business questions and requirements into effective technical solutions.
Demonstrated ability in technical problem-solving and analytical tools and techniques.
Experience with SQL Server.
Reliability security clearance is required.
Education
A degree in Computer Science, Information Technology, or a related field is preferred.
Nice-to-Haves
Experience in a leadership or mentorship role within a data management team.
Familiarity with cloud-based data solutions and integration.
Certification in IBM Cognos or DataStage technologies.
Bilingualism in English and French is an asset.
Experience with IBM Cognos Business Intelligence Technologies, including Report Studio, Framework Manager, Transformer, and Query Studio.
Create a job alert for this search
ETL Developer • Ottawa, ON
Similar jobs
Senior Element Management Systems Developer
Myticas Consulting • Ottawa
Full-time
Myticas is looking for a Senior Element management System (EMS) developer who will be responsible for ensuring the smooth operation of our network by designing, implementing and maintaining EMS.Ana...Show more
Last updated: 22 days ago • Promoted
Solutions Engineer - Meld
Meld • gatineau, qc, ca
Full-time
Meld is a fast growing startup looking to add developer support for customers who use our API driven platform for managing their crypto related integrations.
We're focused on helping money move on c...Show more
Last updated: 2 days ago • Promoted
Hybrid Cloud & Embedded Apps Developer
IBM • Ottawa
Full-time +1
A global technology firm is seeking an Intermediate Application Developer to provide technical support and maintenance of applications.
Candidates should have at least 5 years of experience in low-l...Show more
Role : Oracle Integration Cloud (OIC).Good knowledge in with Oracle Integration Cloud (OIC).Oracle SaaS modules and their integration touchpoints.
Exposure to REST / SOAP web services, XML, JSON and o...Show more
Last updated: 6 days ago • Promoted
Analyste - solutions
Norton Rose Fulbright • Ottawa
Full-time
Be among the first 25 applicants.Get AI‑powered advice on this job and more exclusive features.Travail en mode hybride 4 jours semaine au bureau – veuillez noter que la personne occupant ce poste p...Show more
Last updated: 22 days ago • Promoted
Senior Developer MD365 Business Central
Sonical BV • Ottawa
Full-time
Because at Sonical we believe a.Sonical distinguishes itself by using.That is why we call ourselves Digital Experts United, bringing together complementary digital services.As a Senior Developer at...Show more
Last updated: 22 days ago • Promoted
Programmer Analyst Advisory
Scotiabank • Ottawa
Full-time
Select how often (in days) to receive an alert : .Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.
Reporting to the Manager of Software Developmen...Show more
Last updated: 6 days ago • Promoted
Programmer / Analyst Lvl3
Exposant 3 • Ottawa
Full-time
Exposant 3 is a consulting firm in business management and information technology, dedicated to supporting companies and organizations in their digital and organizational transformation.We firmly b...Show more
Last updated: 22 days ago • Promoted
Azure Integration Developer (34517)
Myticas LLC • Ottawa
Full-time
Our public-sector healthcare client is seeking.The consultants will design, build, and support Azure-based integration solutions, working closely with internal teams to deliver secure, scalable, an...Show more
Last updated: 7 days ago • Promoted
Senior Programmer (Salesforce Commerce Cloud)
Ateko, backed by Bell Canada • ottawa, on, ca
Full-time
Senior Programmer - Salesforce Commerce Cloud (SFCC) - remote contract.Salesforce Commerce Cloud (SFCC).Experience with Business Manager : management of product catalogs, promotions, users, site con...Show more
Last updated: 6 days ago • Promoted
Senior ILS Engineer
Marshall • Ottawa
Full-time
Marshall Canada is seeking a Sr.Engineer, Integrated Logistic Support (ILS) to join our team in Ottawa, ON.Reporting to the Senior Engineering Manager, ILS, this role is responsible for the deliver...Show more
Last updated: 22 days ago • Promoted
Senior ILS Engineer — Defense Programs (Ottawa)
Marshall Aerospace and Defence Group • Ottawa
Full-time
A leading defense contractor is seeking a Senior Engineer - Integrated Logistic Support in Ottawa.The role involves delivering and managing ILS activities for defense programs while ensuring compli...Show more
Role : Oracle Integration Cloud (OIC).Good knowledge in with Oracle Integration Cloud (OIC).Oracle SaaS modules and their integration touchpoints.
Exposure to REST / SOAP web services, XML, JSON and o...Show more
Last updated: 6 days ago • Promoted
Application Developer
QA Consultants Inc. • Ottawa
Full-time
In just three decades, ALTEN has emerged as a global leader in Research and Development, Engineering, Information Technology Services, Life Sciences, and Network Services.Our footprint spans across...Show more
Last updated: 22 days ago • Promoted
Programmer / Analysts – Level 2
MDOS Consulting • Ottawa
Full-time
We are looking for a Programmer / Analysts – Level 2 for our client who meets the following criteria : .Location of Work : On-site, NDHQ 60 Moodie Drive, Nepean Ontario.
The bidder must demonstrate curre...Show more
Last updated: 4 days ago • Promoted
Senior / Lead C++ Developer
Spiria • Outaouais
Full-time
We are looking for a Senior C++ Developer, with the possibility of filling multiple positions, including a Team Lead role, to collaborate on a wide range of innovative projects in partnership with ...Show more
Last updated: 18 days ago • Promoted
Mid Level Developer - Retail Platform - Hifyre
Hifyre • ottawa, on, ca
Full-time
Mid-Level Developer - Retail Platform.Hifyre has created the cannabis industry’s most advanced retail sales platform, leveraging data to deliver personalized, effective, consumer & partner engageme...Show more
Last updated: 2 days ago • Promoted
Data Analytics & Integrations Lead
Brookfield Renewable • Outaouais
Full-time
A leading renewable power company in Quebec is seeking a Coordinator for their Data Analytics and Integrations team.This role involves project management, ensuring customer-focused IT support, and ...Show more