Senior Datastage Developer

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

  • Sr Datastage Developer

    3 weeks ago

    Toronto, Canada Iris Software Inc. Full time

    Hi ,I hope you're doing well.We have a great opportunity with one of IRIS's Banking clients in Canada is looking for the Sr Datastage developer with SQL in Toronto Canada Hybrid . Please Share your Resume if you are interestedHybrid- from office.DataStage Developer ResponsibilitiesDesign, develop, and maintain DataStage ETL jobs according to...

  • Sr Datastage Developer

    3 weeks ago

    Toronto, Canada Iris Software Inc. Full time

    Hi ,I hope you're doing well.We have a great opportunity with one of IRIS's Banking clients in Canada is looking for the Sr Datastage developer with SQL in Toronto Canada Hybrid . Please Share your Resume if you are interestedHybrid- from office.DataStage Developer ResponsibilitiesDesign, develop, and maintain DataStage ETL jobs according to...

  • Sr Datastage Developer

    3 weeks ago

    Toronto, Canada Iris Software Inc. Full time

    Hi ,I hope you're doing well.We have a great opportunity with one of IRIS's Banking clients in Canada is looking for the Sr Datastage developer with SQL in Toronto Canada Hybrid . Please Share your Resume if you are interestedHybrid- from office.DataStage Developer ResponsibilitiesDesign, develop, and maintain DataStage ETL jobs according to...

  • DataStage developer

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

  • Sr Datastage Developer

    3 weeks ago

    Toronto, ON, Canada Iris Software Inc. Full time

    Hi , I hope you're doing well. We have a great opportunity with one of IRIS's Banking clients in Canada is looking for the Sr Datastage developer with SQL in Toronto Canada Hybrid. Please Share your Resume if you are interested Hybrid- from office. DataStage Developer Responsibilities Design, develop, and maintain DataStage ETL jobs according to...

  • Sr Datastage Developer

    3 weeks ago

    Toronto, ON, Canada Iris Software Inc. Full time

    Hi , I hope you're doing well. We have a great opportunity with one of IRIS's Banking clients in Canada is looking for the Sr Datastage developer with SQL in Toronto Canada Hybrid. Please Share your Resume if you are interested Hybrid- from office. DataStage Developer Responsibilities Design, develop, and maintain DataStage ETL jobs according...

  • Sr Datastage Developer

    4 weeks ago

    Toronto, Ontario, Ontario, Canada Iris Software Inc. Full time

    Hi ,I hope you're doing well.We have a great opportunity with one of IRIS's Banking clients in Canada is looking for the Sr Datastage developer with SQL in Toronto Canada Hybrid . Please Share your Resume if you are interestedHybrid- from office.DataStage Developer ResponsibilitiesDesign, develop, and maintain DataStage ETL jobs according to...

  • DataStage Developer

    3 weeks ago

    Toronto, Ontario, Ontario, Canada Iris Software Inc. Full time

    Greetings!Iris’s leading financial client is looking for DataStage Developer to join their team at Toronto, ON(Hybrid) location. Job Title: DataStage DeveloperLocation: Toronto, ON(Hybrid)Duration: Long Term Job Description:5+ years of work experience as a DataStage Developer Strong technical experience working with IBM Data Stage, SQL and Shell...

  • Datastage Developer

    3 weeks ago

    Toronto, Canada Iris Software Inc. Full time

    About the RoleWe are seeking a highly skilled Datastage Developer to join our team in Toronto, Canada. As a key member of our development team, you will be responsible for designing, developing, and maintaining Datastage ETL jobs according to specifications.Responsibilities:Design and develop high-quality Datastage ETL jobs that meet business...

  • Datastage Developer

    3 weeks ago

    Toronto, Ontario, Canada Iris Software Inc. Full time

    We are seeking a skilled Datastage Developer to join our team at Iris Software Inc., a leading provider of information technology solutions.The ideal candidate will have extensive experience in designing, developing, and maintaining Datastage ETL jobs according to specifications.Key Responsibilities:Design and develop Datastage ETL jobs to load data into the...

  • (Datastage/teradata/mainframe)

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

  • DataStage Developer

    3 days ago

    Toronto, ON-5140 Yonge St., Canada Cognizant Full time

    As a DataStage Developer you will create an impact by handling enterprise-level data management and transfer solutions using IBM's DataStage ETL interface. You will be a valued member of our AIA Practice. Cognizant's AIA Practice Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude...

  • DataStage Developer

    2 days ago

    Toronto, ON-5140 Yonge St., Canada Cognizant Full time

    As a DataStage Developer you will create an impact by handling enterprise-level data management and transfer solutions using IBM's DataStage ETL interface. You will be a valued member of our AIA Practice. Cognizant's AIA Practice Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude...

  • DataStage Developer

    2 days ago

    Toronto, ON-5140 Yonge St., Canada Cognizant Full time

    As a DataStage Developer you will create an impact by handling enterprise-level data management and transfer solutions using IBM's DataStage ETL interface. You will be a valued member of our AIA Practice. Cognizant's AIA Practice Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude...

  • Senior Datastage Developer for Large-Scale Data Integration

    3 weeks ago

    Toronto, Canada Iris Software Inc. Full time

    We are seeking an experienced Sr. Datastage Developer to join our team in Toronto, Canada. This is a hybrid role that requires both office and remote work.The successful candidate will design, develop, and maintain large-scale Datastage ETL jobs according to specifications, ensuring high performance and adherence to company standards. Additionally, they will...

  • Cognizant | DataStage Developer

    2 days ago

    toronto, Canada Cognizant Full time

    As a DataStage Developer you will create an impact by handling enterprise-level data management and transfer solutions using IBM's DataStage ETL interface. You will be a valued member of our AIA Practice. Cognizant's AIA Practice Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude...

  • Sr Datastage Developer

    3 weeks ago

    Toronto, Canada Iris Software Inc. Full time

    **Job Opportunity:**We are seeking an experienced Sr Datastage Developer with expertise in SQL to join our team at Iris Software Inc. in Toronto, Canada.**About the Role:The successful candidate will design, develop, and maintain Datastage ETL jobs according to specifications. This includes optimizing existing jobs for performance, reviewing job designs and...

  • Datastage Consultant

    3 weeks ago

    Toronto, Ontario, Ontario, Canada Themesoft Inc. Full time

    Position: Datastage ConsultantLocation: Toronto, OnJob Description:Experience as a Developer or Technical Systems AnalystExperience on Information Technology projects supporting an enterprise-wide environment.Strong technical experience working with IBM Data Stage, SQL and Shell scripting.Experience working on projects developing and implementing...

  • Senior data developer

    3 weeks ago

    Toronto, ON, Canada Iris Software Inc. Full time

    We have a great opportunity with one of IRIS's Banking clients in Canada is looking for the Sr Datastage developer with SQL in Toronto Canada Hybrid. Hybrid- from office. Optimize existing DataStage jobs for performance. Troubleshoot DataStage job failures and provide root cause analysis. Develop new DataStage jobs to load data into the data...

  • Senior Data Integration Specialist

    3 weeks ago

    Toronto, Canada Iris Software Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Data Integration Specialist to join our team in Toronto, ON. This is a long-term opportunity with a competitive salary.Job Description5+ years of experience as a DataStage DeveloperStrong technical expertise in IBM Data Stage, SQL, and Shell scripting