Job Specifications
JOB DESCRIPTION
Job Title: CBTS Team – Data Warehouse systems development & production Support (Montreal)
Contract type: Contractor
Job Summary: The role will be based in Montreal reporting to the CBTS Team Lead – DWH Systems located in Montreal. The primary responsibility is to develop and support activities of the Commercial Banking application. It involves understanding the Commercial banking applications’ risk and reporting steam used by the business users and supporting/enhancing its infrastructure e.g. database, critical overnight batch execution, month-end reporting etc.
The CBTS domain leverages technical expertise and business knowledge to support a myriad of business applications across the Americas in the US, Brazil and Canada branches.
It includes applications covered by two CACIB Head office IT business lines
· CSI - Corporate & Support Functions IT: Finance, Risk, Referential, Compliance, Transverse applications and Corporate systems (HR, Administration, IT for IT ...)
· CBI - Corporate Banking IT: Commercial Banking (Front, Middle & Back Office), Payments, Client accounts and Client on boarding.
·
Key Responsibilities:
· Support all DWH upstream and downstream interfaces.
· Coordinate with internal and external resources required to support DWH applications and associated interfaces.
· Contribute to key initiatives related to technical/functional IT and business projects to meet and support business objectives.
· Train and support team members.
· Responsible for production support:
- Support day to day production needs:
§ Resolution of production issues, including RCA, defect remediation and incident reporting.
§ Ensure prompt addressing of financial user’s query
§ Resolution of batch issues by coordinating with other cross functional teams within the prescribed timelines and make aware of the impact to the business users.
§ Lead troubleshooting of issues and provide guidance to the support team members.
§ To comply ITIL processes (Incident, Problem and Change management).
§ Coordinate and execute maintenance activities including business continuity and critical application failover tests, market infrastructure mandatory tests and releases, system/security patching.
§ ETL operations and performance tuning the complex SQL and DML queries.
§ To leverage the automations for repetitive manual tasks/interventions.
· Responsible for project deliverables:
- Ensure the respect of development procedures as per the internal system project life cycle procedures
- Perform enhancement on the business requirements which includes batch jobs configuration in Control-M, creating/modifying DB objects, shell scripts.
- Design application architecture and develop procedures in database (Oracle/Sybase).
- Batch designing and implementation in Unix/Linux using shell scripting and Perl etc.
- Create required documentation for requirements, solution design, and implementations.
- Develop test strategy, test plans and execute functional/technical test scripts
- Facilitate and manage unit, integration and user acceptance testing.
- Ensure that all system implementations meet US regulatory standards and are done in accordance with the Bank’s policies and procedures
Technical aptitude
· Ability to provide input to general architecture - including hardware, network, tools, software, etc.
· Help critique, develop and direct technology solutions.
· Assist in the gathering of business requirements and define specifications.
· Propose and approve solution designs.
· Ensure proper implementation of requirements in the information system.
· Be familiar with technology tools to confirm data quality and investigate questions.
· Ensure the respect of policies and procedures of the Bank, as well as regulatory requirements.
· Support and assist in the functional testing on major projects or complex changes.
POSITION LOCATION
Country: Canada
City: Montreal
CANDIDATE CRITERIA
Minimal education level: Bachelor Degree or equivalent
Minimum relevant experience: 5 - 9 years
Required Skills:
FUNCTIONAL
· Domain knowledge of DWH systems in a banking environment.
· Experience as part of an IT production support team responsible for supporting production, enhancements and maintenance.
· Experience supporting overnight batch execution, EOD and SOD processes.
· Experience supporting Operations and Compliance Teams
· Knowledge of Sanctions Filtering and AML
· Knowledge of project management and project life cycle
TECHNICAL
· Experience with implementation, upgrades and enhancements of payment systems.
· Strong technical knowledge background in databases, Linux, and Windows systems.
· Strong knowledge of the Microsoft Suite (Excel, Word, PowerPoint, Visio, etc.), SQL Server, Oracle PL/SQL, and shell scripting.
· Working knowledge of Control-M.
· Experience with development of technical architectures and solution designs to meet business requirements.
· Hands on experience on testing m
About the Company
The Aptonet brand includes the professional services and the resources divisions. The professional services group delivers pure technology execution such as architecture, development, implementation, integration and support; delivers specialized operations research services, IoT solutions, mobility and web solutions. This group has North American and European reach. The development and support work can be done locally or near shore as an alternative.
The resources division does the global IT staffing and recruitment. This gr...
Know more