City : Toronto, ON, CA, M5H1H1

Category : Computer Software Engineer, Applications

Industry : Finance

Employer : Scotiabank

Requisition ID: 176447

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

The Team  
Global Business Banking Risk Technology provides the project, change, & development management and services of non-retail enterprise risk systems to support the Global Risk Management (GRM) business lines.  

The Role  
We are looking for an ETL (DataStage) Developer to join the Global Business Banking Risk Technology team and own the following responsibilities: 
•    Support of design and development of new regulatory and risk requirements from our business partners 
•    Updating existing DataStage routines to support downstream consumers of business banking data 
•    Deploying updated programs to various environments  

Some of the Key Accountabilities include: 
•    Design and develop Data Stage routines 
•    Identify complex process and systems solutions to address major system needs 
•    Design and develop Unix Shell scripting and writing complex SQL queries 
•    Debug, troubleshoot and performance tune the Data Stage jobs 
•    Write unit tests, mocks, participate in code reviews 
•    Perform change management activities such as source code management, creating activity records for production implementation, creating implementation plans 

What You Will Bring to Succeed  

•    At least 8+ years of strong Data stage ETL experience. 
•    Candidate should be able to work independently by understanding the design document and handle application development, testing and QA support. 
•    Prior XML knowledge (reading from XML files and writing to XML files) would be added advantage. 
•    Should be able to design, develop and test the Data Stage Jobs (Server, Parallel, Sequence) 
•    Strong SQL knowledge and skilled and experienced in working with relational database structures 
•    Should be able to design and implement Data warehousing applications 
•    Should be able to design and create Unix shell scripts for the given requirements 
•    Should be able to design and create SQL query for the given requirements 
•    Strong Database modelling experience. 
•    Banking/Financial Risk experience. 
•    Experience working in Agile environment 

The Workplace 
•    This is a hybrid position. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office and from home with the details to be determined based on business needs. 
•    We are technology partners who help the business transform how our employees around the world work  
•    We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!  
•    You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world  
•    We foster an environment of innovation and continuous learning 
•    We care about our people, allowing them to design how they work to deliver amazing results  
•    We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation  

Scotiabank 
As Canada's International Bank, we are a diverse and global team. We speak more than 100 languages with backgrounds from more than 120 countries. 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. 

Is this Role not the Exact fit?  
Sign up to stay in touch; we’ll let you know when we have new positions on the team

#scotiatechnology

#LI- Hybrid

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.