ETL DataStage Developer

ETL DataStage Developer

Posted 1 day ago by 1764998557

Apply
Negotiable
Outside
Remote
USA
Apply
Agile Methodology Amazon Web Services (AWS) Business Reporting Cloud Computing Cloud Technology Data Extraction Data Processing Data Quality Data Validation Data Warehousing Debugging Extract Transform Load (ETL) File Servers Google Cloud Google Cloud Platform (GCP) IBM DB2 IBM InfoSphere (ETL Tools) IBM InfoSphere DataStage IBM Software Microsoft Azure Microsoft SQL Servers Scheduling Scripting Software Development SQL (Programming Language) Technical Documentation Verification And Validation Version Control Workflows

Summary: The ETL DataStage Developer role involves designing, building, and supporting ETL workflows for data warehousing and business reporting. The position requires hands-on experience with IBM DataStage and strong SQL skills to manage data extraction, transformation, and loading processes. The developer will also troubleshoot job failures and collaborate with business teams to meet data requirements. This role is remote and classified as outside IR35.

Key Responsibilities:

  • Develop, test, and maintain ETL jobs using IBM DataStage.
  • Extract, transform, and load data from multiple sources (databases, flat files, etc.).
  • Write and optimize SQL queries for data processing.
  • Perform data validation and resolve data quality issues.
  • Support daily ETL operations and troubleshoot job failures.
  • Work with business teams to understand data requirements.
  • Create and update technical documentation.
  • Ensure ETL jobs run efficiently and meet performance standards.

Key Skills:

  • Hands-on experience with IBM InfoSphere DataStage (server & parallel jobs).
  • Strong SQL and database knowledge (Oracle, DB2, SQL Server, etc.).
  • Good understanding of ETL concepts and data warehousing.
  • Experience with Linux/Unix and shell scripting.
  • Strong debugging and problem-solving skills.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

We are looking for an ETL DataStage Developer to design, build, and support ETL workflows for our data warehouse and business reporting needs.

Responsibilities

  • Develop, test, and maintain ETL jobs using IBM DataStage.

  • Extract, transform, and load data from multiple sources (databases, flat files, etc.).

  • Write and optimize SQL queries for data processing.

  • Perform data validation and resolve data quality issues.

  • Support daily ETL operations and troubleshoot job failures.

  • Work with business teams to understand data requirements.

  • Create and update technical documentation.

  • Ensure ETL jobs run efficiently and meet performance standards.

Skills & Experience

  • Hands-on experience with IBM InfoSphere DataStage (server & parallel jobs).

  • Strong SQL and database knowledge (Oracle, DB2, SQL Server, etc.).

  • Good understanding of ETL concepts and data warehousing.

  • Experience with Linux/Unix and shell scripting.

  • Strong debugging and problem-solving skills.

Nice to Have

  • Experience with cloud data platforms (AWS / Azure / Google Cloud Platform).

  • Knowledge of scheduling tools and version control.

  • Experience in Agile environment.

Apply
Similar Jobs
Loading data...