Responsibilities
- Collaborate with teammates to plan, design, develop, test, and support ETL workflows in Talend
- Design and/or implement changes to existing Database Model
- Design and implement stored procedures, functions and views to support the ETL workflows
- Participate in peer-reviews of solution designs and related code
- Package and support deployment of automated releases
- Analyze and resolve technical and application problems
- Provide Production Support and Release Support nights and weekends when required
- Assess opportunities for application and process improvement and prepare documentation of rationale to share with team members and other affected parties
- Work with teammates to roll-out and maintain continuous integration practices
- Adhere to high-quality development principles while delivering solutions on-time and on-budget
Requirements
- 5+ years’ experience as a Data Engineer
- University degree in Computer Science or a related discipline
- Extensive experience in Talend Data Integration, database design and development
- Experience with Database Modeling design patterns in any Database platform
- Proficient with SQL Server and/or Oracle Database Technologies
- Experience with deployment processes and release pipelines. Ex: Jenkins, Bitbucket/Git
- Experience using Jira for backlog management
- Experience working in an Agile Team
- Excellent communication skills to clearly articulate integration requirements to business users. Interaction with various business lines will be imperative for the success of the incumbent.
- Understanding of Cloud Hosted environments and related technologies
- Knowledge of various database modeling techniques including database theory, and a strong understanding of business data structures
- Work proficiently both independently and in a team environment
- Strong communication skills with both internal team members and external business stakeholders
- Strong initiative to find ways to improve solutions, systems, and processes
Nice to Have
- Experience with large Salesforce implementations – specifically Talend to Salesforce integration experience would be considered an asset
- Familiar with Integrating Salesforce with other cloud-based application systems using REST, SOAP API
- Experience in hosted environments like Azure or AWS considered a strong asset
- Experience with business intelligence tools like Tableau, SAS, and Power BI considered an asset
Work Arrangement
Remote (City/Region)
Additional Information
- Provide Production Support and Release Support nights and weekends when required
- 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.
