Sr. iWay ETL Engineer

3 weeks ago

Toronto ON, Canada Tundra Technical Solutions Inc. Full time

Story Behind the Need

Business group: CRM, Sales & Branch Performance - Performance engineering team, part of Customer Servicing engineering in Scotia Digital, focused on providing solutions that assist front line staff across channels in deepening relationship with customers, providing better service and offering better products to them, and help improve sales & productivity along the way.

The group is a mix of architects, technology leads, business systems analysts, designers, SMEs, developers, and testers who innovate and transform, develop customer servicing technology roadmaps, ensure end-to-end project delivery, support day to day operations, write technical stories, develop and test code, manage stakeholders and related teams.

Project: to deliver changes for the Partial Mortgage Insurance Coverage project – new product for mortgage insurance that will be allowing customer to choose a lower % of mortgage insurance coverage as alternative options; On the project developer will be doing design, development, testing, individual or unit testing, in collaboration with other technical teams to work on interface. Phase of project: requirements gathering done, at phase of design/development.

Candidate Value Proposition

The successful candidate will have the opportunity to collaborate with other technical teams and learn other technologies used within the Bank; be part of a working environment that encourages creativity, curiosity, and celebrates success; will get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world – for a top 5 Canadian Bank.

Typical Day In Role

The Sr. iWay ETL Engineer is responsible for design and development of ETL solutions to for complex business and technology initiatives. Along with providing thought leadership, they will help navigating us through production issues and investigations, and being a key advocate of efficiency and continual improvement as we work to modernize

  • Analyze and estimate effort for new scope and requirements
  • Design and development ETL solutions on multiple complex initiatives.
  • Stay abreast of modern technologies and best practices, and recommend introduction of new technology and processes
  • Act as the Subject Matter Expert and manage admin functions for ETL and iWay
  • Investigate failures, perform root cause analysis, and implement fixes; utilize internal defect tracking tool to create detailed, high quality error report
  • Work with product owners and test engineers to support QA processes, review test plans, test coverage and help improve test automation
  • Tech Stack: iWay iSM and Data Migrator – back-end

Candidate Requirements/Must Have Skills

  • 10 years’ experience as a developer
  • 3+ years’ hands-on iWay iSM (iWay Service Manager) and DM (Data Migrator) development experience
  • 3+ years’ SQL/plSQL and database programming (Preferably DB2)
  • 5+ years’ experience with deployment processes and release pipelines. Eg: Jenkins, Bitbucket/Git Unix/AIX script experience
  • 5+ years’ experience with data modeling and mapping

Nice-To-Have Skills

  • Experience in agile methodologies like SCRUM/Kanban
  • Developer experience from FI/ banking
  • Experience with SaaS/cloud solution integration with ETL
  • Experience with performance tuning and optimization

Soft Skills Required

  • Strong communication skills
  • Ability to work in cross functional teams

Education

Bachelors in technical field e.g., computer science, engineering

Best VS. Average Candidate

Ideal candidate needs to be ok with flexible hours; is a strong team player; resourceful; requires minimal hand holding as a is a senior role; strong with the technical capabilities outlined in must haves

Candidate Review & Selection

1 round – MS Teams Video Interviews

45 minutes – technical panel interview with HM and other team members – no live coding but technical questions on skillset

Job 70235

