Summary
An enterprise technology team is seeking a data integration developer to build and maintain ETL solutions. The role involves database development, automation scripts, troubleshooting, and collaboration with technical teams.
Highlights
Opportunity to work on enterprise data integration projects involving ETL development, database optimization, and automation.
Description
Position: DataStage Developer
Location: Toronto, On
Job Description:
The DataStage Developer is responsible for designing, developing, testing, and maintaining ETL solutions using IBM DataStage to support enterprise data integration and migration initiatives.
The role involves working with relational databases, developing SQL scripts and stored procedures, and creating shell scripts for automation in Linux environments.
The developer collaborates with cross-functional teams to ensure reliable data processing, troubleshoot production issues, and optimize ETL performance.
The role also includes using tools such as ServiceNow, Jira, Confluence, and GitHub for incident management, agile project tracking, documentation, and version control.
Key Responsibilities:
Design, develop, and maintain ETL jobs using IBM DataStage.Develop and optimize SQL queries, stored procedures, and data extraction processes.Use MS SQL Server utilities (including BCP) for data import/export and bulk data processing.Create and maintain Linux shell scripts to automate ETL workflows and operational tasks.Monitor, troubleshoot, and resolve ETL job failures and production issues.Perform performance tuning and optimization of ETL jobs and database queries.Collaborate with business analysts, database administrators, and application teams to understand data integration requirements.Manage incidents and service requests using ServiceNow.Track work items and participate in Agile ceremonies using Jira.Maintain technical documentation in Confluence.Use GitHub for source code management and version control.Follow coding standards, testing practices, and deployment processes to ensure high-quality deliverables.
Regards
Patrick Fernandez
Talent Acquisition Group - Strategic Recruitment Manager
