IBM DataStage ETL Developer

Ascii Group, LLC
Philadelphia, PA, United States
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$124,800.0 - $135,200.0
Working hours
Regular working hours
Job source

Tech stack

Extract Transform Load (ETL) Data Mart Data Warehousing IBM InfoSphere DataStage Job Scheduling Operational Data Store Oracle Databases Oracle (Applications) Performance Tuning Shell Script PL-SQL Data Logging
+2 more
Sql Optimization Data Management

Requirements

Relevant Experience (in Yrs.): 8+yrs.

Detailed Job Description:

Monitor, troubleshoot, and optimize DataStage job performance

Handle production support issues, reruns, and data reconciliations

Perform root cause analysis for ETL and data-related issues

Implement error handling, logging, and restartability in ETL jobs

Strong analytical and problem-solving skills

Ability to work independently and handle complex data issues

Good communication and stakeholder management skills

Production support and ownership mindset

Must Have Skills:

5-10+ years of experience in Data Warehousing and ETL development

IBM DataStage (8.x / 11.x preferred) - strong hands-on experience

Oracle Database (11g/12c/19c) - advanced SQL and PL/SQL

Enterprise Data Warehouse concepts (EDW, ODS, Data Marts)

ETL concepts: CDC, incremental loads, Slowly Changing Dimensions (SCD)

Performance tuning for ETL jobs and Oracle queries

Unix/Linux shell scripting (basic to intermediate)

Job scheduling tools (Tidal or equivalent)

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:57 min

Core technical practices for robust data engineering

Sandhya Menon Sandhya Menon · WWC Europe 2026

3:21 min

Building a custom bash script to detect secrets

Dwayne Mcdaniel · LIVE

4:43 min

Building an anti-money laundering production architecture with Python

Stefan Donsa Stefan Donsa +1 · LIVE

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

3:35 min

Controlling browser configurations via simple Bash scripts

Benjamin Bischoff Benjamin Bischoff · Europe 2026 Virtual

5:19 min

Executing queries and scheduling pipeline jobs within DataWorks

Qiyang Duan · LIVE

Videos

See all

Related articles

See all