Job title:
AML IT Product Developer
Company
Axelon Services
Job description
Job Title: AML IT Product Developer
Location: Montreal, QC
Hours: 8am – 5pmDescription:We are looking for a talented individual looking to join a dynamic environment where they can raises the bar for the industry. The person will be responsible for the success of RC IT projects by developing new, maintaining existing and supporting a number of in-house/vendor applications from the data warehouse, database, business intelligence (mainly for AML space). The work will require analyzing business requirements, writing technical specifications, and work with team to design, develop, test, and implement/support solution.Responsibilities:
- Review, understand, interpret and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions
- Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
- Perform problem analysis, structured analysis, design and programming techniques
- Contribute to development/ Writing of PID, Business Requirements, and Functional & Technical Specifications document, Test plan, and Test Cases.
- Contribute to defining of specifications for AML Monitoring models in Actimize application (SAM/ ERCM)
- Use Data Modeling, Database Query Optimization and Data Access techniques and concepts
- Use Database knowledge in areas of import and export, users, roles, privileges, schema and object management, session monitoring, etc.
- Code, maintain, test and provide code reviews for developed processes and procedures (e.g. queries, scripts, stored procedures, database objects, indices, triggers, etc.)
- Apply strong performance tuning knowledge in SQL to interpret plans, identify bottlenecks in queries and remediate them
- Apply strong knowledge in Python and Shell Scripting required for file processing and database connections
- Apply strong knowledge in core Java for UI development, Power BI / Tableau for various reporting requirements
- Work proactively to solve issues and problems
- Create use cases and assist in UAT testing efforts for the developed solution
- Document, effectively track and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate)
- Provide weekly progress reports of work performed
- Work with the project team to assist in other aspects of the project
- Follow and adhere to development standards, the software development lifecycle, vendor application / project standards and guideline
- Embrace the opportunity to take on special projects outside of specific roles and responsibilities
- Closely interact with onshore stakeholders and onshore / off-shore teams on a regular basis
- Support Client (Application Production Support) teams as required for various activities like DR test, production releases, etc.
Qualifications:
- Good technical knowledge (hands-on developer) :
- Oracle: SQL, PL/SQL
- Java / API development (Java+Spring Boot+Hibernate, scripts, Angular, …)
- Python (data analytics, Django, Flask, …)
- Experience in AML space / tools (Actimize / Mantas / …) will be a plus.
- Working knowledge on DevOps tools / Platform Engineering (Bitbucket/ Gitlab/ Jenkins/ Docker/ Kubernetes/…) and process, Agile methodology is preferred
- Ability to learn and adapt to new technology.
- Experience in Banking IT, with a good understanding of the Corporate and Institutional Banking activity and systems. Knowledge of Capital Markets is an asset.
- Good working knowledge and hands on experience on ETL, database (including writing complex SQL queries, stored procedures, etc…). Good understanding on concepts and techniques of business intelligence environments and data warehouse.
- Good working knowledge of data warehouse, database and BI
- Good understanding of SDLC processes.
- Good understanding of concepts and techniques for design, development and implementation of ETL and data quality
- Strong coordination and organizational skills.
- Excellent communication skills (written and verbal) with the ability to explain complex issues in a simple concise manner
- Smooth communication with business users and be able to withstand the pressure.
- Multi-tasking capabilities.
Expected salary
Location
Montreal, QC
Job date
Fri, 20 Sep 2024 22:04:10 GMT
To help us track our recruitment effort, please indicate in your email/cover letter where (globalvacancies.org) you saw this job posting.