Robotics Prcocess Automation, LLC
ETL DataStage Lead
Robotics Prcocess Automation, LLC, Detroit, Michigan, United States, 48228
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.
ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract
#J-18808-Ljbffr
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.
ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract
#J-18808-Ljbffr