At Shire, we are proud and grateful to employ military veterans and thank them for their contributions to our company and our country. See where your military experience can play a role at Shire by using our military skills translator job search tool below:
senior developer - oracle sql, java, python.
united states , united states
posted may 13, 2024
job details
summary
$60 - $80 per hour
contract
bachelor degree
category computer and mathematical occupations
reference1051901
job details
job summary:
About Business line/Function:
This role is with the AML IT team that provides ETL, GUI development services, AML development, to Compliance, Control and Legal functions within the company. The key stakeholders are spread across North America.
Location:
2001 Blvd Robert-Bourassa, Montréal, QC H3A 2A6, Canada
Position Purpose:
The North American IT Transversal Functions is working on implementing IT solutions to support various clients: Finance, Human Resources, Procurement, Premises & Logistics, Business Continuity Management, IT Security, etc.
We are looking for a talented individual looking to join a dynamic environment where they can raise 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 working with the team to design, develop, test and implement / support solutions.
Responsibilities:
-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 BNP Paribas 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 / off-shore 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 & Behavioral 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 of 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.
Specific Qualifications:
-Behavioral Skills:
Organizational skills
Ability to collaborate / Teamwork
Attention to detail / rigor
Communication skills - oral & written
-Transversal Skills:
Analytical ability
Ability to develop and adapt a process
Ability to understand, explain and support change
Ability to develop and leverage networks
location: Montréal, QC
job type: Contract
salary: $60 - 80 per hour
work hours: 8am to 5pm
education: Bachelors
responsibilities:
Responsibilities:
-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 BNP Paribas 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 / off-shore 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 & Behavioral 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 of 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.
Specific Qualifications:
-Behavioral Skills:
Organizational skills
Ability to collaborate / Teamwork
Attention to detail / rigor
Communication skills - oral & written
-Transversal Skills:
Analytical ability
Ability to develop and adapt a process
Ability to understand, explain and support change
Ability to develop and leverage networks
qualifications:
Experience level: Experienced
Minimum 5 years of experience
Education: Bachelors
skills:
Oracle
SQL
Java
Python
APIEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.