Senior Datastage Developer

4 months ago

Toronto, Canada Scotiabank Full time

Is this role right for you?

In this role you will: Develop strategies for Extraction, Transformation and Loading (ETL) mechanism. Design Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector. Integrate various data sources (DB2-UDB, SQL Server,  PL/SQL ,  Oracle , Teradata,  XML  and MS-Access) into data staging area. Work with Data Stage Manager, Designer, Administrator, and Director. Analyze the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development. Study the data dependencies using metadata stored in the repository and prepare batches for the existing sessions to facilitate scheduling of multiple sessions. Troubleshoot Data Stage jobs and address production issues like performance tuning and enhancement. Database programming for Data Warehouses (Schemas), proficient in dimensional modeling Perform UNIX shell scripts using K-shell for the automation of processes and scheduling the Data Stage jobs using wrappers. Use software configuration management tools like Rational Clear case/Clear quest for version control. Experience Data Modeling as well as reverse engineering using tools Erwin , Oracle Designer  and MS Visio, SQL server management studio, SSIS and SSRS and store procedure.

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

OFSAA configuration experience Experience in OFSAA FSDF experience Research and solve the data related issues within the OFSAA environment. Hands on Experience of 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's in it for you?

We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success We provide you with the tools and technology needed to create beautiful customer experiences. You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world Onsite cafeteria. Dress codes don't apply here, being comfortable does. We offer a competitive total rewards package that includes a base salary, a performance bonus, company matching programs (pension & profit sharing), generous vacation, personal & sick days, personal development funding, maternity leave top-up, parental leave and much more.

  • Senior Datastage Developer

    4 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

    4 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

    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 high-performance ETL solutions using IBM DataStage.Key ResponsibilitiesDesign and develop efficient ETL solutions using DataStageCollaborate with...

  • Senior Datastage Developer

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

  • DataStage developer

    4 days ago

    Toronto, Canada Tamanna Technology Full time

    DataStage DeveloperLocation: Toronto, ON (Hybrid – 3 days in office, 2 days remote)Industry: Banking / Financial ServicesDuration: [Permanent/Contract]Client: Direct Banking ClientAbout the Role:We are looking for a talented DataStage Developer to join our direct banking client in Toronto. The ideal candidate will have strong experience in IBM DataStage...

  • DataStage developer

    3 days ago

    Toronto, Canada Tamanna Technology Full time

    DataStage DeveloperLocation: Toronto, ON (Hybrid – 3 days in office, 2 days remote)Industry: Banking / Financial ServicesDuration: [Permanent/Contract]Client: Direct Banking ClientAbout the Role:We are looking for a talented DataStage Developer to join our direct banking client in Toronto. The ideal candidate will have strong experience in IBM DataStage...

  • (Datastage/teradata/mainframe)

    2 weeks ago

    Toronto, Canada NLB Technology Services Full time

    **Position: Senior ETL Developer (Datastage/Teradata/Mainframe)** **Location : Toronto, Ontario (Hybrid 3 Days)** **Position : Full time** We are seeking an experienced Senior ETL Developer to join our team. **Key Responsibilities**: - Participate in daily stand-ups and all project-related meetings from Data Delivery Squads - Deliver Impact Analysis and...

  • 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

  • ETL Developer

    2 weeks ago

    Toronto, Canada Viva Tech Solutions Full time

    5+ years of Data Warehouse ETL development experience with Datastage, SQL, Stored Procedures, Teradata BTEQ3+ years of Mainframe experience with Job Control Language(JCL), SYSIN, Zeke, DFSort, ICETools, etc.Experience with Devops techniques such as GitHub, JenkinsDesign new ETL jobs (Datastage/ SYSIN) or enhance existing jobs based on project...

  • ETL Developer

    2 weeks ago

    Toronto, Ontario, Ontario, Canada Viva Tech Solutions Full time

    5+ years of Data Warehouse ETL development experience with Datastage, SQL, Stored Procedures, Teradata BTEQ3+ years of Mainframe experience with Job Control Language(JCL), SYSIN, Zeke, DFSort, ICETools, etc.Experience with Devops techniques such as GitHub, JenkinsDesign new ETL jobs (Datastage/ SYSIN) or enhance existing jobs based on project...

  • Senior Application Developer – DataStage and Mainframe

    3 months ago

    Toronto, Canada Royal Bank of Canada> Full time

    Job SummaryJob DescriptionWhat is the opportunity?A Senior Developer in application development within Enterprise Technology, Digital.  Provides information on the detailed technical design and development of applications using existing and emerging technology platforms. Applies experience and seasoned knowledge, skills, and practices to perform a variety...

  • Datastage Developer Position

    4 weeks ago

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

    We are seeking an ETL Developer with BA experience to join our team at Futran Tech Solutions Pvt. Ltd. in Toronto, Canada. The ideal candidate will have a deep understanding of ETL and compatible coding languages (SQL, Python, VBA, etc); as well as investment co.Key Responsibilities:Design and implement ETL processes using Datastage.Develop and maintain ETL...

  • ETL Datastage Integration Specialist

    3 weeks ago

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

    Futran Tech Solutions Pvt. Ltd. is seeking an experienced ETL Datastage Developer to enhance our data integration capabilities. The ideal candidate will possess a solid understanding of ETL concepts, proficient in SQL, Python, and data visualization tools. Key responsibilities include designing and implementing data pipelines, ensuring data quality, and...

  • Senior Datastage Developer

    4 months ago

    Toronto, Canada Scotiabank Full time

    Requisition ID: 204049 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team We are looking for a Datastage Developer to join the Global Finance & Risk Technology group. Is this role right for you? In this role you will: Develop strategies for Extraction, Transformation and Loading...

  • Senior Datastage Developer

    4 months ago

    Toronto, Canada Scotiabank Full time

       Requisition ID: 204049Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team We are looking for a Datastage Developer to join the Global Finance & Risk Technology group. Is this role right for you? In this role you will: Develop strategies for Extraction, Transformation and Loading (ETL)...

  • Datastage ETL Developer

    4 days ago

    Toronto, Ontario, Canada Scotiabank Full time

    Scotiabank is a leading bank in the Americas, guided by its purpose: "for every future." This role offers an exciting opportunity to contribute to the bank's finance technology team.About the RoleThe primary responsibility of this position is to provide technical expertise in designing, coding, and documenting ETL processes for new initiatives. The...

  • Software Engineer with Datastage and ETL

    5 days ago

    Toronto, Canada Scotiabank Full time

       Requisition ID: 210538Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team  The primary role of Global Finance Technology is to work with the Bank's finance community to re-engineer finance processes to enhance effectiveness and efficiency.  The unit is also responsible for developing and...

  • Senior Manager Application Development

    7 days ago

    Toronto, Ontario, Canada Scotiabank Full time

    Job Description:We are seeking a highly experienced Senior Manager to lead our Application Development team at Scotiabank in Toronto, Canada.About the Role:The ideal candidate will have a strong background in technology and business, with experience in leading end-to-end IT development cycles. They will be responsible for managing resources, technology...

  • Senior Application Developer

    2 months ago

    Toronto, Canada Royal Bank of Canada Full time

    Job SummaryJob DescriptionWhat is the opportunity?A Senior Developer in application development within Enterprise Technology, Digital. Provides information on the detailed technical design and development of applications using existing and emerging technology platforms. Applies experience and season

  • Data Analyst

    4 weeks ago

    Toronto, Ontario, Canada ProViso Staffing Full time

    Job SummaryWe are seeking a highly skilled Data Analyst to join our team on a contract basis. The successful candidate will have the opportunity to work with our client, gaining exposure and experience in data governance.Key Responsibilities:Build and maintain ETL scripts to support data quality processes.Develop data quality rules to support GBM business...