Programmer Analyst Advisory, Datastage

Scotiabank; Canada; On-site; CAD 85,000 - 120,000; Full time

Job summary

Scotiabank is looking for a DataStage Developer to join their Client Engineering team in Toronto, Canada. This role involves developing ETL solutions, enhancing system architecture, and collaborating in an Agile environment. Candidates should have significant experience with DataStage, Strong problem-solving skills, and a commitment to compliance and operational excellence.

Benefits

Flexible work arrangements

Competitive rewards including bonuses

Generous vacation

Health benefits

Inclusive work environment

Qualifications

• 3+ years experience as a DataStage Developer.
• Proficiency in UNIX shell scripting for DataStage jobs.
• Experience with Big Data platforms such as Hadoop and Hive.

Responsibilities

• Develop and maintain ETL solutions using DataStage.
• Create architectural documentation and best practices.
• Ensure compliance with technical processes and risk controls.

Skills

Problem Solving

Data Modeling

Troubleshooting

Agile Methodologies

Education

Bachelor's Degree in Computer Science or related field

Tools

DataStage

Jira

Confluence

Azure DevOps

UNIX

Job description

Requisition ID: #

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

Purpose

Contributes to the success of the Client Engineering team in Canada by executing individual goals, plans, and initiatives that support the team’s business strategies and objectives. Ensures all activities comply with regulations, policies, and procedures.

Accountabilities

1. Champion a customer-focused culture to deepen client relationships and leverage broader bank relationships, systems, and knowledge.
2. Provide technical analyses and recommendations for new and existing solutions, focusing on creating robust, reusable solutions.
3. Develop ETL solutions using TALEND ETL tools.
4. Assess current system architecture and collaborate with technical staff to recommend improvements, enhancing stability and reducing vulnerabilities.
5. Create and maintain documentation such as architectural diagrams and best practices.
6. Manage day-to-day project efforts, review requirements, estimate work efforts, and develop design documents.
7. Build and maintain strong relationships within the business unit and with partners.
8. Provide expert advice to business and IT teams.
9. Operationalize technical processes, develop, and maintain technology systems.
10. Review and approve production deployments and resolve issues when problems occur.
11. Contribute effectively in Agile environments, understanding methodologies like Scrum and Kanban, and tools such as Jira, Confluence, and Azure DevOps.
12. Work independently and as part of a team.
13. Consider the bank’s risk appetite and culture in daily activities and decisions.
14. Ensure operational, compliance, AML/ATF, sanctions, and conduct risk controls are adhered to.

Education and Experience

1. 3+ years as a DataStage Developer or related field.
2. 3+ years experience with Parallel jobs in DataStage, using stages like Join, Merge, Lookup, etc.
3. 3+ years experience with DataStage Manager, Designer, Administrator, and Director.
4. Experience with Big Data platforms such as Hadoop, Hive, Beeline, EDL.
5. Expertise in UNIX shell scripting (K-shell) for automation and scheduling DataStage jobs.
6. Proficient in designing Server jobs with various stages.
7. Experience integrating data sources like DB2-UDB, PL/SQL, Hadoop.
8. Knowledge of Agile tools like Jira, Confluence, Bitbucket, Jenkins.
9. Strong troubleshooting skills for DataStage jobs and production issues.
10. Experience in database programming for Data Warehouses and dimensional modeling.
11. Proficiency in data modeling and reverse engineering tools such as Erwin and MS Visio.

What’s In It for You

1. Work with industry leaders from top technology companies.
2. Innovative, inclusive, and collaborative environment that encourages learning and celebrates success.
3. Supportive environment promoting fair treatment, unconscious bias, and anti-racism training.
4. Flexible work arrangements to suit individual preferences.
5. Competitive rewards including bonuses, pension, employee share ownership, generous vacation, and health benefits.
6. State-of-the-art collaboration ecosystems for in-person work.

Location

Canada: Ontario: Toronto

About Scotiabank

Guided by our purpose: "for every future", we help our customers and communities succeed through a broad range of financial services. We value diversity and are committed to an inclusive environment. Accommodations are available upon request during the recruitment process.

Candidates must apply online. Only shortlisted candidates will be contacted.