ETL Developer

1 month ago

Old Toronto, Canada Scotiabank Full time

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

We are seeking an energetic, self-starter willing to take on a challenge This position will deliver against current and new initiatives to support our Enterprise Crisis Management mandate by ensuring that specific goals, plans, initiatives are executed/delivered in support of the team’s business strategies and objectives through technology solutions. Ensures all activities conducted are in compliance with governing regulations, internal policies, and procedures.

The incumbent is responsible, through independent contribution, collaboration with our various business partners (Enterprise Crisis Management, Operational Resilience, Global Banking & Markets, Global Risk, Disaster Recovery, Third Party Risk Management and third-party vendor) and the management/supervision of Senior Manager, on the design, development, integration, and implementation of Fusion Enterprise Framework Systems across the Enterprise level. The individual must thrive on challenge, be proactive and dynamic, and demonstrate initiative and eagerness to learn.

Some of the key accountabilities include:

  • Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems, and knowledge.
  • Build best in class ETL solutions, and will be working closely with Product Owners, Developers, Scrum Masters, Project Management and Stakeholders.
  • Analyze highly complex business rules and logic and translating those into technical implementations.
  • Perform data wrangling to merge disjointed data sources and implement complex data transformation.
  • Develop ETL process using MS SQL Server BI stack, SQL Server Integration Services and MS Azure Data Factory to ingest, transform, cleanse and load data into on-prem SQL Server and/or Azure SQL DB.
  • Design and implement complex ETL pipelines using Azure Data Factory to efficiently ingest and transform data from multiple sources into Azure SQL Database.
  • Conduct source data analysis and profiling to complete source to target mapping.
  • Logical and physical data modeling to develop highly optimized data infrastructure for fast querying of large volume of data.
  • 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.
  • Champions a high-performance environment and contributes to an inclusive work environment.
  • Provide proactive support and maintenance to the existent ETL solutions to keep them at its best of quality.
  • Provides L2 production support investigations and resolutions. Take ownership of bugs, defects, enhancements, or any assignment from end to end.
  • Provide Production Support for BAU activities with stakeholders and vendor on issues support, maintenance & version upgrades etc.

What You Will Bring to Succeed

Must Have

  • Bachelor's degree in a technical field such as computer science, computer engineering or related field required.
  • 5 - 10 years of experience in designing, developing, and deployment of large-scale data warehouse projects from end to end.
  • Expert knowledge and hands on experience with SQL Scripting: 5 - 10 years.
  • Expert knowledge working with SQL Server SSIS, Integration Services Catalog and project deployment – 5+ years.
  • Experience working with Agile methodology – 5+ years.
  • Experience working with BitBucket or TFS, and creating DevOps pipeline – 5+ years.
  • Experience in Salesforce integration and configuration.
  • Working knowledge of dimensional data modeling methodology.
  • Strong English verbal and written communication skills.
  • Power BI.

Nice to Have

  • FI/Banking experience (North American Bank).
  • Previous experience in using the Fusion Risk Management System.
  • Experience working with data warehouse within Google Cloud Platform Degrees or certifications.
  • Have worked on either one of the following projects - Operational resilience, Disaster Recovery, Crisis and incident Management, Third Party Risk Management.

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

