Lead DataStage Consultant

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

Job Title : Lead ETL DataStage Consultant

Location: Milpitas CA (4days onsite/ week)

Duration: 3-6 Months

Work Experience 7-10Years

Job Description:

We are seeking a skilled Lead ETL DataStage Consultant with expertise in development, administration, production support, and maintenance. The ideal candidate will have a strong background in ETL processes, along with proficiency in Python and SQL scripting. Experience with Control-M, Managed File Transfer (MFT), and IBM Gentran is a plus. This role is crucial for ensuring the efficiency and reliability of our data integration processes.

Key Responsibilities

• Understand requirements and implement ETL processes using DataStage to extract, transform, and load data from various sources.
• Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications.
• Write and optimize SQL queries for data manipulation and retrieval.
• Manage and configure DataStage environments, ensuring optimal performance and reliability.
• Monitor system performance and troubleshoot issues related to ETL processes.
• Implement security best practices for data handling and integration.
• Provide support for production processes, troubleshoot and resolve issues as they arise. Monitor job logs and performance metrics to proactively identify and address potential issues. Implement incident management processes to ensure timely resolution of production incidents.
• Plan and execute regular maintenance activities, including system upgrades and patches. Ensure compliance with organizational policies and industry standards during maintenance activities. Document processes, procedures, and configurations for knowledge sharing.
• Utilize Python for scripting tasks related to data processing and automation. Develop and maintain SQL scripts for data validation and transformation.
• Work closely with business & technical teams & manage application support & track KPI/SLA

Qualifications

• 6 years of proven experience in ETL development and administration using DataStage.
• Solid understanding of Unix shell scripts, Cron jobs & Relational databases Strong knowledge in Python & SQL queries to do automation and improvements in the platform.
• Lead & drive utilities/frameworks to automate functionality and environment checks.
• Familiarity with Control-M, MFT, and IBM Gentran is a plus.
• Very strong in ITSM process knowledge and SLA expectations
• Knowledge of Agile delivery models with tools like JIRA, CI/CD pipelines, and DevOps practices.
• Excellent analytical and problem-solving skills Clear communication and exposure to work in onshore-offshore model

Nice To Have

Understanding and/or hands-on with Snowflake platform

Disclaimer: i-Link Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability.