Search jobs > Toronto, ON > Etl developer

Senior Developer with Data stage ETL

Scotiabank
Toronto, ON, CA
$100K a year (estimated)
Full-time

Is this role right for you?

  • 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
  • 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

Do you have the skills that will enable you to succeed in this role?

  • 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

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 such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Work arrangements : Hybrid

LI-Hybrid

30+ days ago
Related jobs
S.i. Systems
Toronto, Ontario

Senior Snowflake and IICS Developer to support multiple ETL projects for the data migration of Oracle database to Snowflake. Develop and implement Snowflake solutions, including data modeling, ETL processes, and data warehousing. Collaborate with the project team to understand requirements and objec...

University Health Network
Toronto, Ontario

As an ETL Developer, you will be well-versed in Data preparation, Data Migration and ETL processes. Experience with ETL tools such as Azure Data Factory, SSIS or similar. Commensurate with experience and consistent with UHN compensation policy). You will apply business analysis and technical skills ...

Healthcare of Ontario Pension Plan
Toronto, Ontario

Experience in capital markets and financial industry, with exposure to vendor data onboarding and solutions. Experience with ETL/ELT tools, automation, schedulers, event-based design, cloud-native solutions, source code management, and CI/CD. Strong interpersonal and communication skills with an abi...

Astra North Infoteck Inc.
Toronto, Ontario

Transformation and Loading (ETL) processes using frameworks like Azure Data Factory or Synapse or Databricks; establishing the cloud connectivity between different system like ADLS ,ADF, Synapse, Databricks etc. Identifying reporting, and managing database security issues, user access/management; De...

Deloitte
Toronto, Ontario

As an Operations ETL Developer in the Technology Data Office Team, you will be responsible for delivering high quality modern data solutions using Azure technologies, where your work will have a meaningful enterprise-wide impact. Experience supporting Azure technologies (Data Lake Store, Data Factor...

HootSuite Media, Inc.
Toronto, Ontario

Senior Software Developer, Data. Create solid data foundations to power the data-driven product features. Demonstrated ability to analyze large data sets to identify gaps and inconsistencies, provide data insights, and advance effective product solutions. Independent in creating goals aligned with p...

S.i. Systems
Toronto, Ontario

Senior SAP Workflow Developer to design, develop, and optimize SAP workflows that streamline business processes with a focus on SCM - P2P & PO approvals. Workflow Development and Customization: Design and implement SAP workflows to automate business processes within SAP, including configuring workfl...

Dasro
Toronto, Ontario

We at Dasro, are hiring for a Microsoft Purview Expert for one of our client in Edmonton, AB with exp. We are seeking an expert to support the deployment of Data & Information Security Classification (DISC) using Microsoft Purview Information Protection technologies. Implement Sensitivity Labels for...

theScore
Toronto, Ontario

A solid foundation in computer science, with strong competencies in data structures, distributed systems, and software design. A strong grasp and experience with relational databases; including PostgreSQL and MySQL. Experience with consuming and integrating with third party APIs. Experience working ...

Arctic Wolf
Remote, Canada
Remote

Senior Developer - Data Ingestion & Pipeline. Have experience with databases, and database schema design (specifically PostgreSQL or another enterprise quality DB). We are growing rapidly, with our data volume increasing exponentially. We are looking for experienced developers to join our pack and w...