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
- ntDesign and implement PL/SQL developments to build new functionalities within the applicati
- onDevelop PL/SQL scripts to enable data movement between application laye
- rsOptimize and modify existing PL/SQL code to ensure compatibility with a multi-tenant database environme
- ntConduct code reviews and performance tuning on high-volume transactional databas
ETL Orchestration
- onDevelop JIL scripts (AutoSys) to orchestrate ETL tasks in accordance with application guidelines and standar
- dsEnsure all ETL jobs are properly sequenced, monitored, and document
- onWork with team members located in different time zones, receiving and interpreting instructions asynchronous
- lyDocument code, stored procedures, and design artefacts to ensure maintainability and knowledge transf
- erUse version control (Git/SVN) and issue-tracking systems (JIRA, HP ALM) throughout the development lifecyc
Qualifications & Technical Skills
Technical Skills
- llsMinimum 5 years of hands-on PL/SQL development, including advanced query optimization, complex stored procedure design, and performance tuning of high-volume transactional databa
- sesSolid experience with multi-tenant Oracle database environme
- ntsExperience with ETL orchestration tools, specifically JIL/Auto
- SysProficiency in version control tools (Git or S
- VN)Familiarity with issue-tracking systems such as JIRA and/or HP
- ALMKnowledge of application layered architectures and data flow des
Behavioral Competency
- iesAnalytical Mindset — Strong debugging and problem-solving abilities on complex database environme
- ntsAutonomous & Remote‑Ready — Proven capacity to receive instructions and deliver quality work across time zo
- nesDocumentation Discipline — Consistently documents code, design choices, and known iss
- amsRigorous — Applies high standards to code quality, naming conventions, and technical specificati
Preferred Certifications
- onsOracle Database SQL Certified Associate or hig
- herAny relevant data engineering or ETL certification is a p
Experience
- enceMinimum 5 years of PL/SQL development experience in a production environ
- mentPrior experience in financial services, banking, or regulated industries strongly prefe
- rredDemonstrated experience contributing to large‑scale data platform or data migration proj
- ectsExperience working in distributed Agile teams with remote collaboration t
- oolsExposure to Finance or Risk reporting data models is an a
#J-18808-Ljbffr