What are the responsibilities and job description for the Senior / Lead Data Warehouse & ETL Developer (IBM DataStage & Oracle) position at ClifyX?
Job Title: Senior / Lead Data Warehouse & ETL Developer (IBM DataStage & Oracle)
Location: Philadelphia, PA (Hybrid-3 days/wk from client office in Philadelphia)
Duration: 6-12 Months Contract
** W2-Visa-independent candidates required **
Job Summary:
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 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