Data stage ETL Developer

SGS Consulting

Apply to this job
Lake Forest, CA, us on site Until 8/21/2026 First posted March 26, 2025 Last posted March 26, 2025
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.

• 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.


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



About this role

Summary

Design, develop, and optimize ETL jobs for data warehouse projects.

Job title

Data stage ETL Developer

Experience level

6+ years

Industry

professional services

Location requirements

Lake Forest, CA, on-site, no remote work

Salary

Not specified

Management role

No

Skills & keywords

Required skills

Data StageETLDB2SQL ServerUNIX scripting

Preferred skills

None specified

Specializations

ETLData warehouseSQLUNIX scripting
Locations

Structured locations inferred from the posting.

Lake Forest, CA, USA

On-site City