Role Overview

• Position Title: DataStage / Talend Developer
  

• Contract Duration: 12 Months (with potential for extension)
  

• Work Arrangement: Hybrid (3 days per week in-office)
  

• Core Focus: Enterprise ETL Design Data Integration and Warehousing
  

About the Role

We are seeking a skilled DataStage and Talend Developer to design develop and maintain robust ETL/ELT this role you will support enterprise data integration data warehousing and business intelligence initiatives. You will work with large complex datasets to ensure efficient secure and accurate data movement transformation and high-quality data availability across the organization.

Key Responsibilities

1. ETL/ELT Development & Processing

• Design develop implement and maintain high-performing ETL/ELT jobs using IBM DataStage and Talend.
  

• Build modular reusable components and frameworks for scalable data integration pipelines.
  

• Extract transform and load structured and semi-structured data from diverse sources including relational databases APIs flat files and cloud environments.
  

• Implement strict data validation cleansing and complex business transformation rules.
  

2. Data Warehouse Architecture & Support

• Apply core data warehousing concepts including design and maintenance of Star Schemas Snowflake Schemas and Fact/Dimension tables.
  

• Support data marts and downstream enterprise reporting systems to ensure timely data availability for Business Intelligence (BI) tools.
  

3. Performance Tuning & Optimization

• Analyze ETL job performance identify bottlenecks and optimize workflows to handle large data volumes efficiently.
  

• Proactively debug troubleshoot and resolve ETL job failures in production and non-production environments.
  

4. Collaboration & Governance

• Work within an Agile/Scrum framework participating actively in sprint planning stand-ups and retrospectives.
  

• Partner with Business Analysts Data Architects and fellow Developers to translate data requirements into optimized technical solutions.
  

• Document technical ETL workflows source-to-target data mappings and system processes.
  

• Ensure all data movements strictly adhere to enterprise data governance security and compliance standards.
  

Required Skills & Qualifications

Core Technical Expertise

• IBM DataStage: Strong development experience utilizing both Parallel Jobs and Server Jobs.
  

• Talend: Practical experience with Talend Open Studio and/or Talend Data Integration tools.
  

• Database & SQL: Advanced SQL knowledge across major enterprise relational databases (e.g. Oracle SQL Server IBM DB2).
  

• Data Modeling: Solid foundational understanding of relational data modeling and data warehousing methodologies.
  

Operating Systems & Scripting

• Unix/Linux: Hands-on experience writing and executing Shell scripts (sh bash) for automation and process scheduling.