Questronix Corporation

DataStage Developer

Questronix Corporation

full-time

Posted on:

Location Type: Remote

Location: Philippines

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

ETLOraclePythonShell ScriptingSQL

About the role

  • 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
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ETL solutionsIBM DataStageSQLdata integrationdata modelingperformance tuningdata warehousingShell scriptingPython
Soft Skills
problem-solvingtroubleshootingcollaborationcommunicationattention to detailtime management