What are the responsibilities and job description for the Technology Lead – DataStage / EDW position at Astir IT Solutions?
Technology Lead – DataStage / EDW 📍 Newtown Square, PA 19073 | 🏢 Hybrid | 📄 Contract – 6 Months | 🗓️ Start: ASAP 💼 Visa: Open (including VD)
Role Overview This role focuses on owning and managing enterprise data warehouse (EDWH) operations and DataStage production support. The consultant will handle batch scheduling, data reconciliation, defect resolution, and SQL/ETL troubleshooting in a hybrid setup.
Must-Have Skills
- IBM DataStage (8.x / 11.x) – strong hands-on production support & administration
- Oracle Database (11g / 12c / 19c) – advanced SQL and PL/SQL
- Enterprise Data Warehouse (EDW, ODS, Data Marts) concepts
- ETL techniques: CDC, incremental loads, SCD
- Performance tuning – ETL jobs and Oracle queries
- Incident, Problem & Change Management
- 8–10 years of experience in Data Warehousing and ETL development
Good to Have
- Additional DataStage and SQL exposure beyond core requirements
Key Responsibilities
- Operational Metrics Reporting
- Runbook / SOP Development
- Root Cause Analysis & Troubleshooting
Day-to-Day Includes:
- EDWH/DataStage batch schedule management, reconciliation & data accuracy
- Production support & defect resolution
- SQL & ETL troubleshooting
Certifications: Not required Interview Process: Please confirm – is a face-to-face interview required?