Data ETL Consultant

ALLEGIS GROUP SINGAPORE PRIVATE LIMITED; Singapore; On-site; SGD 80,000 - 110,000; Full time

Job summary

A leading technology solutions provider in Singapore is seeking an experienced ETL Consultant to design, develop, and deliver data integration and extraction solutions using IBM DataStage and Control-M. The ideal candidate should have over 7 years of experience with IBM DataStage, strong analytical skills, and familiarity with multi-domain projects. This role involves collaborating with stakeholders to implement requirements and ensuring quality delivery through established best practices.

Qualifications

• 7+ years of experience with IBM DataStage and 10+ years overall in ETL/data integration.
• Exposure to multi-domain projects including Retail, Supply Chain, Manufacturing, and Digital.
• Strong analytical and problem-solving skills.

Responsibilities

• Design, develop, and deliver ETL/data integration solutions using IBM DataStage and Control-M.
• Collaborate with stakeholders to implement new requirements.
• Establish and document best practices and coding standards.

Skills

IBM DataStage

Unix

SQL

Python

Java

Kafka

Agile methodologies

Data integration across diverse formats

Advanced SQL knowledge

Job description

Roles & Responsibilities

The ETL Consultant will be responsible for designing, developing, and delivering data integration and extraction solutions using IBM DataStage and Control-M 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.

• 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 (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: 7+ years with IBM DataStage; 10+ years overall in ETL/data integration.
• Domain Expertise: Exposure to multi-domain projects (Retail, Supply Chain, Manufacturing, Digital, etc.).
• Technical Skills: Mandatory: IBM DataStage, Unix, SQL
• Advanced 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)
• Programming experience: Python, Java, Kafka
• Methodologies: Strong understanding of Agile development and software project lifecycle.
• Soft Skills: Excellent verbal and written communication skills

1. Strong analytical and problem-solving abilities
2. Ability to lead, mentor, and train teams
3. Process-oriented with strong documentation skills
4. Skilled at prioritizing and managing multiple projects

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