Title:  Programmer Analyst Advisory, DataStage

Requisition ID: 228282

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

Purpose

Contributes to the overall success of the Client Engineering team in Canada ensuring specific individual goals, plans, initiatives are executed / delivered in support of the team’s business strategies and objectives.  Ensures all activities conducted are in compliance with governing regulations, internal policies and procedures.

Accountabilities

• Champions a customer focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Provide technical analyses and recommendations in terms of new solutions and supporting existing ones, with a focus on creating robust and reusable solutions. 
• Develop ETL solutions and have experience using TALEND ETL tools.
• Assessing the systems architecture currently in place and working with technical staff to recommend solutions to improve it.  Work towards improving stability and decreasing vulnerabilities across the platform.  
• Create and maintain documentation, such as architectural diagrams and best practices documents. 
• Manages the execution of day-to-day project-oriented work efforts and meeting customer expectations for contracted time, cost and specifications definitions. Reviewing requirements, estimating work effort on new initiatives, develop design documents (GDD) as well as File specs. 
• Build and maintain strong working relationship with peers within the business unit and with business partners
• Provides expert advice to Business Partner and/or IT areas, and IT project teams. 
• Operationalizes technical processes and accountable for the development and maintenance of technology systems. 
• Review and approve Production ready deployment. 
• Facilitates/resolve problem resolution when production problems occur.
• Ability to contribute in Agile environments with understanding of its methodologies (Scrum/Kanban) and its tools (Jira, Confluence, Azure DevOps). 
• Works well independently & as part of a team.
• Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions.
• Actively pursues effective and efficient operations of their respective areas in accordance with Scotiabank’s Values, its Code of Conduct and the Global Sales Principles, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational, compliance, AML/ATF/sanctions and conduct risk.

Education and experience

• 3+ years of experience as DataStage Developer or related field
• 3+ years of experience Hands-on experience with Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• 3+ years of experience Hands-on DataStage Manager, Designer, Administrator, and Director.
• 3+ years of experience Hands-on Big Data concept and platforms, such as Hadoop, Hive, Beeline, EDL
• Expertise in UNIX shell scripts using K-shell for the automation of processes and scheduling the DataStage jobs.
• Expert in designing Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Experienced in integration of various data sources (DB2-UDB, PL/SQL, Hadoop data) into data staging area.
• Experience in Agile development and tools, such as Jira, Confluence, Bitbucket, Jenkins, etc.
• Excellent knowledge of studying the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
• Proven track record in troubleshooting of DataStage jobs and addressing production issues like performance tuning and enhancement.
• Experienced in Database programming for Data Warehouses (Schemas), proficient in dimensional modeling.
• Experienced in Data Modeling as well as reverse engineering using tools Erwin and MS Visio.

What’s In It for You

• You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world.
• We foster an environment of innovation and continuous learning. We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
• We provide employees with an environment that is safe, inclusive, and reflective of all communities by promoting fair and equitable treatment and prioritizing unconscious bias and anti-racism training.
• We care about our people, allowing them to design how they work to deliver amazing results.
• We offer a competitive total rewards package, including a performance bonus, company matching programs (pension & Employee Share Ownership), generous vacation; health/medical/wellness benefits; employee banking privileges.
• When in person collaboration is required, you can take advantage of our new state of the art ecosystems with a design focus on enabling collaboration through both environment and technology.

#Li-Onsite

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, please click here. 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.