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 : Newtown Square, PA (Hybrid) D uration : 6 M onths F2F Interview Must Have Skills Datastage SQL Job Description 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 Owns EDWH/ Datastage production support and defect resolution Manages EDWH/ Datastage batch schedules, reconciliations, and data accuracy IBM DataStage support & Administration Enterprise Data Warehouse (EDWH) Management Batch Job Scheduling & Monitoring Data Reconciliation & Validation Production Support & Defect Resolution
SQL & ETL
Troubleshooting Top 3 responsibilities Operational Metrics Reporting Runbook SOP Development Root Cause Analysis Troubleshooting