DataStage Developer designing and optimizing data pipelines for efficient integration in existing ecosystems. Collaborating with teams to ensure effective data handling and reporting.
Responsibilities
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
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.
Director of Engineering overseeing Analytics & Data Management programs for marquee clients in Sports & Gaming. Ensuring delivery excellence, stakeholder management, team leadership, and account growth.
Hiring a Software Engineer Lead / Manager (Full Stack) for a Financial Services firm in Toronto. Lead teams and build enterprise apps with Java, Angular, and microservices.
Developer creating high - quality software solutions for Financeit's financing platform. Collaborating with cross - functional teams to deliver and improve code for retail and home improvement sectors.
Director of Engineering leading Azure modernization initiatives at Manulife. Overseeing cloud migration and operational excellence for Azure services with a focus on collaboration and innovation.
Junior Windchill Developer at Capgemini Engineering working on customizing and maintaining Windchill PLM systems with a focus on Java development and collaboration with senior developers.