Informatica / PL/SQL Developer
- Location
- Torrance, CA · On-site
- Work authorization
- US citizens or permanent residents only
- Job type
- Full-time
- Level
- Senior
- Experience
- 7+ years
- Education
- Bachelor's degree
- Listed
- Yesterday
Skills & highlights for this role
- Informatica
- Oracle PL/SQL
- ETL performance tuning
- Unix shell scripting
- data warehousing
Also useful
- CRM analytics
- data modeling
- Oracle data partitioning
- auto industry knowledge
How well does your resume fit this job?
Upload your resume to see your score for this Sonsoft role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
- 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
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 & Requirements
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.
About the Company
Sonsoft, Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
From Sonsoft's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Informatica / PL/SQL Developer role at Sonsoft, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Similar roles
All Database Developer jobs- Application Developer-RDBMSIBM · Paramus
- Data & AI Internship Program (She/He/They)Accenture · United States
- Supply Chain Management (JDA Manugistics)TestingXperts · Westchester, IL
- PeopleSoft DeveloperComtech · Arlington, VA
- Senior DataBase developerSensiple · Culver City, CA
- Sr database developer - Must have worked on teradata & DB2 ( Corp to Corp ) - 3 Positionssystem canada technologies · New York, NY
Common questions
Where is the Informatica / PL/SQL Developer job at Sonsoft located?
This Informatica / PL/SQL Developer position at Sonsoft is located in Torrance, CA (On-site). Always check Sonsoft's application page for specific state eligibility or relocation policies.
What qualifications are required for Informatica / PL/SQL Developer at Sonsoft?
For the Informatica / PL/SQL Developer role, Sonsoft highlights 7+ years of relevant experience; a bachelor's degree; experience with Informatica, Oracle PL/SQL, ETL performance tuning, Unix shell scripting, data warehousing. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Informatica / PL/SQL Developer position at Sonsoft?
This listing links directly to Sonsoft's SmartRecruiters application page. You can apply directly on Sonsoft's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.