Lead Data Warehouse & ETL Developer - Newtown Square, PA - F2F Interview

Hybrid in Newtown Square, PA, US • Posted 13 hours ago • Updated 13 hours ago
Contract W2
Contract Corp To Corp
Contract Independent
6 Months
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Job Details

Skills

  • Data Warehouse
  • Database
  • Extract
  • Transform
  • Load
  • Job Scheduling
  • ODS
  • Oracle
  • Performance Tuning
  • Change Data Capture
  • Data Marts
  • Production Support
  • Profit And Loss
  • SCD
  • SOP
  • SQL
  • Slowly Changing Dimensions

Summary

Job title: Lead Data Warehouse & ETL Developer
Location: Newtown Square, PA (Hybrid)
Duration: 6 Months
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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10202300
  • Position Id: 8990187
  • Posted 13 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Newtown Square, Pennsylvania

Today

Easy Apply

Contract, Third Party

Depends on Experience

Newtown Square, Pennsylvania

Today

Easy Apply

Contract, Third Party

Depends on Experience

Hybrid in Philadelphia, Pennsylvania

4d ago

Easy Apply

Contract

$50 - $55

Hybrid in Newtown Square, Pennsylvania

Today

Easy Apply

Contract

66 - 68

Search all similar jobs