Contract
Location: Newtown Square, PA (Onsite)
Interview Process: Onsite interview.
Must Have Skills:
Datastage
SQL
Incident, Problem & Change Management
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
SQL
Incident, Problem & Change Management
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
JD:
• 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
Operational Metrics Reporting
Runbook SOP Development
Root Cause Analysis Troubleshooting
