DataStage ETL Engineer - Build & Optimize Data Flows

Questronix Corporation; Metro Manila; On-site; PHP 500,000 - 900,000; Full time

Job summary

Questronix Corporation in Metro Manila seeks a DataStage Developer to design, build, and implement ETL solutions using IBM DataStage. You will create and maintain data integration processes to ensure smooth data flow across systems.

Your responsibilities include shaping ETL workflows, integrating data from diverse sources, optimizing performance, handling errors, and documenting mappings. You will collaborate with data analysts and DBAs to deliver high-quality data solutions and stay current

Qualifications

• Design and develop ETL solutions using IBM DataStage.

Responsibilities

• Design and develop ETL solutions with IBM DataStage.
• Create robust data integration workflows extracting, transforming, and loading data.
• Model data and mappings for optimal performance and accuracy.
• Identify and resolve ETL performance bottlenecks.
• Implement error handling and troubleshoot data integration issues.
• Collaborate with analysts, DBAs, and stakeholders to deliver solutions.
• Maintain technical documentation and process diagrams.
• Stay updated on data integration trends and tools.

Skills

IBM DataStage

ETL development

SQL

Data warehousing

Performance tuning

Troubleshooting

Data modeling

Documentation

Cross-functional collaboration

Shell/Python scripting

Education

Bachelor's degree in Computer Science/Information Technology

Tools

IBM DataStage

Oracle

SQL Server

DB2

Job description

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.
• 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