Key skills
ETLOracleSQLTypeScriptBISQL ServerLeadership
About this role
Role Overview
- Design, develop and optimize ETL pipelines using IBM DataStage to feed and manage data warehouses;
- Ensure data ingestion, transformation and modeling to meet analysis and reporting requirements;
- Manage the integration and transformation of large volumes of data while ensuring performance and scalability;
- Optimize the execution of DataStage jobs to ensure fast and efficient data processing;
- Develop advanced error handling, logging and restart/recovery mechanisms;
- Work with large-scale databases (Oracle, DB2, SQL Server, etc.) and optimize SQL queries;
- Collaborate with BI, architecture and data governance teams to ensure effective integration within the existing ecosystem.
Requirements
- 10 years of ETL development experience with IBM DataStage;
- Proven experience on projects handling massive volumes of data;
- Expertise in ETL optimization, parallelism and performance tuning;
- Strong advanced SQL skills and experience handling large-scale data.
- Additional assets:
- Experience on projects in the banking sector;
- Demonstrated experience in large-scale digital transformation and data integration projects.
- Language skills:
- French: Advanced
- English: Intermediate
Tech Stack
- ETL
- Oracle
- SQL
- TypeScript
Benefits
- Work-life balance: We support a healthy work-life balance. With flexible working options and our unlimited vacation policy, you can rest and recharge when you need it most.
- Support for your well-being: Our benefits are designed for optimal health and wellness. You will have access to 24/7 virtual healthcare and a comprehensive wellness portal offering tools and resources to support your physical, mental, emotional and financial well-being.
- Continuous growth and learning: Through partnerships with leading global education providers, you will have access to thousands of online courses and certifications. With our exclusive leadership programs and tuition reimbursement for external training, we empower you to achieve your ambitions.
- Opportunity to become a shareholder: Our employee share purchase plan with matched contributions allows you to become a shareholder and directly benefit from our collective achievements.