Data stage ETL Developer

SGS Consulting; Lake Forest (CA); On-site; USD 100,000 - 120,000; Full time

Benefits offered by this job

Paid vacations

Medical insurance

401K savings plan

Life insurance

Disability insurance

Job summary

A leading professional services firm in California seeks an experienced ETL Developer with over 6 years in Data Stage and strong DB2/SQL skills. The role involves designing, developing, and tuning ETL jobs, providing end-to-end solutions for analytics, and supporting offshore teams. Candidates should demonstrate technical proficiency and ability to troubleshoot ETL processes. The position offers comprehensive benefits including a 401K savings plan and medical insurance.

Qualifications

• Minimum of 6 years of experience using Data Stage for ETL design and implementation.
• In-depth experience with DB2 and SQL Server databases.
• Strong UNIX scripting skills.

Responsibilities

• Provide end-to-end solutions for analytics ETL processes.
• Design and develop ETL jobs from specifications.
• Performance tuning of ETL jobs to meet SLAs.

Skills

Data Stage

DB2

SQL Server

UNIX scripting

Job description

About US: SGS is a New Jersey headquartered end-to-end Professional Services firm servicing a diverse Fortune clientele. SGS is a Equal Opportunity Employer and prides itself as a employee oriented organization that considers an ensemble of all employee satisfaction elements crucial to organizational and employee growth. We offer a complete range of benefit packages to our employees which includes but is not limited to paid vacations, holidays, personal days, medical insurance, 401K savings plan, life insurance, disability insurance and many other attractive benefits.

Job Description

• Minimum of 6 years of work experience using Data Stage for multi-terabyte Data warehouse in the area of ETL design, implementation and deployment.
• Provide end-to-end solution for both analytics ETL process and point-to-point application integration.
• Ability to articulate technical specifications, business requirements and systems specifications.
• Design and develop ETL jobs from function specification.
• Performance tuning of ETL jobs to keep data loads within SLA.
• Troubleshoot ETL processes failures or warnings and provide technical support for all.
• Coordinate with offshore team and train new team members.

Qualifications

• In-depth experience with DB2 and SQL Server database and UNIX scripting.