DataStage ETL Engineer - Automation & Production Reliability

AMA Global Technology Inc; Culver City (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

AMA Global Technology Inc is seeking an experienced ETL DataStage Consultant to join our Culver City, CA team. The role covers development, administration, production support, and ongoing maintenance of DataStage ETL workflows.

The ideal candidate will also contribute Python and SQL scripting efforts, work with Unix environments, and collaborate with onshore/offshore teams to ensure reliable data integration and security.

Qualifications

• 6 years of proven ETL development and DataStage administration experience.
• Unix shell scripts, Cron jobs, and relational databases knowledge.
• Strong Python scripting and SQL query skills for automation and data manipulation.
• Experience leading utilities/frameworks to automate functionality and environment checks.
• Familiarity with Control-M, MFT, and IBM Gentran is a plus.

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 for optimal performance and reliability.
• Monitor system performance and troubleshoot ETL issues.
• Implement security best practices for data handling and integration.
• Provide production support and resolve incidents promptly.
• Monitor job logs and performance metrics to address potential issues.
• Plan and execute maintenance activities including upgrades and patches.
• Ensure compliance with organizational policies during maintenance.
• Document processes 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.
• Collaborate with business and technical teams and manage application support and KPI/SLA tracking.

Skills

ETL DataStage

Unix shell scripting

Cron jobs

Relational databases

Python scripting

SQL queries

Automation utilities

Control-M

MFT

IBM Gentran

JIRA

CI/CD

DevOps

Analytical skills

Communication

Snowflake

Tools

DataStage

Job description

AMA Global Technology Inc is seeking an experienced ETL DataStage Consultant to join our Culver City, CA team. The role covers development, administration, production support, and ongoing maintenance of DataStage ETL workflows.

The ideal candidate will also contribute Python and SQL scripting efforts, work with Unix environments, and collaborate with onshore/offshore teams to ensure reliable data integration and security.