89594

Ottawa, Ontario

Contract

12 hours ago

Job Title: ETL Developer

Location: Ottawa, ON (Remote)

Estimated Duration: 12 Months

Name of Bid Solicitation Stream	Information Management / Information Technology Services
Roles Required	ETL Developer
Maximum Number of Resources to be Submitted	2
Expected Start Date	May 2026
Expected End Date	May 2027
Work Location and On-Site Requirement	Remote
Security Clearance Requirement	This work will require Reliability status. Candidates who are eligible to obtain the required clearance may be proposed, provided that the clearance is in place prior to the contract start date.
Language Requirement	English
Travel Requirement	N/A

Description of Service

The organization is seeking an ETL Developer who will be responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet the organization’s enterprise’s business analysis and reporting needs. The resource will also provide 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 will work with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource will ensure the functionality, security, availability and accuracy of the information within the Data Warehouse environment. The ETL developer will mainly work with DataStage and DataManager tools.

Primary Responsibilities

Design, maintain, and provide support for Data Warehouse systems and related DataMarts
Translate business requirements into viable technical solutions by coordinating with Product Owner, Business stakeholders as well as other relevant SMEs
Identify risks, impacts and dependencies while assessing new requirements to optimize delivery
Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment
Design and modify ETL logic using DataManager
Participate in the testing of developed technical solutions
Participate in the investigation and resolution of complex Data Warehouse issues
Proactively identify opportunities for process, systems, and other efficiency improvements
Work towards the team’s effectiveness through personal style

Specific Project Requirements, if any

There is a requirement for the resource to work on weekends and holidays (on a rotation) from 9:00AM to 11:00AM and be available on-call during this period for incidents that may arise. On?call time, incident response, and any hours worked during this period are included in the standard hourly rate. No additional compensation, overtime, or standby premiums will be paid for on?call services.

Skill and Qualification Requirements

Technical Skills Required:

Bachelor’s degree in business administration, Information Technology, or a related field with at least 8 years of experience
5+ years of hands-on experience with IBM’s ETL tool – IBM InfoSphere DataStage, including developing, testing, and deploying ETL solutions for large-scale enterprise environments.
Strong experience in IBM Cognos Data Manager
Experience with automated testing tools including developing and executing test cases to validate ETL processes and ensure data quality
Logical and physical data modelling
Requirements gathering and analysis with the ability to translate business questions and requirements into actionable technical solutions
Technical design and technical writing skills
Experience with SQL Server, including developing and optimizing queries, managing database objects, and performing troubleshooting for performance issues
Strong understanding of integration testing, demonstrated by planning and executing test strategies
Experience with Azure DevOps and requirement management

Soft Skills Required:

Excellent analytical and problem-solving skills
Effective communication and interpersonal skills
Ability to work independently and as part of a team
Excellent collaboration skills to work effectively with cross-functional teams and stakeholders, fostering a positive and productive environment

Assets:
• Bilingual (French and English)

The pay range that the employer reasonably expects to pay for this position is between CA$70.00 and CA$90.00

Our voluntary benefits offering includes medical, dental, vision and retirement benefits.

This posting is for an existing vacancy.

If you believe this post to be fraudulent, please report by clicking here

Tundra Technical Solutions is a global workforce and technology delivery firm, ranked by Staffing Industry Analysts as one of the largest in North America. At Tundra, we aren't just hiring top talent at the world's most recognizable brands; we are pioneers of social recruitment. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other legally protected characteristics. We welcome and encourage diversity in the workplace.

We use artificial intelligence tools to help our recruiters screen and assess talent. These tools do not replace human decision making in the process.

Not interested in this position, but know somebody who might be? Check out our Referral Reward Program, referrals are a big secret behind our success. As always, we’re on the lookout for great people. And we know that you know great people!