Share this Job

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Title:  Software Engineer (Data/ETL)




Requisition ID: 142274

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



Job Purpose

Enterprise Risk Solutions team provides Technology and support services to Finance and various other business lines. Team is currently working on several modernization projects with highly complex migration and integrations with various internal systems. Looking for a experienced Software Engineer to help with the solution build, integration and deployments. To join our team, the individual must thrive on challenge, be proactive and dynamic, demonstrate initiative and "can do" attitude.


Key Accountabilities

  • Participate in all aspects of a systems development life cycle within the development team (Analysis, Design, Development, Test, QAT, Implementation and Production Support).
  • Play a lead role in requirements gathering and Integration design sessions using various ETL & Integration tools, established guidelines, patterns and standards
  • Technical Documentation, including application, security and end to end solution design and operational support documentation
  • Act as a subject matter expert in design and development with a comprehensive/detailed understanding of the functional and non-functional aspects of the solution.
  • Perform coding, unit testing, debugging, documenting and implementing of applications and scripts in collaboration with various other teams involved in the project.
  • Analyze existing or proposed enhancement requests to determine their feasibility and time estimates required;
  • Evaluate existing and new applications and upcoming technologies to meet user requirements;
  • Participates in the installation, configuration, upgrading and maintaining of servers specific to application software as required.
  • Perform data modeling for database design; and Analyze, maintain and implement security features for application development, servers, authentication and procedures
  • Prepare and execute nonfunctional test strategy, plan and test cases. Accountable for test results and ensuring system meets documented requirements. Participate in the resolution and retesting of problem logs
  • Analyze data requirements and identify data sources and requirements for data migrations, data conversion and data loads into various target applications / repositories   
  • Serve as the primary client interface on assigned projects; reviewing recommendations with clients and receiving approval to proceed; providing updates on project status, timelines, and problems; reviewing final outcomes with the client and obtaining their sign off that all work has been conducted in accordance with client requirements
  • Assist Project Leader to prepare project plans, prepare estimates of cost and schedule
  • Determining and developing cost benefit analyses for project justifications; developing projected budgets and resources needed to conduct the work; evaluating risk concerns and options; providing technical and non-technical input into the development of specifications for “requests for proposals” pertaining to external services / vendor


Functional Competencies

  • Experience with ETL tools such as DataStage, Informatica, Oracle ODI, SSIS, iWay or DataStage  in AIX, Windows, Linux environments is required.
  • Solid knowledge of big data and data warehousing concepts
  • Strong knowledge of Oracle databases, SQL Server, Hadoop cluster, Hive, Unix Shell Scripting, XML and encryption technologies is an asset.
  • Experience with Web services – SOAP, REST API
  • Experience in Reporting Tools like Tableau, SAP BO Crystal Reports, Microstrategy,SSRS
  • Programming in HTML/XML, .NET, ASP, Visual Basic, Java, PL/SQL, UNIX
  • Experience working on UNIX, Windows and Linux Operating Systems
  • Proficiency in data modeling and experienced in using Oracle, SQL Server as a developer / application DBA will be an asset.
  • Proficient in integration design patterns, best practices, integration / ETL tools
  • Strong Analytical skills coupled with excellent communication / presentation skills (both oral and written)
  • Excellent  team player by working with cross-departmental business & IT stakeholders,  ability to manage                conflicts
  • Experience in Financial Risk Management applications would be an asset.
  • Good knowledge of various networking protocols and terminology (TCP/IP, gateways, routers, firewalls, etc.)
  • Experience in designing and developing integration solutions for cloud based applications ie. cloud computing, service models - IaaS, PaaS, SaaS and deployment models – private, public, hybrid etc would be an asset.


Education and Experience

  • Bachelor’s Degree in Computer Science, Information Systems, Finance, Accounting or a business related discipline or equivalent work experience


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.

Job Segment: Database, Test Engineer, Testing, Cloud, Software Engineer, Technology, Engineering