Datastage ETL Engineer – Data Warehouse & BI Expert

Sonsoft; Newark (DE); On-site; USD 90,000 - 120,000; Full time

Job summary

Sonsoft, Inc. invites applications for a Datastage ETL Developer to design and build data integration solutions. You will craft Datastage jobs, optimize ETL pipelines, and implement reliable batch workflows within a global delivery setting.

The role requires hands-on experience with Datastage (v8.5+), SQL, and Unix/Linux; familiarity with Autosys/Control-M/Tivoli scheduling; and strong Oracle/DB2 knowledge. Bachelor's degree or equivalent is required.

Qualifications

• Bachelor’s degree or foreign equivalent required.
• At least 4 years of DW/BI and related tools experience.
• At least 4 years of hands-on Datastage ETL development experience.
• At least 3 years in SDLC and DW/BI technologies.
• Experience with backend RDBMS (Oracle/DB2 preferred).

Responsibilities

• Develop Datastage Parallel Extender jobs using multiple stages.
• Create and manage Datastage sequences to run batch jobs.
• Monitor and tune Datastage jobs using Director and scheduling tools.
• Apply best practices for performance improvements and CDC/UDFs.

Skills

Datastage

ETL/ELT

SQL

Unix/Linux scripting

Autosys

Control-M

Tivoli

Oracle

DB2

DW/BI

Education

Bachelor’s degree or foreign equivalent

Tools

Datastage

Job description

Sonsoft, Inc. invites applications for a Datastage ETL Developer to design and build data integration solutions. You will craft Datastage jobs, optimize ETL pipelines, and implement reliable batch workflows within a global delivery setting.

The role requires hands-on experience with Datastage (v8.5+), SQL, and Unix/Linux; familiarity with Autosys/Control-M/Tivoli scheduling; and strong Oracle/DB2 knowledge. Bachelor's degree or equivalent is required.