Senior OFSAA / Datastage Developer

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 theGlobal Finance & Risk Technologygroup.

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.

#CapitalMarketsTech

#ScotiaTechnology

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. If you require technical assistance, pleaseclick here (https://www.scotiabank.com/careers/en/careers/technical-support-for-applicants.html) . 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.