Datastage Etl Developer

Toronto, ON, CA, Canada

Job Description

DataStage ETL Developer (Contract)


Toronto, ON, Canada (On-site)
Contract (12 months)
Published 3 days ago
IBM InfoSphere DataStage, SDLC Process Tools
SQL, UNIX Shell Scripting
Data Warehousing, ETL Development, Data Integration, Performance Tuning
Oracle, Flat Files, Excel Data Sources
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.

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD2528757
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Contract
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Toronto, ON, CA, Canada
  • Education
    Not mentioned