Datastage ETL Specialist – DW/BI & Oracle SQL

Sonsoft Inc; Agoura Hills (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

Sonsoft Inc is seeking an experienced IT professional in Agoura Hills, California, specializing in Software Development and ETL projects using IBM Datastage. The ideal candidate will have at least 4 years of hands-on experience with RDBMS and data modeling, alongside extensive skills in Oracle SQL/PLSQL and a strong understanding of the Financial domain.

This full-time permanent role offers opportunities for U.S. citizens and authorized workers only. The position emphasizes hands-on development skills and project lifecycle experience.

Qualifications

• At least 4 years of experience with back end RDBMS and data modeling.
• Experience in Design, Development & Build activities in IBM Datastage ETL Projects.
• Experience in software development life cycle and DW/BI related technologies.

Responsibilities

• Provide expertise in determining the strategic technical direction.
• Hands-on development mentality with troubleshooting skills.
• Create Datastage sequences to run batch jobs.

Skills

Back end RDBMS and data modeling / database design (Oracle and DB2 preferred)

IBM Datastage (v8.5 and above) ETL Projects

Financial domain experience

Oracle SQL, PL/SQL

Unix/Linux system understanding

Query tuning skills

Education

Bachelor’s degree or foreign equivalent

Tools

IBM Datastage

Toad

Autosys

Control- M

Tivoli

Job description

Sonsoft Inc is seeking an experienced IT professional in Agoura Hills, California, specializing in Software Development and ETL projects using IBM Datastage. The ideal candidate will have at least 4 years of hands-on experience with RDBMS and data modeling, alongside extensive skills in Oracle SQL/PLSQL and a strong understanding of the Financial domain.

This full-time permanent role offers opportunities for U.S. citizens and authorized workers only. The position emphasizes hands-on development skills and project lifecycle experience.