DataStage ETL Developer (contract)

Capgemini; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A global technology consulting firm in Toronto is seeking a DataStage ETL Developer for contract work. The role involves designing and developing ETL jobs, integrating data from various sources, and optimizing performance. Ideal candidates are proficient in IBM InfoSphere DataStage and SQL, with strong analytical and communication skills. This position offers a hybrid work arrangement, requiring in-person meetings and collaboration.

Benefits

Medical benefits

Dental benefits

Vision benefits

Retirement benefits

Qualifications

• Advanced proficiency in IBM InfoSphere DataStage.
• Strong SQL / UNIX skills.
• Hands-on experience with data warehousing concepts.

Responsibilities

• Design, develop, and maintain ETL jobs using IBM InfoSphere DataStage.
• Integrate and transform data from multiple sources into systems.
• Perform troubleshooting and performance tuning of DataStage jobs.

Skills

Data Integration

Performance Tuning

Communication

Collaboration

Analytical Thinking

Tools

IBM InfoSphere DataStage

SQL

UNIX

Oracle

Job description

Join to apply for the DataStage ETL Developer (contract) role at Capgemini

2 days ago Be among the first 25 applicants

Join to apply for the DataStage ETL Developer (contract) role at Capgemini

We are seeking a DataStage ETL Developer to support enterprise data integration initiatives and deliver high-performance ETL solutions. This role requires advanced proficiency in IBM InfoSphere DataStage, strong SQL / UNIX skills, and hands-on experience with data warehousing concepts. You will be responsible for developing, optimizing, and maintaining ETL pipelines that ensure data quality, reliability, and performance across diverse data sources.

Key Responsibilities

• Design, develop, and maintain ETL jobs using IBM InfoSphere DataStage 11.5 / 11.7.
• Integrate and transform data from multiple sources such as Oracle, Excel, and flat files into staging and target systems.
• Build robust sequence jobs using components like Job Activity, Wait for File, Exception Handler, Sequencer, and more.
• Perform troubleshooting and performance tuning of DataStage jobs to ensure efficient processing.
• Participate in code reviews, documentation, and deployment processes aligned with SDLC best practices.
• Collaborate with onshore and offshore teams for seamless delivery and knowledge sharing.
• Engage in business meetings and translate requirements into scalable ETL designs.

Technical Profile

• IBM InfoSphere DataStage (11.5 / 11.7)
• SQL (Oracle or similar RDBMS)
• UNIX shell scripting and commands
• Experience with ETL performance tuning and job monitoring
• Understanding of data warehousing and data modeling concepts

Functional Profile

• Strong communication and collaboration skills
• Ability to work in a hybrid onsite-offshore delivery model
• Experience with client-facing discussions and technical walkthroughs
• Exposure to the Wealth Management domain (preferred)
• Familiarity with structured SDLC and documentation practices

Skills Summary

Core Expertise :

Data Warehousing, ETL Development, Data Integration, Performance Tuning

Languages & Frameworks

SQL, UNIX Shell Scripting

Database & Messaging

Oracle, Flat Files, Excel Data Sources

Other Tools & Technologies

IBM InfoSphere DataStage, SDLC Process Tools

Soft Skills

Analytical Thinking, Troubleshooting, Communication, Collaboration, Stakeholder Engagement

Note : Face-to-face interview and background check are mandatory. This role is hybrid in Toronto (3 days onsite, moving to 4 starting September). A Capgemini meet-and-greet is required before assignment start. If travel is involved and the offer is declined post-selection, the vendor assumes travel costs.

The pay range that the employer in good faith reasonably expects to pay for this position is $32.39 / hour - $50.61 / hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. 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 applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers : we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment : client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Seniority level

Seniority level

Not Applicable

Employment type

Employment type

Contract

Job function

Job function

Business Development and Sales

IT Services and IT Consulting

Referrals increase your chances of interviewing at Capgemini by 2x

Sign in to set job alerts for “ETL Developer” roles.

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

Full Stack Software Engineer I, Analytics Platform

Software Developer Full Stack (Junior) 9063-1115

Mississauga, Ontario, Canada CA$65,000.00-CA$80,000.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.