IBM Datastage Developer

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

Job summary

Sonsoft Inc is seeking candidates for a role requiring 4+ years of experience in back end RDBMS and data modeling, specifically with Oracle and DB2. Candidates should have hands-on expertise in IBM Datastage ETL Projects and demonstrate analytical skills.

The ideal applicant will possess a Bachelor's degree or equivalent experience in IT and has a strong understanding of UNIX/Linux systems and scheduling tools. Candidates must be U.S. Citizens or authorized workers.

Qualifications

• 4+ years of experience with back end RDBMS and data modeling/database design.
• 4+ years in Design, Development & Build activities in IBM Datastage ETL Projects.
• 3 years in software development life cycle.
• 3 years in DW/BI technologies and tools.

Responsibilities

• Provide expertise in strategic technical direction and system architecture.
• Hands-on development mentality with problem-solving skills.
• Monitor and run jobs using Datastage Director.

Skills

Back end RDBMS

IBM Datastage (v8.5 and above)

Data loading techniques using Datastage

Unix/Linux system knowledge

Scheduling tools (Autosys, Control-M, Tivoli)

Financial domain experience

Education

Bachelor's degree or foreign equivalent

Tools

Oracle

DB2

Job description

Job Description

• At least 4 years of experience with back end RDBMS and data modeling / database design (Oracle and DB2 preferred)
• At least 4 years of hands on experience in Design, Development & Build activities in IBM Datastage (v8.5 and above) ETL Projects
• At least 3 years of experience in software development life cycle
• At least 3 years of experience in DW/BI related technologies and tools - MUST
• At least 3 years of experience in Project life cycle activities on DW/BI development and maintenance projects
• At least 2 years of experience in Design and Architecture review
• Knowledge of IBM Datastage Architecture, Stages/Transformations, Design, ETL flow, advanced SQLs
• Knowledge of data loading techniques using Datastage
• Using Datastage Director for running and monitoring the jobs.
• Created Datastage sequences to run the batch jobs.
• Knowledge Best Practices in Datastage, Performance improvements, implementing CDC, UDFs
• Understanding of Unix/Linux system, file systems, shell scripting
• Strong understanding of scheduling tools such as Autosys, Control- M, Tivoli etc.
• Good knowledge on MF file structures along with RDBMS.
• Provides expertise in determining the strategic technical direction and system architecture for initiatives.
• Hands‑on development mentality, with a willingness to troubleshoot and solve complex problems
• Strong analytical skills
• Experience in Financial domain
• Experience and desire to work in a Global delivery environment

Qualifications

• Bachelor's degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education
• At least 4 years of experience with Information Technology

Additional Information

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.**