ETL DataStage Lead
Job Details
Role: Senior ETL DataStage Lead
Location: Detroit, Michigan (4 days onsite)
Duration: Long-term contract
About the Role:
We are seeking a highly experienced ETL Lead to design, lead, and optimize enterprise data integration workflows using IBM DataStage on Cloud Pak for Data (CP4D), AWS Glue & Lambda, and Snowflake. The ideal candidate will drive modern data transformation strategies for large-scale data ingestion pipelines supporting analytics, governance, and AI/ML workloads.
Required Qualifications
- 8+ years of enterprise data integration experience with at least 3+ years as a technical lead.
- Strong expertise in IBM DataStage, including modern deployments on Cloud Pak for Data (CP4D).
- Solid experience with AWS Glue (PySpark) and AWS Lambda for scalable, serverless data transformation.
- Proven knowledge of Snowflake data warehousing, including external stages, streams, tasks, and performance tuning.
- Experience with complex ETL orchestration involving parallel processing, dynamic parameterization, and error handling.
- Strong SQL, Python (preferred for Glue), and performance tuning skills.
- Understanding of data lakehouse architectures, S3, and ingestion patterns (batch/real-time).
- Familiarity with data governance and lineage tools (e.g., Collibra, BigID, Manta).
- Knowledge of CI/CD, Git, Jenkins, and code promotion strategies.
- Strong verbal and written communication skills; experience working in agile/scrum delivery model.
Recommended Jobs
Travel CT Tech in Grand Rapids, MI - $10600/month
We are seeking a dedicated Travel CT Tech to join our healthcare team in Grand Rapids, MI. This position offers a competitive rate of $10,600/month. Responsibilities Include Performing high-qual…
Mobility Transportation Driver
Full-time and part-time positions available. ***$3,000.00 sign on bonus for full-time*** Pay starts at $17.50/hr and increases after 90 days to $18.25/hr. Full-time is a 42 hour work week and include…
Installation & Operations Manager
Description Full job description Securatech is a respected provider of integrated security and fire solutions in the U.S. We have built a strong reputation in the industry for technical experti…
Remote Customer Care Support Specialist
We are looking for a Customer Care Support Specialist who will be responsible for providing excellent customer service support by quickly and accurately processing and directing submissions verbally.…
Quality Inspector
Albar Industries, Inc., a leader in the automotive painting industry in the Lapeer area, is currently seeking dedicated and detail-oriented individuals to join our team as Quality Inspectors. As a Qu…
Registered Nurse - PRN
You Matter • Make a difference every day in the lives of the underserved • Join a mission driven organization with a people first culture • Excellent career growth opportunities Join us an…
Skilled Trades- Industrial Electrician
Skilled Trade - Industrical Electrian (Full & Part Time Positions) Nexteer Automotive - Saginaw, Michigan Operations is soliciting candidates for Industrial Electricians positions. Applicants mu…
In Home Solar Sales Representative
Join Our Team! Maximize your earning potential with a unique opportunity in solar sales! We provide a free lead program and allow you to work from anywhere using ZOOM, with no upfront costs and un…
Locum Tenens Cardiology Job MI
This Job at a Glance Job Reference Id: ORD-198283-MD-MI Title: MD Dates Needed: September - Ongoing Shift Type: Day Shift; Call Assignment Type: Clinic Call Required: Yes B…
Subaru Sales Associate
At Hodges Subaru, we strive to make every customer a customer for life. We are the oldest Subaru dealership in all of Michigan and the 10th oldest in the entire nation! Happy employees make happy cust…