Sql developer Jobs in Old toronto, ON

Is this role right for you?

In this role, you will:

• You will provide system analysis, design / programming, technical documentation, and support for existing and new applications and systems.
• You will work with project team to refine technical requirements and build the technical design and guidance based on the bank’s enterprise architecture standards.
• You will perform coding, unit testing, debugging, documenting, and implementing applications and scripts.
• You will create estimates and planning of development efforts required for various projects and enhancements.
• You will maintain, support, and enhance existing applications.
• You will participate in regular code reviews for release activities.
• You will work on the implementation of code to non-production and production environments.
• You will take a lead role in production issue analysis and perform root cause analysis for production issues and implementation issues.
• You will provide recommendations on best practices and enhancements that are in line with the bank’s technology road map.
• You will work with the product owners and business analysts in discovering the current system behavior and provide recommendations on improving the current system.
• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
• Actively pursues effective and efficient operations of his/her respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.
• Champion a high-performance environment and contributes to an inclusive work environment.

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

• Bachelor’s degree in computer science, Engineering, or related discipline is preferred.
• You have at least 5-8 years of technical work experience in systems analysis, design, development, unit testing, and debugging.
• Excellent interpersonal and communication skills to effectively liaise between Business Users, Project Teams, external Vendors and Technical Support Teams working in a geographically dispersed team
• In-depth knowledge of SDLC methodology and technical working experience in an agile environment.
• Comprehensive experience in mainframe development complex programs using Cobol, JCL, IMS DB, DB2, VSAM, CA7, SAS, Netron.
• Experience working in an agile environment / methodology / deployment (e.g. GIT, DevOps pipeline, JIRA, Confluence)
• Experience with Security and environment control systems (Endevor, ACF2), Database Management (e.g. IMS, DB2, VSAM, Informix)
• Development techniques, such as debugging, testing, coding, documentation, and use of productivity tools
• AIX / UNIX Command line expertise and shell script programming is required
• Experience working in banking industry is an asset
• Understanding of File Transfer protocols and processes ie. FTP, SFTP, PGP Encryption
• Understanding mainframe integration for ETL processing
• Experience with change management and version control
• Knowledge and understanding of Web Services
• Experience in writing/creating/updating technical documents
• Experience in batch job/process scheduling
• An understanding of current IT practices and systems development techniques

What's in it for you?

• Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
• Accessibility and Workplace Accommodations - 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. Scotiabank continues to locate, remove, and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
• Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
• Competitive Rewards program including bonus, flexible vacation, personal, sick days, and benefits will start on day one.
• Community Engagement - no matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs.