Senior DataStage ETL Engineer – SQL & Unix Expert

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; Hybrid; CAD 110,000 - 140,000; Full time

Job summary

Astra-North Infoteck Inc. in Toronto, ON, invites an experienced Datastage Developer to join our hybrid team for a 6-12 month contract. The role focuses on building robust ETL pipelines, writing complex SQL, and scripting in Unix to support data integration initiatives.

You will design, implement and review data processing solutions, participate in SDLC activities, and collaborate with cross-functional teams to ensure high-quality delivery and timely project execution.

Qualifications

• 8+ years of experience in complex, time-sensitive development environments.
• Extensive hands-on ETL with DataStage.
• Extensive hands-on SQL experience (MS SQL Server, Teradata).
• Experience creating stored procedures and Unix shell scripting.
• Support at-scale testing, UAT and reporting.
• Knowledge of the SDLC – Agile, Waterfall, Iterative.

Responsibilities

• Design and implement data pipelines.
• Create and review technical design documents and facilitate meetings.
• Participate in walkthrough reviews of specifications, programs, code, and unit test plans.
• Plan design/implementation activities and drive technical platform evolution.
• Present technical topics at team meetings and manage work packages.
• Estimate activities required for design, coding and unit testing.
• Ensure ETL pipelines meet quality, metadata, and completeness standards.
• Collaborate with development teams to promote best practices.
• Provide third-level support for various technologies.

Skills

ETL DataStage

SQL

Unix scripting

SDLC

Agile

Tools

GitHub

CI/CD Pipeline

Job description

Astra-North Infoteck Inc. in Toronto, ON, invites an experienced Datastage Developer to join our hybrid team for a 6-12 month contract. The role focuses on building robust ETL pipelines, writing complex SQL, and scripting in Unix to support data integration initiatives.

You will design, implement and review data processing solutions, participate in SDLC activities, and collaborate with cross-functional teams to ensure high-quality delivery and timely project execution.