Alithya

DataStage Developer

Alithya

full-time

Posted on:

Location Type: Hybrid

Location: Montreal • Canada

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLOracleSQL

About the role

  • Design, develop, and optimize ETL pipelines in IBM DataStage for data warehouse ingestion and management;
  • Ensure data ingestion, transformation, and modelling to meet analytics and reporting needs;
  • Manage the integration and transformation of large data volumes while ensuring performance and scalability;
  • Optimize the execution of DataStage jobs to ensure fast and efficient data processing;
  • Develop advanced mechanisms for error handling, logging, and recovery;
  • Work with large databases (Oracle, DB2, SQL Server, etc.) and optimize SQL queries;
  • Collaborate with BI, architecture, and data governance teams to ensure effective integration into the existing ecosystem.

Requirements

  • Minimum 5 years of ETL development experience with IBM DataStage;
  • Proven experience on projects handling massive data volumes;
  • Expertise in ETL optimization, parallelism, and performance tuning;
  • Strong skills in advanced SQL and large‑scale data manipulation.
  • Extra edge
  • Experience with banking sector projects;
  • Demonstrated experience in large‑scale digital transformation and data integration projects.
  • Language skills
  • French: Advanced
  • English: Advanced
  • Please note that due to the nature of the responsibilities of the position, an advanced level of English is required, in particular to communicate on a regular basis with employees, managers and clients outside of Quebec.
Benefits
  • Work-life balance helps us stay at our best. We offer flexible work options, and with our Unlimited Vacation Plan, you can rest and recharge when you need it most.
  • Your contributions matter. From day one, our total rewards package offers a comprehensive compensation plan, including short-term incentive programs.
  • Our benefits are designed with optimal health and wellness in mind. You’ll have access to 24/7 virtual healthcare, as well as an extensive wellness portal that provides tools and resources to support your physical, mental, emotional and financial well-being.
  • When you join Alithya, you’re joining a team committed to investing in your development. Refining your expertise is essential in a rapidly evolving industry, and we support your continuous growth every step of the way. Through partnerships with world-renowned education leaders, we provide access to thousands of top-rated online courses and certifications. With exclusive leadership programs designed to empower you to lead your teams with confidence and deliver impactful outcomes, and with a tuition reimbursement program for external training, we set you up for success to thrive and achieve your ambitions.
  • Our people drive our success. Through our Employee Share Purchase Plan with matched contributions, you become a stakeholder, sharing in our growth and directly benefiting from our collective achievements.
  • The diversity of our backgrounds, experiences, thoughts and insights is our competitive advantage. We foster a collaborative environment rooted in our core values of respect, well-being, passion, trust, integrity and creativity. For us, diversity, equity and inclusion aren’t just buzzwords; they’re essential drivers of innovation and excellence, and powerful catalysts for inspiration and evolutionary ideas.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
ETL developmentIBM DataStagedata ingestiondata transformationdata modelingSQL optimizationperformance tuningerror handlingloggingdata recovery
Soft skills
collaborationcommunication