- Responsible for understanding the business requirements.
- Build/enhance application components to support the requirement, enabling testing organization to certify the application.
- Prepare ETL architecture, associate procedures and develop Datastage jobs.
- Review all functional business applications and specifications.
- Schedule and plan all data stage tasks.
- Monitor all data stage jobs and provide production support to all.
- Manage work and apply various performance improvement techniques.
- Support technology infrastructure team in production deployment and transitioning to support team
Essential Skills:
- 5+ years Relevant IT software experience (Technical-Developer) using ETL Technologies.
- Minimum 3 years of development experience in IBM DataStage, IBM Information Analyzer, SQL, UNIX/LINUX.
- Strong fundamentals in Data warehousing and BI concepts
- Strong knowledge of relation database, specifically Oracle (SQL - PL/SQL)
- Technical expertise in the design, development, coding, unit testing and debugging of software.
- Solid experience working with requirement analysts gathering business requirements, understanding requirements giving feedback about how it can be technically be implemented using ETL etc.
- Develop ETL code and build packages based on existing standards and suggest improvements when possible
- Develop and test code from design specifications, as well as implement and support enhancements to applications
- Has some hands-on experience working in an agile environment and knowledge of waterfall as a methodology in team and organization standards.
- Works in close collaboration with Business Analyst and other cross functional team members in creating design documents, outlining overview, diagrams, technical requirements, and solution that best addresses a business need.
- Participate in technical discussions, client meetings and presentation of solutions to the technical team members as well as Business
- Participate in code review of peers and junior team members and recommend suggestions for improvement where appropriate to ensure high quality product
- Assist in production support issues and carry after-hours support phone on a rotational basis 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 his/her 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.
- Champions a high-performance environment and contributes to an inclusive work environment.
- Excellent communication
- Excellent leadership skills and able to drive solution
- Willing to work and coordinate with globally distributed team for solution delivery
- Banking Knowledge