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

Description: POC: Sam Chavez

ATTENTION ALL SUPPLIERS!!!

READ BEFORE SUBMITTING:
UPDATED CONTACT NUMBER and EMAIL ID is a MANDATORY REQUEST from our client for all the submissions
We prioritize endorsing those with complete and accurate information
Avoid submitting duplicate profiles. We will Reject/Disqualify immediately.
Make sure that candidate's interview schedules are updated. Please inform the candidate to keep their lines open.
Please submit profiles within the max proposed rate***
Please make sure to TAG the profiles correctly if the candidate has WORKED FOR *** as a SUBCON or FTE.

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