Datastage Developer

Aarorn Technologies Inc; Toronto; On-site; CAD 47,000 - 63,000; Full time

Job summary

Aarorn Technologies Inc. in Toronto, ON is seeking an experienced DataStage Developer to design, develop, and support data integration and warehousing solutions. The role focuses on delivering high-quality ETL processes using IBM DataStage and related technologies.

You will work on SQL/PL-SQL, Python, Unix scripts, and collaborate with analysts and architects to ensure data accuracy, performance, and adherence to development standards. This contract position requires onsite presence in Toronto.

Qualifications

• Experience designing and maintaining ETL workflows with DataStage.
• Experience in data warehousing and ETL methodologies.
• Strong SQL/PL-SQL and Python scripting skills.

Responsibilities

• Design, develop, and maintain ETL solutions using IBM DataStage.
• Work on Data Warehouse projects involving data extraction, transformation, and loading.
• Provide production support and troubleshoot ETL failures.
• Develop and optimize SQL/PL-SQL queries and database objects.
• Build Unix shell scripts for automation and operational support.
• Develop Python-based data processing and validation solutions.
• Collaborate with analysts, architects, and stakeholders to meet data requirements.
• Ensure data quality, performance tuning, and best practices.
• Participate in code reviews, testing, deployment, and documentation.

Skills

Data Warehousing

ETL methodologies

SQL

PL/SQL

Python scripting

Unix/Linux scripting

Hive

Oracle

SQL Server

DB2

PostgreSQL

Analytical skills

Troubleshooting

Communication

Teamwork

Tools

IBM DataStage

SQL

PL/SQL

Python

Unix/Linux

Hive

Oracle

SQL Server

DB2

PostgreSQL

Job description

Job Title: DataStage Developer

Location: Toronto, ON (3x onsite a week)

Employment Type: Contract

Pay Rate: CAD$40/HR INC

Summary

We are looking for an experienced DataStage Developer with strong expertise in IBM DataStage, SQL, PL/SQL, Python, and Unix. The ideal candidate should have experience in designing, developing, and supporting data integration and data warehousing solutions while ensuring optimal performance and data quality.

Roles & Responsibilities

• Design, develop, and maintain ETL solutions using IBM DataStage.
• Work on Data Warehouse projects involving data extraction, transformation, and loading from various source systems.
• Provide production support, troubleshoot ETL failures, and perform root cause analysis.
• Develop and optimize SQL and PL/SQL queries, stored procedures, and database objects.
• Build and maintain Unix shell scripts for automation and operational support.
• Develop Python-based solutions for data processing, validation, and automation requirements.
• Collaborate with business analysts, architects, and stakeholders to understand data integration requirements.
• Ensure data quality, performance tuning, and adherence to development standards and best practices.
• Participate in code reviews, testing, deployment, and documentation activities.

Qualifications & Skills

• Strong knowledge of Data Warehousing concepts and ETL methodologies.
• Hands-on experience in IBM DataStage development and support projects.
• Experience in designing and building DataStage solutions and ETL workflows.
• Strong proficiency in SQL and PL/SQL.
• Hands-on experience with Python scripting and automation.
• Good experience in Unix/Linux scripting.
• Experience working with Hive and/or relational databases such as Oracle, SQL Server, DB2, or PostgreSQL.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and teamwork abilities.
• Ability to work in a fast-paced and collaborative environment.

Disclaimer: AI tools may assist in the recruitment process; however, all hiring decisions are made by the recruitment team based on a comprehensive evaluation of candidates.