ETL Integration Specialist with DataStage

Scotiabank; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading financial institution is seeking a candidate in Toronto with strong ETL and data warehousing skills. The role includes providing technical expertise, supporting existing applications, and code review. Ideal candidates will have 5-7 years of experience in DataStage development, along with knowledge of other ETL tools and strong database skills. This position offers opportunities in a diverse and inclusive work environment.

Benefits

Flexible vacation

Tuition assistance

Health benefits from day one

Community engagement activities

Qualifications

• 5-7 years of DataStage development experience.
• 2 years of experience with ETL tools like Talend, SSIS, or Informatica.
• Strong Database expertise with SQL and performance tuning.

Responsibilities

• Provide technical expertise in ETL process design and documentation.
• Support existing applications and resolve issues independently.
• Perform code review of technical consultants and oversee their work.

Skills

Data warehousing

ETL processes

Shell scripting

Python scripting

SQL

DevOps practices

Tools

DataStage

Talend

SSIS

Informatica

Autosys

Control M

Jenkins

Git

Azure DevOps

Job description

Requisition ID: 234542

Overview

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

The Team

The primary role of Global Finance Technology is to work with the Bank's finance community to re-engineer finance processes to enhance effectiveness and efficiency. The unit is also responsible for developing and implementing Financial and MIS applications services to meet the changing needs of Finance and the Bank. These applications have an enterprise-wide user community, and are an integral part of Finance's performance measurement, reporting and control infrastructure.

The Role

The successful candidate will have a strong foundation in Data warehousing, ETL processes, and scheduling.

What You’ll Do

• Provide technical expertise in designing, coding, and documenting ETL processes for new initiatives.
• Independently support existing applications and resolve issues.
• Estimate and deliver on individual tasks within project.
• Perform code review of code developed by technical consultants and oversee their work.
• Highlight technical issues, challenges and propose creative solutions.

What You Will Bring to Succeed

• 5-7 years of DataStage development experience
• 2 years of experience with any other ETL tools like Talend, SSIS, Informatica, etc.
• Experience with Shell and Python scripting
• Strong Database expertise (SQL, Performance tuning, Data modeling)
• Experience with scheduling tools like Autosys or Control M
• Experience with DevOps practices and CI/CD tools (Jenkins, Git, Azure DevOps, etc.)

What’s In It for You

• Diversity, Equity, Inclusion & Allyship – Be part of a culture that celebrates individuality and empowers every employee to thrive
• Accessibility & Accommodations – We’re committed to removing barriers and creating an inclusive workplace for all
• Upskilling & Growth – Access online courses, cross-functional development, and tuition assistance to fuel your career
• Competitive Rewards – Enjoy flexible vacation, personal and sick days, and benefits starting on day one
• Community Engagement – Join hackathons, contests, cooking clubs, and programs like Humans of Digital to connect and belong

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please contact the Recruitment team. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.