Datastage Developer

Questronix Corporation; Philippines; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

Questronix Corporation in the Philippines is seeking a DataStage Developer to design, build, and optimize ETL solutions using IBM DataStage. You will ensure data quality and seamless data flow across systems by implementing robust data integration workflows and clear mappings.

The role requires strong SQL skills, experience with Oracle/SQL Server/DB2, and a collaborative mindset to work with analysts, DBAs, and business stakeholders. Bachelor’s degree is required.

Qualifications

• Bachelor's degree in Computer Science, IT, or a related field.
• Proven DataStage Developer experience.
• Strong SQL and database knowledge (Oracle/SQL Server/DB2).
• Understanding ETL concepts and data warehousing.
• Experience with performance tuning and data quality.
• Excellent problem-solving and teamwork.

Responsibilities

• Design and build ETL solutions using IBM DataStage.
• Develop robust data integration workflows from sources to targets.
• Model data and mappings for accurate transformations.
• Tune ETL jobs for performance and reliability.
• Troubleshoot errors and monitor pipelines.
• Collaborate with analysts, DBAs, and stakeholders.
• Document data mappings and process flows.
• Maintain ETL processes and stay updated on trends.

Skills

ETL design

Data integration

Data modeling

Performance tuning

Troubleshooting

Team collaboration

SQL proficiency

Education

Bachelor's degree in Computer Science/Information Technology

Tools

IBM DataStage

SQL

Oracle

SQL Server

DB2

Shell scripting

Python

Job description

DataStage Developer

Company : Questronix Corporation Job Type : Full Time Philippines

As a DataStage Developer, you will play a crucial role in designing, building, and implementing ETL (Extract, Transform, Load) solutions using IBM's DataStage interface. You will be responsible for creating and maintaining efficient data integration processes to ensure the smooth flow of data within our organization.

Responsibilities

• Design and develop ETL solutions: Collaborate with stakeholders to gather requirements and translate them into scalable and efficient ETL solutions using IBM DataStage.
• Data integration: Build robust data integration workflows to extract, transform, and load data from various sources into target systems, ensuring data quality and integrity.
• Data modeling: Design and implement data models and mappings to ensure optimal performance and accuracy of data transformations.
• Performance optimization: Identify and resolve performance bottlenecks, tune ETL processes, and optimize data loading and transformation for improved efficiency.
• Error handling and troubleshooting: Implement error handling mechanisms, monitor ETL processes, and troubleshoot issues to ensure the timely resolution of data integration problems.
• Collaborate with teams: Work closely with cross-functional teams, including data analysts, database administrators, and business stakeholders, to understand requirements and deliver high-quality solutions.
• Documentation and maintenance: Create technical documentation, including data mapping, process flow diagrams, and user guides. Regularly maintain and update existing ETL processes.
• Stay updated on industry trends: Keep abreast of the latest trends, tools, and technologies in the field of data integration and ETL to propose innovative solutions and enhance existing processes.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Proven experience as a DataStage Developer or in a similar ETL development role.
• Strong proficiency in IBM DataStage, including experience with its various stages, transformations, and parallel processing.
• Solid understanding of data integration concepts, ETL principles, and data warehousing.
• Proficiency in SQL and database technologies (such as Oracle, SQL Server, or DB2) for data extraction and manipulation.
• Familiarity with data modeling and schema design.
• Experience with performance tuning and optimization of ETL processes.
• Strong problem-solving and troubleshooting skills with the ability to analyze complex data issues and provide effective solutions.
• Excellent collaboration and communication skills to work effectively within a team and interact with stakeholders.
• Attention to detail, with a focus on delivering high-quality and accurate results.
• Ability to work on multiple projects simultaneously and meet deadlines in a fast-paced environment.
• Knowledge of scripting languages (e.g., Shell scripting, Python) is a plus