Senior Datastage Developer

3 weeks ago

Toronto, Ontario, Canada Scotiabank Full time
Job Title: Senior Datastage Developer

We are seeking a highly skilled Datastage Developer to join our Global Finance & Risk Technology group. As a Datastage Developer, you will be responsible for designing and implementing data extraction, transformation, and loading (ETL) mechanisms using Datastage.

Key Responsibilities:
  • Design and implement ETL processes using Datastage
  • Develop strategies for data integration and data quality
  • Work with data sources such as DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML, and MS-Access
  • Collaborate with Datastage Manager, Designer, Administrator, and Director
  • Analyze data dependencies and prepare batches for scheduling
  • Troubleshoot Datastage jobs and address production issues
  • Develop database programming skills for Data Warehouses (Schemas) and dimensional modeling
  • Perform UNIX shell scripting using K-shell for automation and scheduling
  • Use software configuration management tools like Rational Clear case/Clear quest for version control
  • Experience with Data Modeling and reverse engineering using tools Erwin, Oracle Designer, and MS Visio, SQL server management studio, SSIS, and SSRS
Requirements:
  • OFSAA configuration experience
  • Experience in OFSAA FSDF
  • Research and solve data-related issues within the OFSAA environment
  • Hands-on experience with Oracle 12C/19C, SQL, PL SQL, UNIX Shell Scripting, and Performance tuning
  • Experienced in OFSAA Data Foundation, Business Metadata management, Data Management Tools: like T2Ts, File Extracts, and Data Quality Framework, Data Entry Forms and Queries; Excel uploads; Atomic Schema Uploads, workflows in OFSAA
  • Experience with ERWIN DATA MODEL
  • Should have worked on sourcing data from multiple source systems
  • Exposure to Autosys
  • Data warehousing Skills
  • Willing to be on-call production support as needed in the night
