Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Lead Data Warehouse & ETL Developer
Job
HUMAC INC.
Remote
Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
71
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
Job title: Lead Data Warehouse & ETL Developer L ocation : Philadelphia, PA (Hybrid) 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) 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