#J-18808-Ljbffr

  • Sr. iWay ETL Engineer

    4 weeks ago

    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Story Behind the NeedBusiness group: CRM, Sales & Branch Performance - Performance engineering team, part of Customer Servicing engineering in Scotia Digital, focused on providing solutions that assist front line staff across channels in deepening relationship with customers, providing better service and offering better products to them, and help improve...

  • Sr. iWay ETL Engineer

    4 weeks ago

    Old Toronto, Canada Tundra Technical Solutions Inc. Full time

    Story Behind the NeedBusiness group: CRM, Sales & Branch Performance - Performance engineering team, part of Customer Servicing engineering in Scotia Digital, focused on providing solutions that assist front line staff across channels in deepening relationship with customers, providing better service and offering better products to them, and help improve...

  • Sr. Data Engineer to Develop Data Quality and Data Profiling solutions using ETL, Talend and Da[...]

    7 days ago

    Old Toronto, Canada S I Systems Full time

    Sr. Data Engineer to Develop Data Quality and Data Profiling solutions using ETL, Talend and DataStage for our large banking client - 34154Sr. Data Engineer to Develop Data Quality and Data Profiling solutions using ETL, Talend and DataStage for our large banking client - 34154 Location Address: Downtown Toronto (1-2 days a week) Contract Duration: 1 year ...

  • Sr. Data Engineer to Develop Data Quality and Data Profiling solutions using ETL, Talend and Da[...]

    1 week ago

    Old Toronto, Canada S I Systems Full time

    Sr. Data Engineer to Develop Data Quality and Data Profiling solutions using ETL, Talend and DataStage for our large banking client - 34154Sr. Data Engineer to Develop Data Quality and Data Profiling solutions using ETL, Talend and DataStage for our large banking client - 34154 Location Address: Downtown Toronto (1-2 days a week) Contract Duration: 1 year ...

  • Sr. Azure Data Engineering Specialist

    3 weeks ago

    Toronto, Canada CGI Full time

    Title: Sr. Azure Data Engineering Specialist (Databricks and Synapse) Location: This role can be situated anywhere in Canada within proximity to a CGI office Are you an experienced Azure Data Engineering professional interested in working in a talented and collaborative team developing Cloud, Data and AI solutions for leading global clients? Do you...

  • Sr. Azure Data Engineering Specialist

    3 weeks ago

    Toronto, Canada CGI Full time

    Title: Sr. Azure Data Engineering Specialist (Databricks and Synapse) Location: This role can be situated anywhere in Canada within proximity to a CGI office Are you an experienced Azure Data Engineering professional interested in working in a talented and collaborative team developing Cloud, Data and AI solutions for leading global clients? Do you...

  • Sr. Azure Data Engineering Specialist

    3 weeks ago

    Toronto, Canada CGI Full time

    Title:Sr. Azure Data Engineering Specialist (Databricks and Synapse) Location:This role can be situated anywhere in Canada within proximity to a CGI officeAre you an experienced Azure Data Engineering professional interested in working in a talented and collaborative team developing Cloud, Data and AI solutions for leading global clients? Do you regularly...

  • Sr. Azure Data Engineering Specialist

    3 weeks ago

    Toronto, Canada CGI Full time

    Title:Sr. Azure Data Engineering Specialist (Databricks and Synapse)Location:This role can be situated anywhere in Canada within proximity to a CGI officeAre you an experienced Azure Data Engineering professional interested in working in a talented and collaborative team developing Cloud, Data and AI solutions for leading global clients? Do you regularly...

  • Sr Data Engineer

    3 weeks ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA).Data Engineer Responsibilities-Create and...

  • Sr Data Engineer

    1 week ago

    Toronto, Ontario, Canada NTT DATA Services Full time

    Req ID: NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA).Data Engineer Responsibilities-Create and...

  • Sr Data Engineer

    3 weeks ago

    Toronto, Canada NTT DATA Services Full time

    Req ID: 276517  NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Sr Data Engineer to join our team in Toronto, Ontario (CA-ON), Canada (CA). Data Engineer...

  • Sr. Java Developer

    3 weeks ago

    Toronto, ON, Canada Themesoft Inc. Full time

    Position: Sr. Java DeveloperLocation: Toronto, On – HybridSkills: Java, Scala, Spring, Spark, SQL Server, Git, ReactJob Description:Effective and clean code development based on requirements.Perform unit testing & integration testing.Optimize current ETL code.Assist support team on debugging production issues.RegardsPatrick FernandezStrategic Recruitment...

  • Sr. Java Developer

    3 weeks ago

    Toronto, ON, Canada Themesoft Inc. Full time

    Position: Sr. Java DeveloperLocation: Toronto, On – HybridSkills: Java, Scala, Spring, Spark, SQL Server, Git, ReactJob Description:Effective and clean code development based on requirements.Perform unit testing & integration testing.Optimize current ETL code.Assist support team on debugging production issues.RegardsPatrick FernandezStrategic Recruitment...

  • Senior ETL Developer, Scotiabank

    3 weeks ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 184466Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us through...

  • Senior ETL Developer, Scotiabank

    1 week ago

    Old Toronto, Canada Fossbytes Media Pvt Ltd Full time

    Requisition ID: 184466Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us...

  • Senior ETL Developer, Scotiabank

    1 week ago

    Old Toronto, Canada Fossbytes Media Pvt Ltd Full time

    Requisition ID: 184466Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us...

  • Senior ETL Developer, Scotiabank

    3 weeks ago

    Old Toronto, Canada Fossbytes Media Pvt Ltd Full time

    Requisition ID: 184466Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us...

  • Senior ETL Developer, Scotiabank

    3 weeks ago

    Old Toronto, Canada Fossbytes Media Pvt Ltd Full time

    Requisition ID: 184466Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us...

  • Senior ETL Developer, Scotiabank

    3 weeks ago

    Old Toronto, Canada Fossbytes Media Pvt Ltd Full time

    Requisition ID: 184466Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us...

  • DataStage Developer

    7 days ago

    Toronto, ON, Canada Iris Software Inc. Full time

    Iris's direct client, one of the leading Banking and Financial Company, is looking to hire a Sr ETL /DataStage Developer for a long term opportunity at Toronto, Ontario (Hybrid Position). Please respond back with your most recent resume if you would be interested..!Job Title: Sr. ETL/DataStage Developer Location: Toronto, ON (Hybrid Role – 3 Days Onsite...