Senior DataStage ETL Lead — Data Integration Expert

I Link Communications Inc; Culver City (CA); On-site; USD 96,000 - 152,000; Full time

Job summary

I Link Communications Inc. in Milpitas, CA is seeking a Lead ETL DataStage Consultant for a 3–6 month engagement.

You will lead ETL development, administration, production support, and maintenance of data integration pipelines using DataStage, with Python and SQL scripting for automation. The role requires 7–10 years of experience, Unix shell scripting, Cron jobs, and familiarity with Control-M, MFT, and IBM Gentran.

Qualifications

• 7–10 years of proven ETL development and administration experience with DataStage.
• Strong Python and SQL scripting for automation and data validation.
• Familiarity with Control-M, MFT, and IBM Gentran is a plus.

Responsibilities

• Implement ETL processes using DataStage to extract/transform/load data from multiple sources.
• Write and optimize SQL queries for data manipulation and retrieval.
• Manage and configure DataStage environments for performance and reliability.
• Monitor jobs, troubleshoot ETL issues, and ensure production stability.
• Plan maintenance, upgrades, and patches; document configurations and procedures.
• Collaborate with business/technical teams and manage app support and SLA tracking.
• Develop Python scripts for data processing tasks and data validation.

Skills

ETL development

Unix shell scripting

Python

SQL

Agile delivery

ITSM processes

Tools

DataStage

Control-M

MFT

IBM Gentran

JIRA

CI/CD

Job description

I Link Communications Inc. in Milpitas, CA is seeking a Lead ETL DataStage Consultant for a 3–6 month engagement.

You will lead ETL development, administration, production support, and maintenance of data integration pipelines using DataStage, with Python and SQL scripting for automation. The role requires 7–10 years of experience, Unix shell scripting, Cron jobs, and familiarity with Control-M, MFT, and IBM Gentran.