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

Expedite Talent Solutions; Philadelphia (Philadelphia County); Hybrid; USD 96,000 - 165,000; Full time

Job summary

Expedite Talent Solutions is seeking a Technology Lead - Engineering | Data Management to own data integration and DataStage-based ETL initiatives in a hybrid Philadelphia environment. The role emphasizes production support, performance tuning, and collaboration with data stakeholders.

You will monitor DataStage jobs, participate in root-cause analysis, implement robust error handling, and drive data quality across EDW, ODS, and data marts. Prior experience in healthcare data is a plus.

Qualifications

• 5–10+ years in Data Warehousing and ETL development.
• IBM DataStage (8.x/11.x) hands-on experience.
• Oracle Database (11g/12c/19c), advanced SQL & PL/SQL.
• EDW concepts: EDW, ODS, Data Marts.
• ETL concepts: CDC, incremental loads, SCD.
• ETL performance tuning for ETL jobs and Oracle queries.
• Unix/Linux shell scripting (basic to intermediate).
• Job scheduling tools (Tidal or equivalent).

Responsibilities

• Monitor, troubleshoot, and optimize DataStage job performance.
• Handle production support issues, reruns, and data reconciliations.
• Perform root cause analysis for ETL and data-related issues.
• Implement error handling, logging, and restartability in ETL jobs.
• Strong analytical and problem-solving skills.
• Ability to work independently and handle complex data issues.
• Good communication and stakeholder management skills.
• Production support and ownership mindset.

Skills

Data Warehousing

ETL development

IBM DataStage

Oracle SQL/PLSQL

EDW concepts

CDC & SCD

ETL performance tuning

Unix/Linux scripting

Job scheduling

Healthcare

Education

Certifications

Job description

Description: POC: Sam Chavez

ATTENTION ALL SUPPLIERS!!!

READ BEFORE SUBMITTING:

MANDATORY: Please include in the resume the candidate’s complete & updated contact information (Phone number, Email address and Skype ID) as well as a set of 5 interview timeslots over a 72-hour period after submitting the profile when the hiring managers could potentially reach to them. PROFILES WITHOUT THE REQUIRED DETAILS and TIME SLOTS will be REJECTED.

Job Title: Technology Lead - Engineering | Data Management - Data Integration | DataStage --

Work Location & Reporting Address

Philadelphia, PA 19113 (Onsite-Hybrd. Local candidates are highly preferred but will also consider candidates willing to relocate immediately and as long as they are able to join by Day 1)

Contract duration

6

MAX VENDOR RATE

***-*** per hour max

Target Start Date

10 Aug 2026

Does this position require Visa independent candidates only?

Yes

Must Have Skills

• 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
• Unix/Linux shell scripting (basic to intermediate)
• Job scheduling tools (Tidal or equivalent)

Nice to Have Skills

• Healthcare background

Detailed Job Description

• Monitor, troubleshoot, and optimize DataStage job performance
• Handle production support issues, reruns, and data reconciliations
• Perform root cause analysis for ETL and data-related issues
• Implement error handling, logging, and restartability in ETL jobs
• Strong analytical and problem-solving skills
• Ability to work independently and handle complex data issues
• Good communication and stakeholder management skills
• Production support and ownership mindset

Minimum Years of Experience

• 6+ years

Certifications Needed

• Any applicable certifications

Top 3 responsibilities you would expect the Subcon to shoulder and execute

Interview Process (Is face to face required?)

• Virtual

Any additional information you would like to share about the project specs/nature of work

Custom Fields

Name: Intake Call Requested

Value: true

Name: Intake Call Completed

Value: true