IT - Technology Lead | Data Management - Data Integration | DataStage

Cloudspace LLC

Newtown Square, PA, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Compensation

$50,000.0 - $90,000.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Data Integration Extract Transform Load (ETL) Data Mart Data Warehousing IBM InfoSphere DataStage Job Scheduling Operational Data Store Oracle Databases Oracle (Applications) Performance Tuning Runbook PL-SQL

+3 more

SQL Databases Sql Optimization Data Management

Job description

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 Minimum years of experience 8-10 years Certifications Needed :No Top 3 responsibilities you would expect the Subcon to shoulder and execute Operational Metrics Reporting Runbook SOP Development Root Cause Analysis Troubleshooting Interview Process (Is face to face required?), You want investigative work that matters - sitting in the interviews, building the record, shaping how a case gets resolved. This Title IX role puts you in the room: off-site inter…

7 days ago +

Requirements

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 Nice to have skills Datastage SQL