Talend Data Engineer

Scotiabank; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading bank in Canada seeks a Talend Data Engineer in Toronto to develop ETL workflows and improve database designs. This role will work collaboratively in a high-performance team, focusing on continuous integration practices and production support, with opportunities for professional development and community engagement through diverse programs.

Benefits

Diversity and Inclusion initiatives

Tuition assistance

Flexible vacation and personal days

Community engagement opportunities

Dynamic workspace

Qualifications

• 5+ years' experience as a Data Engineer.
• Proficiency in Talend Data Integration and database technologies.
• Experience with business intelligence tools like Tableau, SAS, and Power BI considered an asset.

Responsibilities

• Design, develop, test, and support ETL workflows in Talend.
• Implement changes to existing Database Model and support deployment of automated releases.
• Monitor and troubleshoot ETL jobs and data pipelines in Linux-based environments.

Skills

Talend Data Integration

Database Modeling

SQL

Salesforce Integration

Linux/Unix

Agile Methodology

Communication

Education

University degree in Computer Science or related discipline

Tools

AWS

Oracle Database

Jenkins

Jira

Autosys

Job description

Join to apply for the Talend Data Engineer role at Scotiabank

Join to apply for the Talend Data Engineer role at Scotiabank

Requisition ID: 227260

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

The Data Engineer will focus on application development and support in a Talend-based development environment. In a team-oriented atmosphere, the incumbent will work closely with the Technical Lead, Senior Data Engineers, Data Engineers, Business Analysts, and Quality Assurance Analysts in delivering solutions for our clients. The incumbent will be responsible for the end-to-end design and development, testing and implementation of ETL workflows and contribute to the overall Database Design. Development tools include but are not limited to Talend, Salesforce and various on-prem and cloud-based database technologies such as AWS (SQL) and Oracle.

Is this role right for you? In this role you will:

• 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
• Develop and manage batch jobs using Autosys, Control-M, or similar scheduling tools
• Monitor and troubleshoot ETL jobs and data pipelines in Linux-based environments
• Maintain documentation for ETL processes, data flows, and system configurations
  
  

Skills

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

• 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 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 with deployment processes and release pipelines. Ex: Jenkins, Bitbucket/Git
• Experience using Jira for backlog management
• Experience working in an Agile Team
• Experience with business intelligence tools like Tableau, SAS, and Power BI considered an asset
• Experience in hosted environments like Azure or AWS considered a strong asset
• Experience integrating with Salesforce and Kafka.
• Proficiency in Linux/Unix command-line tools and scripting (e.g., Bash, Shell).
• Experience with job scheduling tools like Autosys, Control-M, or Cron.
• 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.
• Talend certification(s) is a asset.
• 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
  
  

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.
• Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
• Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons.
  
  

Working location condition: 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.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Banking

Referrals increase your chances of interviewing at Scotiabank by 2x

Sign in to set job alerts for “Data Engineer” roles.

Richmond Hill, Ontario, Canada 3 days ago

Software Engineer, Backend (All Levels / All Teams)

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 3 weeks ago

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.