# Informatica Developer — SonsoftInc

- Location: San Francisco, CA
- Posted: Apr 26, 2017
- Status: open (checked Nov 20, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/sonsoftinc/114513937
- Employer record: https://visajobs.io/company/sonsoft.md

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

## Description
Job Description
4+ year’s hands-on experience in development in Informatica 8.x and above.
Should have experience on at least two end to end full DW project life cycles.
Strong working knowledge of Data warehouse concepts, dimensional modeling, OLAP processing.
Must have a strong knowledge of system development, understanding of emerging technologies, and familiarity with current processes/methodologies
Experience in Auditing and Error handling framework for ETL architecture.
Experience in auditing and error handling frameworks using Informatica.
Experience with normalized designs and DataMart
Experience in performance tuning of Informatica mapping.
Experience in integrating ETL with third party tools.
Lead ETL design based on requirement gathered while working on cross functional project team.
Administer and developed Informatica workflows, mappings and sessions to load large data volumes from multiple sources into enterprise data warehouse.
Support ETL cycles including production issue and environment quality issue.
Prepare technical documentation of product sub systems.
Performance tune ETL code in a high volume environment.
Resolved data problem discovered by quality QA and developed solution to the problem.
Define/improve processes for development and support functions.
Ability to write and understand UNIX shell scripting, Perl.
Experience and desire to work in a Global delivery environment
Ability to work in team environment and client interfacing skills.
Must have strong Writing, Communication and Analytical Skills
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 within the Information Technologies.
Additional Information
Connect with me at https://www.linkedin.com/in/mir-hasham-ali/ (For Direct Clients Requirements)
** 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.
Note:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen , Green Card Holder & GC-EAD can apply.
No OPT-EAD, H1B, H4-EAD, L2-EAD & TN candidates, please.
Please mention your Visa Status in your email or resume .
** All your information will be kept confidential according to EEO guidelines.

> 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
