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.
Développeur principal concevant et intégrant des applications web pour la Ville de Montréal. Utilisation de Node.js, TypeScript, microservices, APIs et déploiements infonuagiques en environnement agile et DevOps.
Certinia Developer owning Softchoice’s customized PSA platform and Salesforce components. Designing SAP, SAP Concur, and MuleSoft integrations for this IT solutions provider.
Hotfix Developer resolving urgent production issues for Paystone, a North American payments and software company. Investigating transactional data, coding fixes, and deploying reliable client solutions.
Senior Software Engineer role at Fable, focusing on AI and full - stack development. Build AI - first products for accessibility, owning problems end - to - end.
Execute and support EFTR regulatory reporting activities, including data remediation and compliance. Ideal for professionals with AML reporting experience and strong data skills.
Seeking a skilled ETL Tester to independently lead testing efforts for a banking client, managing functional and automation testing in an Agile environment.
Integration Developer building Apache Camel, Kafka, and OpenShift solutions for PLATO, Canada’s Indigenous - owned software testing and technology services company. Delivering secure enterprise integrations, APIs, and automated data exchange.
Director of Engineering co - leading Lazer’s AI - powered forward - deployed engineering team. Guiding architecture, talent, client engagements, AI standards, and technical delivery at a digital product studio.
z/OS Connect Systems Programmer supporting TD’s mainframe banking infrastructure. Maintaining, testing, and deploying z/OS Connect and IMS systems with rotating on - call support.