Lead DataStage Engineer

CoreTek Labs; Culver City (CA); On-site; USD 115,000 - 155,000; Full time

Job summary

CoreTek Labs is seeking a Lead DataStage Integration Support Engineer in Culver City, CA for a long-term contract. The role focuses on development, administration, production support, and maintenance of ETL processes using DataStage, with Python and SQL scripting for automation.

The ideal candidate brings 11+ years in ETL and DataStage, strong Unix scripting, and experience with Control-M, MFT, and ITSM/SLA environments. Collaboration across onshore-offshore teams is essential.

Qualifications

• 11+ years of ETL development and DataStage administration experience.
• Proficient in UNIX shell scripting, Cron jobs, and SQL for automation.
• Experience with onshore-offshore delivery, ITSM processes, and SLA management.

Responsibilities

• Implement ETL processes with DataStage to extract, transform, and 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 ETL performance, troubleshoot production issues, and maintain security best practices.
• Plan maintenance activities, upgrades, patches, and ensure policy compliance.
• Document processes, procedures, and configurations for knowledge sharing.
• Collaborate with business, technical teams and manage application support; track KPI/SLA.

Skills

ETL development

DataStage

Python scripting

SQL queries

Unix shell scripting

Cron jobs

Agile delivery

JIRA

DevOps practices

Analytical skills

Communication skills

Onshore-offshore

Snowflake understanding

Tools

Control-M

MFT

IBM Gentran

JIRA

CI/CD pipelines

Snowflake

DataStage

Job description

Job Title : Lead DataStage Integration Support Engineer

Type: Long term contract

Location: Culvercity, CA

Bill Rate: $65/hr ON C2C

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:

• 11 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 Sony’s 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 Work Experience 7-10Years