Talent.com
Stafflink
ETL DeveloperStafflink • Ottawa, ON
ETL Developer

ETL Developer

Stafflink • Ottawa, ON
30+ days ago
Job type
  • Full-time
Job description

Job Description

Roles and Responsibilities
  • 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

Developer/Analyst - Navacord

Navacordottawa, on, ca
Full-time

Navacord is hiring technical talent in the insurance industry! We are accepting applications for a dynamic individual with 5+ years experience in a full stack development environment and with at le... Show more

 • Promoted

Azure Databricks Engineer - ottawa

Tredence Inc.ottawa, on, ca
Full-time

We are seeking a skilled Azure Databricks Engineer with strong experience in Azure Data Factory (ADF) to design, develop, and maintain scalable data pipelines and analytics solutions on the Azure c... Show more

 • Promoted

Remote Data Engineer Focused on Scalable ETL and Client Solutions

ShyftLabsOttawa, Ontario, Canada
Remote
Full-time

Transform enterprise data challenges as a versatile Data Engineer.Engage directly with clients while developing robust ETL pipelines and data infrastructures for effective analytics and reporting.T... Show more

 • Promoted

Bilingual EDI & AS400/RPG Analyst/Developer - Q1 Technologies, Inc.

Q1 Technologies, Inc.gatineau, qc, ca
Permanent

Role: Bilingual EDI & AS400/RPG Analyst/Developer.Bilingual proficiency in English and French.Experience on AS400 programming- RPGLE, RPG, SQL, CL, CLLE.Proficiency with EDI and experience with Tru... Show more

 • Promoted

Software Business Analyst - ottawa

Alpha Bravo Developmentottawa, on, ca
Full-time

We’re a fast-growing software development agency that helps service-based businesses across the U.Our team values ownership, innovation, and building long-term partnerships with clients.We’re looki... Show more

 • Promoted

Data Integration Specialist - ETL Development - Snowflake - (Pharma / Life Science Domain)

Cygnus Professionals IncOttawa, ON, CA
Temporary

Data Integration Specialist - ETL Development - Snowflake - (Pharma / Life Science Domain).Be among the first 25 applicants.Direct message the job poster from Cygnus Professionals Inc.ETL Developer... Show more

 • Promoted

Bilingual EDI & AS400/RPG Analyst/Developer - ottawa

Q1 Technologies, Inc.ottawa, on, ca
Permanent

Role: Bilingual EDI & AS400/RPG Analyst/Developer.Bilingual proficiency in English and French.Experience on AS400 programming- RPGLE, RPG, SQL, CL, CLLE.Proficiency with EDI and experience with Tru... Show more

 • Promoted

Azure Databricks Engineer - Tredence Inc.

Tredence Inc.ottawa, on, ca
Full-time

We are seeking a skilled Azure Databricks Engineer with strong experience in Azure Data Factory (ADF) to design, develop, and maintain scalable data pipelines and analytics solutions on the Azure c... Show more

 • Promoted

Remote.NET Developer for ETL & Data Integrations

Absorb SoftwareOttawa, ON, CA
Remote
Full-time

A cloud-based learning management company is seeking an intermediate-level Developer to enhance an internal ETL tool.This fully remote role involves developing integrations between platforms like S... Show more

 • Promoted

Senior Elixir Developer

HiiveOttawa, ON, CA
Full-time

Hiive is a fintech startup building a marketplace for private pre-IPO companies.We are growing quickly and looking to hire a seasoned Elixir developer to our team.The ideal candidate will have subs... Show more

 • Promoted

ETL SDET with EDI experince.

Epsilon Solutions Ltd.Ottawa, ON, CA
Full-time

Team Lead Recruitment @ Epsilon Solutions Ltd.EDI (Electronic Data Interchange) experience is a must.Must-Have Skills: ETL Testing, Python, PySpark, AWS S3, Redshift, Kafka, Informatica, Complex SQ... Show more

 • Promoted

Data Migration Engineer I: ETL, Python & SQL

SpryPointOttawa, ON, CA
Full-time

A leading software company in North America seeks a Data Conversion Engineer I to support data migration efforts for utility clients.The role includes managing ETL processes, developing Python and ... Show more

 • Promoted

Workday Technical Analyst - ottawa

Modaxoottawa, on, ca
Full-time

Modaxo is looking for a proactive and skilled.In this role, you will contribute to the evolution of Workday from its current state to full adoption across our business, acting as a trusted partner ... Show more

 • Promoted

Intermediate C++ Software Developer (remote) - ottawa

Ateko, backed by Bell Canadaottawa, on, ca
Remote
Full-time

Development of software applications for our client focusing on informatics systems.The required candidate must, at a minimum, be expected to perform the following:.Write code for new features and ... Show more

 • Promoted

Web3 Product Analyst - ottawa

SINOFYottawa, on, ca
Full-time

We are a team of passionate Web3 enthusiasts turned venture capitalists, dedicated to investing in transformative startups.Our mission is to cut through the hype and support the creation of financi... Show more

 • Promoted

Lead Full-Stack Data Engineer — ETL & Insights

Chord StrategyOttawa, ON, CA
Full-time

A dynamic growth strategy consultancy in Metro Vancouver is seeking a Data Engineer to improve and maintain ETL processes.The ideal candidate is a leader comfortable with ambiguity and able to work... Show more

 • Promoted

Developer/Analyst - ottawa

Navacordottawa, on, ca
Full-time

Navacord is hiring technical talent in the insurance industry! We are accepting applications for a dynamic individual with 5+ years experience in a full stack development environment and with at le... Show more

 • Promoted

Tech Lead – EVR

Querentiaottawa, on, ca
Full-time

We are seeking an experienced Tech Lead – EVR to provide technical leadership, solution architecture guidance, and hands-on development oversight for enterprise-scale applications and platform tran... Show more

 • Promoted

Senior Software Developer, Back End and ETL

CGI NjoynOttawa, ON, CA
Permanent

Senior Software Developer, Back End and ETL.We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field.... Show more

 • Promoted

Remote Senior Data Engineer: Scalable ETL & Data Platform

LumenaltaOttawa, ON, CA
Remote
Full-time

A leading data engineering firm is seeking a Senior Data Engineer who can design and maintain effective ETL pipelines.The ideal candidate will have over 7 years’ experience and be proficient in Pyt... Show more