ETL Developer

Job title Senior / Lead Data Warehouse & ETL Developer (IBM DataStage & Oracle) Work location Philadelphia, PA Is it Hybrid, onsite or remote position Hybrid (3 days/wk from client office in Philadelphia) Tentative Start date May 4, 2026 Contract duration 6 months (will be extended based on the performance) Vendor rate - Does this position require . independent candidates only? Yes 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) 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 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 Interview mode - In person/Virtual Virtual (Video) How many rounds of interview - 2