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.
ABAP/ODATA Developer designing, developing, and supporting SAP ABAP and OData solutions. Delivering S/4HANA customizations, integrations, and technical project support.
Software Engineer building full - stack AI healthcare workflow products at exacare ai. Developing scalable systems, integrations, and customer - facing features for post - acute care teams.
Principal CRM Developer building Dynamics 365 and Azure solutions for Ontario’s condominium authority. Leading CRM delivery, integrations, CI/CD, testing, and engineering standards.
Desjardins programmer analyst developing, maintaining, and supporting enterprise IT systems and infrastructure. Applying software, data, and security practices to standardize solutions.
Principal EDC Programmer leading EDC programming, analytics, and vendor - data solutions for ICON’s global clinical research organization. Mentoring programmers and driving automation across clinical trials.
Game Programmer building gameplay systems, UI, and creative tools for Kabam’s multiplayer games. Developing Unity and C# solutions that improve workflows for artists and designers.
Game programmer building advanced systems, tools, and UI for Kabam’s multiplayer mobile games. Collaborating with designers and engineers using Unity and C#.
Senior Programmer Analyst modernizing Doctors of BC’s healthcare business applications. Migrating legacy systems to Salesforce, NetSuite, Snowflake and other cloud platforms.