ETL Integration Developer

Compunnel, Inc.; Oaks (PA); On-site; USD 90,000 - 120,000; Full time

Job summary

A data integration solutions provider in Pennsylvania is seeking an experienced ETL Integration Developer. The candidate will design and maintain data integration workflows, utilizing IBM DataStage and Zena. Responsibilities include building robust processes, ensuring data accuracy, and performing automation tasks. The role requires strong experience in ETL development and workflow orchestration, making it ideal for candidates with a programming background in C#. Competitive compensation offered.

Qualifications

• 5+ years of experience in DataStage ETL development.
• 2+ years of experience in Zena workflow orchestration.
• 2+ years of experience in Snowflake data integration.

Responsibilities

• Develop ETL processes using IBM DataStage.
• Integrate with vendor platforms for secure data exchange.
• Support document processing using Exstream.
• Create and maintain test automation suites.

Skills

ETL Development

DataStage

Workflow Orchestration

C# Programming

Data Integration

Education

Bachelor’s degree in Computer Science or related field

Tools

IBM DataStage

Zena

Snowflake

sFTP

Splunk

Job description

We are seeking an experienced ETL Integration Developer to design, develop, and maintain data integration workflows.

The ideal candidate will have strong expertise in ETL development using DataStage, workflow orchestration, and data integration with modern platforms.

This role involves building robust processes, ensuring data accuracy, and supporting automation and monitoring for seamless operations.

Key Responsibilities

• Develop ETL processes using IBM DataStage and orchestrate workflows with Zena.
• Integrate with vendor platforms such as Snowflake, Swift, and sFTP for secure data exchange.
• Build C# modules for data transformation and metadata handling.
• Support document and statement processing using Exstream and ensure delivery to internal systems.
• Implement robust error handling and Splunk-based logging for operational monitoring.
• Create and maintain Karate test automation suites to validate data flows.
• Document integration processes and provide support procedures for internal teams.

Required Qualifications

• Bachelor’s degree in Computer Science or related field, or 5+ years of relevant experience.
• 5+ years of experience in DataStage ETL development.
• 2+ years of experience in Zena workflow orchestration.
• 2+ years of experience in Snowflake data integration.

Preferred Qualifications

• Experience with C# programming for data transformation.
• Familiarity with sFTP and Swift transmission protocols.
• Knowledge of Splunk for logging and monitoring.