#J-18808-Ljbffr

  • ETL Developer

    1 month ago

    Old Toronto, Canada BeachHead Inc. Full time

    Do you seek challenges and personal development opportunities, and have the courage to make a difference? Are you a motivated, flexible, creative team player with perseverance, excellent multi-tasking abilities and a proven track record for meeting strict deadlines? Then, Apply Now! Working with one of the top financial clients, this role calls for an ETL...

  • Senior ETL Developer

    4 weeks ago

    Old Toronto, Canada LanceSoft Full time

    ${lang_code} Job Title: Sr. ETL Developer${lang_code} We are seeking an experienced ETL developer to join our team at LanceSoft. As a key member of our data integration team, you will be responsible for designing, developing, and implementing complex data pipelines using Azure Data Factory, Azure Synapse Analytics, and other ETL tools.Responsibilities:Design...

  • ETL Developer

    3 weeks ago

    Old Toronto, Canada ALLTECH CONSULTING SVC INC Full time

    About the RoleWe are seeking a highly skilled ETL Developer to join our team at ALLTECH CONSULTING SVC INC. As an ETL Developer, you will be responsible for designing, building, and maintaining complex data extraction, transformation, and loading processes using Informatica.The ideal candidate will have 10+ years of experience with data warehousing design...

  • Senior ETL Developer

    3 weeks ago

    Old Toronto, Canada Softline™ Technology Inc. Full time

    Data Warehouse SpecialistThis role is responsible for designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in Databricks for data warehousing, data lakes, and analytics. The specialist will work closely with data architects and business teams to ensure the efficient transformation and movement of data to meet business...

  • Sr. ETL Developer

    1 month ago

    Old Toronto, Canada LanceSoft Full time

    Title: Sr. ETL DeveloperLocation: Toronto, ON (Hybrid)Duration: 6 Months Contract with 6 Months possible extension.Job Description:Desired Skills and Experience5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns....

  • ETL Developer

    1 month ago

    Old Toronto, Canada Scotiabank Full time

    Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.We are seeking an energetic, self-starter willing to take on a challenge! This position will deliver against current and new initiatives to support our Enterprise Crisis Management mandate by ensuring that specific goals, plans, initiatives are...

  • Senior ETL Developer

    4 weeks ago

    Old Toronto, Canada Arthur Grand Technologies Inc. Full time

    About the RoleWe are seeking a highly skilled Senior ETL Developer to join our team at Arthur Grand Technologies Inc.The ideal candidate will have a strong background in data integration and a proven track record of success in designing and implementing data pipelines using Azure Data Factory.Key Responsibilities:Design and implement data pipelines using...

  • ETL Developer

    1 month ago

    Old Toronto, Canada Scotiabank Full time

    Requisition ID: 209195 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. We are seeking an energetic, self-starter willing to take on a challenge! This position will deliver against current and new initiatives to support our Enterprise Crisis Management mandate by ensuring that specific goals, plans,...

  • Guidewire ETL Developer

    1 month ago

    Old Toronto, Canada ShoreWise Consulting LLC Full time

    ShoreWise Consulting is a world class IT solution provider offering technology solutions and managed services in verticals such as Customer Contact, Healthcare and Finance (banking & trading).Job DescriptionInvestigate issues with ETL pipelines.Create and enhance data pipelines by performing ETL activities.QualificationsExperience working on Data Migration...

  • Software Developer

    1 month ago

    Old Toronto, Canada Arthur Grand Technologies Inc. Full time

    Company DescriptionArthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team...

  • Software Developer

    1 month ago

    Old Toronto, Canada LanceSoft Full time

    Role: Software Developer - ETL - SeniorLocation: Toronto, ON (Hybrid)Duration: 6 Months with Possible ExtensionCriteria 1: Data Migration, ETL - 40 PointsDemonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement.Demonstrated experience in integrating various data sources and systems,...

  • ETL Developer

    4 months ago

    Old Toronto, Canada ALLTECH CONSULTING SVC INC Full time

    Job Description: Responsibilities: Support the branch in developing and implementing the technical solutions needed as well as providing operational support ensuring that any technical glitch can be quickly addressed. Support the branch in data migration and data integration. Design technical solutions for data collecting and storing into our centralized...

  • Senior ETL Developer

    1 month ago

    Toronto, Ontario, Canada Arthur Grand Technologies Inc Full time

    Job Title: Senior ETL DeveloperJob Description:We are seeking a highly skilled Senior ETL Developer to join our team at Arthur Grand Technologies Inc. The ideal candidate will have a strong understanding of ETL principles, including data extraction, transformation, and loading processes.Key Responsibilities:Design and implement ETL processes using Azure Data...

  • ETL Developer

    3 weeks ago

    Toronto, Canada TEEMA Full time

    ETL Developer4+ months contract3 days onsite per week is required/Toronto LocationMust Haves:10 years using ETL tools such as Microsoft SSIS, stored procedures, T-SQL 2+ Delta Lake, Databricks and Azure Databricks pipelinesStrong knowledge of Delta Lake for data management and optimization.Familiarity with Databricks Workflows for scheduling and...

  • Guidewire ETL Developer

    3 weeks ago

    Toronto, Ontario, Canada ShoreWise Consulting Full time

    Job DescriptionAs a Guidewire ETL Developer at ShoreWise Consulting, you will leverage advanced-level SQL queries to investigate issues with ETL pipelines and create data pipelines by performing ETL activities.QualificationsExperience working on Data Migration projects with a primary focus on Guidewire is essential.Advanced-level hands-on experience in SQL...

  • Developer (ETL)

    3 weeks ago

    Toronto, Ontario, Ontario, Canada Tata Consultancy Services Full time

    "Skills and Responsibilities: •Knowledge of Informatica (Designer, workflow Manager, Monitor) skills. •Knowledge on Oracle Database (SQL, PL/SQL) •At least 4+ years hands-on experience on BDM •Knowledge on working on Hadoop systems (Hive and Impala) •Knowledge on developing Mappings, Mapplets, Sessions, Worklets, Workflows. •Knowledge on...

  • ETL Datastage Developer

    2 months ago

    Toronto, Canada Futran Tech Solutions Pvt. Ltd. Full time

    Datastage Developer Location Toronto, Canada Project Description: We are seeking an ETL Developer with BA experience to join our stimulating and dynamic team. The ideal candidate will have a deep understanding of ETL and compatible coding languages (SQL, Python, VBA, etc); as well as investment co

  • Senior ETL Developer

    1 month ago

    Toronto, Ontario, Canada Scotiabank Full time

    Are you a data integration expert looking for a new challenge?In this role, you will be responsible for designing and developing ETL solutions on multiple complex initiatives.You will work closely with product owners and test engineers to support QA processes, review test plans, and help improve test automation.Additionally, you will investigate failures,...

  • Senior ETL Developer

    2 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    About the RoleWe are seeking an experienced Senior ETL Developer to join our team at Scotiabank.The ideal candidate will have a strong background in developing strategies for Extraction, Transformation, and Loading (ETL) mechanisms, with experience in designing Server jobs using various types of stages. They should also be skilled in integrating multiple...

  • Senior ETL Developer Position

    4 weeks ago

    Toronto, Ontario, Canada Futran Tech Solutions Pvt. Ltd. Full time

    Role: Senior ETL Developer Location: Toronto, Canada (Candidate will be visiting the office 4 days per week)Job Overview: We are seeking an ETL Developer with BA experience to join our stimulating and dynamic team.About the Position: The ideal candidate will have 6+ years of capital markets experience and strong skills in data integration and ETL...