Senior ETL DataStage Specialist

UST; Culver City (CA); Hybrid; USD 62,000 - 93,000; Full time

Benefits offered by this job

Paid vacation: 10 days/yr

Paid sick leave: 6 days/yr

401(k) with employer matching

Medical, dental, and vision insurance

HSA and FSA options

Job summary

UST is seeking an ETL DataStage Consultant (Associate III - Data Engineering) in California. You will implement ETL processes using DataStage, write optimized SQL, and manage DataStage environments to ensure reliable data integration.

You will collaborate with analysts and stakeholders, follow security best practices, and support production ETL operations, including incident management and routine maintenance.

Qualifications

• 6+ years of proven ETL development and administration using DataStage.
• Expert-level proficiency in ETL processes, data extraction, transformation, and loading.
• Strong knowledge of SQL queries and scripting for data manipulation and retrieval.
• Solid programming skills in Python for scripting, automation, and data processing tasks.
• Solid understanding of Unix shell scripts and Cron jobs.
• Deep knowledge of Relational databases and data management.
• Experience with Control-M, MFT, and IBM Gentran.
• Excellent analytical and problem-solving skills.
• Strong ability to troubleshoot and resolve ETL and system performance issues.
• Proficiency in monitoring system performance and job logs.
• Experience implementing security best practices for data handling and integration.
• Knowledge of Agile delivery models with tools like JIRA, CI/CD pipelines, and DevOps practices.
• Ability to lead and drive utilities and frameworks to automate functionality and environment checks.
• Clear communication and experience in onshore-offshore models.
• Experience managing application support and tracking KPI/SLA metrics.
• Nice to Have: Snowflake platform exposure, incident management, and production support practices.

Responsibilities

• 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 ETL issues.
• Implement security best practices for data handling and integration.
• Provide production support and resolve incidents.
• Monitor job logs and performance metrics to preempt issues.
• Lead development of Python scripts for data processing and automation.

Skills

ETL DataStage

SQL

Python

Unix shell & Cron

Control-M/MFT/Gentran

Agile / JIRA / DevOps

Data integration security

Onshore-offshore collaboration

Leadership in utilities/frameworks

Snowflake (nice to have)

Tools

DataStage Server/Studio

Control-M

IBM Gentran

Job description

UST is seeking an ETL DataStage Consultant (Associate III - Data Engineering) in California. You will implement ETL processes using DataStage, write optimized SQL, and manage DataStage environments to ensure reliable data integration.

You will collaborate with analysts and stakeholders, follow security best practices, and support production ETL operations, including incident management and routine maintenance.