ETL DataStage Developer

Apptoza Inc.; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

Apptoza Inc. is seeking a skilled DataStage and Talend Developer in Toronto, Canada to design and maintain ETL processes. Focused on data integration and warehousing, you will work with various data sources and play a critical role in optimizing data workflows.

The ideal candidate has strong skills in IBM DataStage and Talend, with solid SQL knowledge and experience in ETL design. Join our agile team to enable effective data movement and ensure data quality across the organization.

Qualifications

• Strong experience in IBM DataStage and Talend.
• Deep knowledge of SQL for various databases.
• Proven skills in ETL design and development.

Responsibilities

• Design, develop, and maintain ETL jobs with DataStage and Talend.
• Optimize ETL processes for scalability and performance.
• Handle ETL processes across multiple data sources.

Skills

IBM DataStage

Talend

SQL

ETL design and development

Data modeling

Unix/Linux scripting

Job description

We are looking for a skilled DataStage and Talend Developer responsible for designing, developing, and maintaining ETL processes to support enterprise data integration, data warehousing, and analytics initiatives. The candidate will work with large datasets and ensure efficient data movement, transformation, and quality.

Key Responsibilities

• Design, develop, and maintain ETL jobs using IBM DataStage and/or Talend. Build reusable components and frameworks for data integration.
• Optimize ETL processes for performance and scalability.
• Extract, transform, and load (ETL/ELT) data from multiple sources (databases, APIs, flat files, cloud).
• Handle structured and semi-structured data and implement data validation, cleansing, and transformation rules.
• Work on data warehousing concepts (Star Schema, Snowflake schema, fact/dimension tables), support data marts and reporting systems, and ensure accurate and timely data availability for BI tools.
• Analyze job performance, optimize ETL workflows, handle large data volumes efficiently, and debug and troubleshoot ETL failures.
• Collaborate with business analysts, data architects, and developers to understand data requirements and translate them into technical solutions.
• Participate in agile development processes (Scrum, sprint planning).
• Document ETL processes, workflows, and data mappings.
• Ensure adherence to data governance and security standards.
• Maintain version control and deployment processes.

Required Skills

• Strong experience in IBM DataStage (Parallel Jobs, Server Jobs) and Talend (Talend Open Studio / Talend Data Integration).
• Strong SQL knowledge (Oracle, SQL Server, DB2, etc.).
• ETL design and development.
• Data modeling concepts.
• Experience with Unix/Linux scripting (Shell).