ETL Developer
Job in
Ottawa, Ontario, Canada
Listing for:
Stafflink
Full Time
position
Listed on 2025-12-30
Job specializations:
-
IT/Tech
Data Engineer, Database Administrator, Data Analyst, IT Consultant
Job Description & How to Apply Below
Job Description
Roles and ResponsibilitiesDevelop, implement, and maintain ETL processes using IBM Info Sphere Data Stage 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 SkillsMinimum of eight years of related experience and knowledge.Recent experience working with Cognos Data Manager.At least five years of experience with IBM Info Sphere Data Stage.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.EducationA degree in Computer Science, Information Technology, or a related field is preferred.Nice-to-HavesExperience in a leadership or mentorship role within a data management team.Familiarity with cloud-based data solutions and integration.Certification in IBM Cognos or Data Stage 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.
Note that applications are not being accepted from your jurisdiction for this job currently via this jobsite. Candidate preferences are the decision of the Employer or Recruiting Agent, and are controlled by them alone.
To Search, View & Apply for jobs on this site that accept applications from your location or country, tap here to make a Search:
Search for further Jobs Here:
