Data ETL Consultant

Tek Systems; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

A leading technology staffing firm in Singapore is seeking an experienced ETL Consultant to design and develop robust data integration solutions using IBM DataStage and Talend. The role requires a strong background in ETL/data integration with over 8 years of experience, along with agile methodologies and a variety of technical skills including SQL, Unix, and Control-M. This position also emphasizes mentorship, collaboration with stakeholders, and effective documentation practices.

Qualifications

• 8+ years of experience in ETL/data integration, specifically with IBM DataStage and Talend.
• Exposure to retail, supply chain, manufacturing, or digital domains is beneficial.
• Strong understanding of Agile development and software project lifecycle.

Responsibilities

• Design, develop, and deliver ETL/data integration solutions using IBM DataStage and Talend.
• Collaborate with stakeholders to implement new requirements.
• Establish and document coding standards and best practices.
• Resolve data quality issues through analysis.
• Lead by example, mentor colleagues, and strengthen team capabilities.

Skills

IBM DataStage

Talend

Unix

SQL

Control-M

Python

Java

Kafka

Job description

• Design, develop, and deliver ETL/data integration solutions using IBM DataStage and Control-M
• Collaborate with stakeholders to understand and implement new requirements.
• Contribute to migration initiatives from IBM DataStage to Talend

Summary / Purpose

The ETL Consultant will be responsible for designing, developing, and delivering data integration and extraction solutions using IBM DataStage and Talend for flow scheduling. This role involves establishing governance around code quality, norms, and guidelines, as well as contributing to technical projects such as upgrades, maintenance, decommissioning, and improvements. The consultant will support regional projects and teams while collaborating closely with central design and support teams.

Duties & Responsibilities

• Design, develop, and deliver ETL/data integration solutions using IBM DataStage and Talend.
• Collaborate with stakeholders to understand and implement new requirements.
• Contribute to migration initiatives from IBM DataStage to Talend (Talend experience is a plus).
• Establish and document best practices, coding standards, CI/CD processes, and quality delivery guidelines.
• Analyze upstream sources to debug and resolve data quality issues.
• Partner with architects and designers to validate business requirements and enforce best practices.
• Lead by example, mentor, and train peers to strengthen team capabilities.
• Maintain in-depth knowledge of business operations and project technical scope.
• Ensure proper testing and quality control processes to guarantee data integrity, scalability, and reliability.
• Support business partners by analyzing initiatives and identifying integration solutions across systems and processes.
• Work closely with central design and support teams to deliver aligned solutions.

Qualifications & Skills

• Experience: Working experience IBM DataStage and Talend; 8+ years overall in ETL/data integration.
• Domain Expertise: Exposure to multi-domain projects (Retail, Supply Chain, Manufacturing, Digital, etc.) will be beneficial.
• Technical Skills:
  • Mandatory: IBM DataStage, Talend, Unix, SQL
  • Good to Have: Control-M
  • SQL knowledge with relational databases and query optimization
  • Familiarity with multi-cloud tenant and PaaS architectures
  • Data integration across diverse formats (databases, flat files, XML, CSV, IDOC, mainframe)
  • Optimization techniques (indexes, caching, lookups)
  • Basic programming experience: Python, Java, Kafka
• Methodologies: Strong understanding of Agile development and software project lifecycle.
• Soft Skills:
  • Excellent verbal and written communication skills
  • Strong analytical and problem-solving abilities
  • Ability to lead, mentor, and train teams
  • Process-oriented with strong documentation skills
  • Skilled at prioritizing and managing multiple projects

We regret to inform that only shortlisted candidates will be notified.

EA registration number : Xuan Ng, R24123530

Allegis Group Singapore Pte Ltd, Company Reg No. 200909448N, EA Licence No. 10C4544