Senior ETL Developer – IBM DataStage & Unix

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A technology solutions company in Toronto is seeking a Senior ETL Developer to design and implement ETL solutions using IBM DataStage. The ideal candidate will have strong skills in SQL, UNIX/Linux, and a deep understanding of ETL concepts with 8-10 years of experience. Join a dynamic team to optimize data integration and contribute to advanced analytics projects.

Qualifications

• Strong proficiency in using DataStage for ETL development.
• Solid understanding of SQL and experience with relational databases.
• Deep understanding of ETL concepts and best practices.
• Experience with UNIX/Linux operating systems and scripting.

Responsibilities

• Develop and implement ETL solutions.
• Design DataStage jobs to extract, transform, and load data.
• Ensure data consistency and availability for business intelligence.
• Optimize the performance of ETL processes.
• Participate in the SDLC and agile frameworks.
• Collaborate with analysts and architects for requirements.
• Support existing DataStage jobs in production.

Skills

IBM Infosphere DataStage

SQL and Databases

ETL Concepts

UNIX/Linux

Data Modelling

Agile and DevOps

C#

.NET Core

Web API

Angular/React

ASP.NET

MVC

SQL Server/Oracle/Sybase

Git

Jira

Jenkins

Job description

Overview

Senior ETL Developer – IBM DataStage & Unix

Responsibilities

• Develop and implement ETL solutions
• Design and build DataStage jobs to extract, transform, and load data from various sources into target data warehouses or data marts
• Data Warehousing and Data Integration: focus on data warehousing and data integration projects, ensuring data consistency and availability for business intelligence and analytics
• Performance Tuning: optimize the performance of ETL processes to meet business requirements and ensure efficient data processing
• SDLC and Agile Methodologies: participate in the software development lifecycle (SDLC) and potentially work within agile frameworks
• Collaboration: work with business analysts, data architects, and other developers to understand requirements and deliver high-quality solutions
• Production Support: may be involved in providing support for existing DataStage jobs in production, including troubleshooting and resolving issues

Qualifications and Skills

• IBM Infosphere DataStage: strong proficiency in using DataStage for ETL development
• SQL and Databases: solid understanding of SQL and experience with relational databases like Oracle
• ETL Concepts: deep understanding of ETL concepts, data warehousing principles, and data integration best practices
• UNIX/Linux: experience with UNIX/Linux operating systems, including scripting (e.g., Unix Shell Scripting)
• Data Modelling: familiarity with data modelling concepts and techniques
• Agile and DevOps: experience working in agile environments and potentially with DevOps practices
• Additional Technical Skills: 8+ years of strong design, development experience using C#, .NET Core, Web API, Angular/React, ASP.NET, MVC; 3+ years with SQL Server/Oracle/Sybase, complex procedures and SSIS; experience with DevOps tools (Git, Jira, Jenkins); familiarity with container-based technologies is a plus
• Nice to have: cloud platforms, big-data technologies, Linux/Windows application setup, APAC Regulatory Reporting experience
• Exp Required: 8-10 years

Seniority

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• Information Services

Get notified about new Senior ETL Developer jobs in Toronto, Ontario, Canada.