# Informatica / PL/SQL Developer — SonsoftInc

- Location: Torrance, CA
- Posted: Mar 3, 2017
- Status: open (checked Nov 19, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/sonsoftinc/109863776
- Employer record: https://visajobs.io/company/sonsoft.md

## Sponsorship history
- Tier: Employer history only
- With this exact title: 0
- Staffing / consulting firm: 100% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
Job Description
Job Description:
· Seeking an experienced Senior Developer who specializes in Informatica, Oracle database and PL-SQL / Data warehouses / Unix servers and shell scripting.
· Ability to design solutions and conduct data analysis is required.
· Auto industry, CRM and knowledge of marketing concepts are pluses.
Responsibilities
· The position will be supporting a custom CRM application, specifically the analytical repository. The repository is an Oracle database, the OS is Unix AIX 6.x.
· The responsibilities for the position include the analysis, design, development and 24/7 support of the production processes and applications.
· The candidate will work under the supervision of the ECRM team lead.
· Will be part of a team responsible for supporting CRM analytics and Campaign operations.
Musts
· BA/BS in Computer Science or equivalent training
Business Experience:-
Data transformation with Mandatory 7+ years of Experience:-
· Outstanding Informatica design and development abilities.
· Experience in ETL performance tuning/optimization.
· Experience working with complex Informatica transformations.
· Strong experience identifying, researching, and resolving ETL issues and producing root cause analysis documentation.
· Experience writing ETL specifications.
· Experience developing complex ETL mappings.
· Experience with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of data.
· Experience with versioned repositories and configuration management.
· Identifies areas of improvement.
Oracle Database with Mandatory 7+ years of Experience:-
· Understanding of Oracle PL/SQL techniques to write stored procedures, triggers and packages that analyze several million rows across several database tables.
· Ability to grasp relational data models quickly and program using SQL and PL/SQL.
· Clear understanding of SQL’s analytical processing capabilities
· Understanding of Oracle dynamic SQL and ability to write complex procedures using dynamic SQL.
· Familiarity with Oracle Data Partitioning techniques to manage, support and performance tune very large databases (VLDB’s)
· Understanding of Parallel execution features of Oracle to dramatically reduce response times for data intensive operations.
· Ability to write efficient PL-SQL procedures.
· Design complete solutions.
Database / Other with Mandatory 5+ Years of Experience:-
· Experience in the analysis, design, development & deployment of large scale databases.
· Experience in the design and development of data warehousing is a plus.
· Ability to write and understand complex SQL required.
· Knowledge of Oracle PL/SQL best practices and development methodologies or standards - Stored
· Procedures, Packages, Triggers, Debugging, Tuning.
· Data modeling Experience a plus.
· Data warehousing experience a plus.
Unix OS with Mandatory 5+ years of Experience
· Experience working with Unix servers.
· Experience with Shell scripting.
Qualifications and Experience:
· Bachelor's degree in computer science or related discipline or have equivalent experience.
· Strong ETL design and development abilities, PL-SQL and Stored Procedures to upload data
· from different sources.
· Knowledge of the auto industry and CRM.
Qualifications
Personal Initiative:-
· Motivated self starter.
· Ability to work in a fast paced environment.
· Ability to work in a team environment where team conducts code and design reviews prior to implementation.
· Ability to lead minor tasks and follow up on progress specially if depending on others to do their tasks.
Communication:-
· Proven written and oral abilities.
· Positive and friendly personality.
Additional Information
Note:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen , Green Card Holder , GC-EAD , H4-EAD & L2-EAD can apply.
No OPT-EAD, H1B & TN candidates please.
Please mention your Visa Status in your email or resume .

> 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
