Title:  ETL Integration Specialist with DataStage

Requisition ID: 234542

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 click here. 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.