What We Offer:
  • Inclusive and collaborative working environment
  • Tools and technology to create beautiful customer experiences
  • Opportunity to work with and learn from diverse industry leaders
  • Onsite cafeteria
  • Dress code-free environment
  • Competitive total rewards package

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

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.

  • Senior Datastage Developer

    3 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Title: Senior Datastage DeveloperWe are seeking a highly skilled Senior Datastage Developer to join our Global Finance & Risk Technology group. As a key member of our team, you will be responsible for designing and developing data integration solutions using Datastage.Key Responsibilities:Design and develop data integration solutions using Datastage,...

  • Senior Datastage Developer

    4 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Title: Senior Datastage DeveloperWe are seeking a highly skilled Datastage Developer to join our Global Finance & Risk Technology group. As a Datastage Developer, you will be responsible for designing, developing, and implementing data integration solutions using Datastage.Key Responsibilities:Design and develop data integration solutions using...

  • Senior Datastage Developer

    4 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Title: Senior Datastage DeveloperWe are seeking a highly skilled Datastage Developer to join our Global Finance & Risk Technology group. As a Datastage Developer, you will be responsible for designing, developing, and implementing data integration solutions using Datastage.Key Responsibilities:Design and develop data integration solutions using...

  • Senior Datastage Developer

    4 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Title: Senior Datastage DeveloperWe are seeking a highly skilled Datastage Developer to join our Global Finance & Risk Technology group. As a Datastage Developer, you will be responsible for designing, developing, and implementing data integration solutions using Datastage.Key Responsibilities:Design and develop data integration solutions using...

  • Senior Datastage Developer

    4 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Title: Senior Datastage DeveloperWe are seeking a highly skilled Datastage Developer to join our Global Finance & Risk Technology group. As a Datastage Developer, you will be responsible for designing, developing, and implementing data integration solutions using Datastage.Key Responsibilities:Design and develop data integration solutions using...

  • Senior Datastage Developer

    3 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    About the RoleWe are seeking a highly skilled Datastage Developer to join our Global Finance & Risk Technology group. As a Datastage Developer, you will be responsible for designing and developing data extraction, transformation, and loading (ETL) mechanisms using Datastage.Key ResponsibilitiesDesign and develop ETL processes using DatastageIntegrate various...

  • Senior Datastage Developer

    3 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    Requisition ID: 204049At Scotiabank, we're seeking a skilled Datastage Developer to join our Global Finance & Risk Technology group. This role offers an exciting opportunity to work with a talented team, leveraging your expertise in data extraction, transformation, and loading (ETL) to drive business success.The RoleWe're looking for a highly motivated and...

  • Senior Application Developer

    3 weeks ago

    Toronto, Ontario, Canada Royal Bank of Canada> Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our team in DataStage and Mainframe. As a key member of our team, you will be responsible for designing, developing, and deploying high-performance ETL solutions using IBM DataStage.Key ResponsibilitiesDesign and develop efficient ETL solutions using DataStageCollaborate with...

  • Senior Datastage Developer

    2 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    About the RoleWe are seeking a highly skilled Datastage Developer to join our Global Finance & Risk Technology group. As a Datastage Developer, you will be responsible for designing and developing data extraction, transformation, and loading (ETL) mechanisms using Datastage.Key ResponsibilitiesDesign and develop ETL processes using DatastageIntegrate various...

  • Senior Application Developer

    1 month ago

    Toronto, Ontario, Canada Royal Bank of Canada> Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our team in DataStage and Mainframe. As a key member of our team, you will be responsible for designing, developing, and deploying applications using DataStage and Mainframe technologies.Key ResponsibilitiesDesign and develop efficient ETL solutions using DataStage.Collaborate...

  • Senior Application Developer

    1 month ago

    Toronto, Ontario, Canada Royal Bank of Canada> Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our team in DataStage and Mainframe. As a key member of our team, you will be responsible for designing, developing, and deploying applications using DataStage and Mainframe technologies.Key ResponsibilitiesDesign and develop efficient ETL solutions using DataStage.Collaborate...

  • Senior Application Developer – DataStage and Mainframe

    1 month ago

    Old Toronto, Ontario, Canada RBC Full time

    Job SummaryRBC is seeking a highly skilled Senior Application Developer to join our team. As a key member of our technology team, you will be responsible for designing, developing, and deploying applications using DataStage and Mainframe technologies.Job DescriptionWhat is the opportunity?This is an exciting opportunity to work with a talented team of...

  • Senior Application Developer – DataStage and Mainframe

    1 month ago

    Old Toronto, Ontario, Canada RBC Full time

    Job SummaryRBC is seeking a highly skilled Senior Application Developer to join our team. As a key member of our technology team, you will be responsible for designing, developing, and deploying applications using DataStage and Mainframe technologies.Job DescriptionWhat is the opportunity?This is an exciting opportunity to work with a talented team of...

  • ETL Datastage Developer

    1 month ago

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

    ETL Datastage DeveloperFutran Tech Solutions Pvt. Ltd. is seeking an ETL Datastage Developer to join our team. The ideal candidate will have a deep understanding of ETL and compatible coding languages (SQL, Python, VBA, etc.)Key Responsibilities:Design and develop ETL processes using DatastageCollaborate with cross-functional teams to ensure seamless...

  • ETL Datastage Developer

    4 weeks ago

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

    ETL Datastage DeveloperFutran Tech Solutions Pvt. Ltd. is seeking an ETL Datastage Developer to join our team. The ideal candidate will have a deep understanding of ETL and compatible coding languages (SQL, Python, VBA, etc.)Key Responsibilities:Design and develop ETL processes using DatastageCollaborate with cross-functional teams to ensure seamless...

  • Senior Application Developer

    1 month ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our Enterprise Technology team. As a key member of our team, you will be responsible for designing, developing, and deploying applications using DataStage and Mainframe technologies.Key ResponsibilitiesCollaborate with project stakeholders to design and develop efficient ETL...

  • Senior Application Developer

    1 month ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our Enterprise Technology team. As a key member of our team, you will be responsible for designing, developing, and deploying applications using DataStage and Mainframe technologies.Key ResponsibilitiesCollaborate with project stakeholders to design and develop efficient ETL...

  • Senior Application Developer – DataStage and Mainframe

    2 months ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our team in Enterprise Technology, Digital. As a key member of our team, you will be responsible for designing, developing, and deploying applications using existing and emerging technology platforms.Key ResponsibilitiesProvide thought leadership and design highly efficient ETL...

  • Senior Application Developer – DataStage and Mainframe

    2 months ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our team in Enterprise Technology, Digital. As a key member of our team, you will be responsible for designing, developing, and deploying applications using existing and emerging technology platforms.Key ResponsibilitiesProvide thought leadership and design highly efficient ETL...

  • Senior Application Developer – DataStage and Mainframe

    1 month ago

    Toronto, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryWe are seeking a highly skilled Senior Application Developer to join our team in Enterprise Technology, Digital. As a key member of our team, you will be responsible for designing, developing, and deploying applications using existing and emerging technology platforms.Key ResponsibilitiesCollaborate with multiple project/program stakeholders to...