# Data stage ETL Developer — SGS Consulting

- Location: Lake Forest, CA
- Posted: Jul 21, 2015
- Status: open (checked Nov 20, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/sgsconsulting/84217307
- Employer record: https://visajobs.io/company/software-galaxy-systems.md

## Sponsorship history
- Tier: Good history
- Occupation (SOC): Software Developers (15-1252)
- Employer's certified LCAs for this occupation in CA, FY2024–FY2026: 6
- …in the whole US: 15
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $135k / $162k
- Staffing / consulting firm: Staffing / employment-services firm; 93% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
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.
Additional Information

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
