Montréal [Hybrid] - PL/SQL Developer
About the role
About the Company As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1200 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Geneva, Lisbon, Porto and Casablanca. We are looking for a Software Developer (PL/SQL) to join one of our clients, a major corporate investment bank based in Montreal, for a strategic Finance & Risk Systems initiative — the UniData Shared Data Ecosystem program, aimed at supporting Finance and Risk reporting needs across the Americas.
Position Overview The Software Developer is a technical role embedded within the Finance & Risk Systems Shared Data Ecosystem project team. The developer will directly support the deployment of the UniData project by delivering PL/SQL developments that enable new application functionalities, inter-layer data movements, and multi-tenant database compatibility. The role also covers ETL orchestration via JIL (AutoSys) and requires the ability to collaborate effectively with team members across different time zones and locations
. Key Responsibilities PL/SQL Development Design and implement PL/SQL developments to build new functionalities within the application Develop PL/SQL scripts to enable data movement between application layers Optimize and modify existing PL/SQL code to ensure compatibility with a multi-tenant database environment Conduct code reviews and performance tuning on high-volume transactional databases ETL Orchestration Develop JIL scripts (AutoSys) to orchestrate ETL tasks in accordance with application guidelines and standards Ensure all ETL jobs are properly sequenced, monitored, and documented Collaboration & Documentation Work with team members located in different time zones, receiving and interpreting instructions asynchronously Document code, stored procedures, and design artefacts to ensure maintainability and knowledge transfer Use version control (Git/SVN) and issue-tracking systems (JIRA, HP ALM) throughout the development lifecycle
Qualifications & Technical Skills Technical Skills Minimum 5 years of hands-on PL/SQL development, including advanced query optimization, complex stored procedure design, and performance tuning of high-volume transactional databases Solid experience with multi-tenant Oracle database environments Experience with ETL orchestration tools, specifically JIL/AutoSys Proficiency in version control tools (Git or SVN) Familiarity with issue-tracking systems such as JIRA and/or HP ALM Knowledge of application layered architectures and data flow design
Behavioral Competencies Analytical Mindset — Strong debugging and problem-solving abilities on complex database environments Autonomous & Remote-Ready — Proven capacity to receive instructions and deliver quality work across time zones Documentation Discipline — Consistently documents code, design choices, and known issues Team Player — Collaborative attitude in distributed, multicultural engineering teams Rigorous — Applies high standards to code quality, naming conventions, and technical specifications
Preferred Certifications Oracle Database SQL Certified Associate or higher Any relevant data engineering or ETL certification is a plus
Experience Minimum 5 years of PL/SQL development experience in a production environment Prior experience in financial services, banking, or regulated industries strongly preferred Demonstrated experience contributing to large-scale data platform or data migration projects Experience working in distributed Agile teams with remote collaboration tools Exposure to Finance or Risk reporting data models is an asset
About QUANTEAM - North America (RAINBOW PARTNERS Group)
Quanteam is labeled "Best Workplace Experience 2021" by Speak & Act!
Part of Rainbow Partners Group, Quanteam is an independent Financial Markets consulting company based in France, the UK, the USA, Canada, Switzerland, Belgium, Portugal, Morocco, Spain or Singapore. Our teams support Corporate and Investment Banks, Asset Management Companies, Insurance and Corporate for their projects in financial engineering, quantitative research, regulatory implementation, SI transformation, and technology innovation.
We are currently looking for talented Consultants in New York, Chicago, Dallas, Miami and Montréal. If you seek new career opportunities, please send us your application by mail (hiring@quanteam.us) or visit our Career section on LinkedIn. For more information on our expertise, please visit our website.
Quanteam is positioned as a unique multi-specialist in the Financial, Insurance, and Digital Transformation sectors. We have the ability to manage complex projects involving Front, Risk, R/D, Regulatory, Compliance, and IT teams. We rely on a team of +850 employees based in Europe, North America and Africa. Finally, we recorded 88M€ of turnover in 2024.
Similar Jobs
Montréal [Hybrid] - PL/SQL Developer
About the role
About the Company As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1200 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris, Lyon, New York, Montreal, London, Brussels, Geneva, Lisbon, Porto and Casablanca. We are looking for a Software Developer (PL/SQL) to join one of our clients, a major corporate investment bank based in Montreal, for a strategic Finance & Risk Systems initiative — the UniData Shared Data Ecosystem program, aimed at supporting Finance and Risk reporting needs across the Americas.
Position Overview The Software Developer is a technical role embedded within the Finance & Risk Systems Shared Data Ecosystem project team. The developer will directly support the deployment of the UniData project by delivering PL/SQL developments that enable new application functionalities, inter-layer data movements, and multi-tenant database compatibility. The role also covers ETL orchestration via JIL (AutoSys) and requires the ability to collaborate effectively with team members across different time zones and locations
. Key Responsibilities PL/SQL Development Design and implement PL/SQL developments to build new functionalities within the application Develop PL/SQL scripts to enable data movement between application layers Optimize and modify existing PL/SQL code to ensure compatibility with a multi-tenant database environment Conduct code reviews and performance tuning on high-volume transactional databases ETL Orchestration Develop JIL scripts (AutoSys) to orchestrate ETL tasks in accordance with application guidelines and standards Ensure all ETL jobs are properly sequenced, monitored, and documented Collaboration & Documentation Work with team members located in different time zones, receiving and interpreting instructions asynchronously Document code, stored procedures, and design artefacts to ensure maintainability and knowledge transfer Use version control (Git/SVN) and issue-tracking systems (JIRA, HP ALM) throughout the development lifecycle
Qualifications & Technical Skills Technical Skills Minimum 5 years of hands-on PL/SQL development, including advanced query optimization, complex stored procedure design, and performance tuning of high-volume transactional databases Solid experience with multi-tenant Oracle database environments Experience with ETL orchestration tools, specifically JIL/AutoSys Proficiency in version control tools (Git or SVN) Familiarity with issue-tracking systems such as JIRA and/or HP ALM Knowledge of application layered architectures and data flow design
Behavioral Competencies Analytical Mindset — Strong debugging and problem-solving abilities on complex database environments Autonomous & Remote-Ready — Proven capacity to receive instructions and deliver quality work across time zones Documentation Discipline — Consistently documents code, design choices, and known issues Team Player — Collaborative attitude in distributed, multicultural engineering teams Rigorous — Applies high standards to code quality, naming conventions, and technical specifications
Preferred Certifications Oracle Database SQL Certified Associate or higher Any relevant data engineering or ETL certification is a plus
Experience Minimum 5 years of PL/SQL development experience in a production environment Prior experience in financial services, banking, or regulated industries strongly preferred Demonstrated experience contributing to large-scale data platform or data migration projects Experience working in distributed Agile teams with remote collaboration tools Exposure to Finance or Risk reporting data models is an asset
About QUANTEAM - North America (RAINBOW PARTNERS Group)
Quanteam is labeled "Best Workplace Experience 2021" by Speak & Act!
Part of Rainbow Partners Group, Quanteam is an independent Financial Markets consulting company based in France, the UK, the USA, Canada, Switzerland, Belgium, Portugal, Morocco, Spain or Singapore. Our teams support Corporate and Investment Banks, Asset Management Companies, Insurance and Corporate for their projects in financial engineering, quantitative research, regulatory implementation, SI transformation, and technology innovation.
We are currently looking for talented Consultants in New York, Chicago, Dallas, Miami and Montréal. If you seek new career opportunities, please send us your application by mail (hiring@quanteam.us) or visit our Career section on LinkedIn. For more information on our expertise, please visit our website.
Quanteam is positioned as a unique multi-specialist in the Financial, Insurance, and Digital Transformation sectors. We have the ability to manage complex projects involving Front, Risk, R/D, Regulatory, Compliance, and IT teams. We rely on a team of +850 employees based in Europe, North America and Africa. Finally, we recorded 88M€ of turnover in 2024.