Datastage ETL Lead & Developer — DW/BI Expert

Sonsoft; Newark (DE); On-site; USD 95,000 - 125,000; Full time

Job summary

Sonsoft, Inc. in the United States is seeking a mid- to senior-level IBM Datastage Developer to design and build ETL pipelines, optimize performance, and implement CDC in a data warehouse environment.

The role requires Unix/Linux, strong SQL, experience with scheduling tools (Autosys, Control-M, Tivoli), and solid data modeling with Oracle/DB2. This is a full-time position based in Newark, DE.

Qualifications

• Bachelor’s degree or foreign equivalent required; relevant work experience may substitute for education on a year-for-year basis.
• At least 4 years of DW/BI experience and related tools.
• Hands-on IBM Datastage design, development & build activities (v8.5+).
• Experience with back-end RDBMS and data modeling (Oracle/DB2 preferred).
• Experience with ETL/ELT concepts and data loading techniques.

Responsibilities

• Design, develop & build ETL/ELT solutions in IBM Datastage.
• Create Datastage sequences to run batch jobs and manage workflows.
• Improve performance and implement CDC in data pipelines.
• Utilize Unix/Linux systems, file systems, and shell scripting.
• Work with scheduling tools like Autosys/Control-M/Tivoli for job orchestration.
• Apply strong analytical skills in a global delivery environment.

Skills

ETL concepts

Data modeling

Analytical skills

Education

Bachelor’s degree or foreign equivalent

Tools

IBM Datastage

Unix/Linux

Autosys

SQL

RDBMS

CDC

Job description

Sonsoft, Inc. in the United States is seeking a mid- to senior-level IBM Datastage Developer to design and build ETL pipelines, optimize performance, and implement CDC in a data warehouse environment.

The role requires Unix/Linux, strong SQL, experience with scheduling tools (Autosys, Control-M, Tivoli), and solid data modeling with Oracle/DB2. This is a full-time position based in Newark, DE.