Similar Jobs
Pega Developer
04/24/2025
Urgent Hiring
Azure cloud Developer
01/20/2025
Urgent Hiring
IT Tester
10/08/2024
Urgent Hiring
Lead Python API Developer
10/02/2024
Urgent Hiring
power bi developer
09/30/2024
Urgent Hiring
Cyber Security
09/27/2024
Urgent Hiring
Data Analyst
08/28/2024
Urgent Hiring
Lead Java Developer
08/28/2024
Urgent Hiring
Data Scientist/Machine Learning Engineer
Roswell, GA.
Contract W2, C2H W2, Contract Corp-To-Corp, C2H Corp-To-Corp
Depends on experience
08/28/2024
Urgent Hiring
Data Analyst
05/16/2023
Business Analyst
04/24/2023
Urgent Hiring
Open Stack Developer
08/01/2025
Urgent Hiring
Fullstack Developer
02/27/2023
Sr Azure Cloud Engineer
09/14/2026
Mainframe Technical Developer
09/08/2026
Lead DataStage Integration Support Engineer
Culver City, CA, US.
Contract Corp-To-Corp
Job Alerts:
NoYes
Save
Posted on:08/31/2026
64
Similar Jobs
Depends on experience
CI/CD,Control-M,DataStage,DevOps,ETL Development,ITSM,JIRA,MFT,Python,SQL,Unix Shell Scripts
Work type: Hybrid - 4 days On site and one day remote
Work authorization: US local resources,Work authorization required,Work authorization sponsored,Work authorization in field of study
Veteran Service: Yes
Number of hirings: 1
Job Details
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 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
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 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
Interview type: Telephonic
Experience years required: 6