IPolarity
Data Stage ETL Developer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Stage ETL Developer with 5-10+ years in Data Warehousing, strong IBM DataStage and Oracle skills, and healthcare domain experience. Contract length is unspecified, with a pay rate of "unknown," located in Philadelphia, PA, hybrid.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
May 30, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Philadelphia, PA
-
🧠 - Skills detailed
#Shell Scripting #DataStage #Linux #Data Reconciliation #Logging #Unix #Scripting #Data Warehouse #"ETL (Extract #Transform #Load)" #Oracle #Slowly Changing Dimensions #SQL (Structured Query Language) #Data Mart #EDW (Enterprise Data Warehouse)
Role description
Job title – Senior / Lead Data Warehouse & ETL Developer (IBM DataStage & Oracle)
Work location – Philadelphia, PA , Hybrid
only GC/USC
Mandatory 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)
Domain - Healthcare
Interview mode - In person/Virtual – Virtual (Video)
How many rounds of interview - 2
Any certification required – good to have
Complete 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.
Job title – Senior / Lead Data Warehouse & ETL Developer (IBM DataStage & Oracle)
Work location – Philadelphia, PA , Hybrid
only GC/USC
Mandatory 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)
Domain - Healthcare
Interview mode - In person/Virtual – Virtual (Video)
How many rounds of interview - 2
Any certification required – good to have
Complete 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.
