Datastage Developer

Job Description

• Understanding business requirements and translating them into technical specifications for ETL solutions.
• Designing and developing Data Stage jobs to extract, transform, and load data.
• Using various Data Stage stages (e.g., Transformer, Aggregator, Lookup, Filter) to manipulate data.
• Creating job sequences using Autosys to orchestrate the execution of multiple jobs.
• Experience in Git and knowledge of Dev Ops practices and tools.
• Familiarity with containerization technologies (e.g., Docker, Kubernetes).
• Python skills and good knowledge of SQL & PL/SQL.
• Manage and maintain Data Stage server environments, ensuring system stability and performance (both on‑prem and cloud).
• Analyzing and optimizing existing ETL jobs for performance improvements.
• Troubleshooting ETL job failures and identifying root causes during migration.
• Monitoring job execution and proactively addressing potential issues.
• Implement and maintain best practices for ETL design and creation.
• Hands‑on experience migrating or upgrading Data Stage from on‑prem to cloud.
• Document processes, procedures, and system configurations for knowledge sharing.
• Participate in team calls and meetings.

• Data Stage Anywhere ETL.
• SQL.
• Python.

$100,000 to $120,000 Per Annum

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage:
  Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support:
  Maternal & Parental Leaves.
• Insurance Options:
  Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth:
  Commuter Benefits & Certification & Training Reimbursement.
• Time Off:
  Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance:
  Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

BACHELOR OF COMPUTER SCIENCE