Job title : - Senior Developer
Location : - Montreal, QC
Duration : - 12 Months
Pay rate : $75.hr without any benefits
Direct Responsibilities
Principal Duties : -
The scope of the engagement will include but not be limited to :
- 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 solutions
- 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 client development standards, the software development lifecycle, vendor application / project standards and guidelines
- Embrace the opportunity to take on special projects outside of specific roles and responsibilities
- Closely interact with onshore stakeholders and onshore / offshore teams on a regular basis.
- Support APS (Application Production Support) teams as required for various activities like DR test, production releases, etc.
Contributing Responsibilities
- Contribute towards knowledge sharing initiatives across the team
- Contribute towards Innovation and Creativity initiatives across the team and the organization.
Technical & Behavioural Competencies
- 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.
Il y a 3 jours