Lead Data Warehouse & ETL Developer (IBM DataStage & Oracle

ClifyX, INC
Philadelphia, United States of America
4 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Philadelphia, United States of America

Tech stack

ETL
Data Mart
Data Warehousing
IBM InfoSphere DataStage
Job Scheduling
Operational Data Store
Oracle
Oracle Applications
Performance Tuning
Shell Script
PL-SQL
Data Logging
Sql Optimization
Data Management

Requirements

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)

Minimum years of experience needed in the required skills- 8-10 years

Minimum over all work experience required - 8

Domain - Healthcare

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 restart ability 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

Apply for this position