Informatica / PL/SQL Developer

Sonsoft Inc; Torrance (CA); On-site; USD 100,000 - 120,000; Full time

Job summary

A growing tech company in Torrance, California is seeking a Senior Developer with expertise in Informatica, Oracle database, and PL-SQL. The role involves supporting a custom CRM application and requires strong ETL skills alongside a minimum of 7 years of relevant experience. Candidates must have a Bachelor's degree in Computer Science and excellent communication skills. This is a full-time and permanent position, open only to U.S. citizens and certain visa holders.

Qualifications

• 7+ years of Informatica design and development experience.
• Strong ETL performance tuning/optimization skills.
• Ability to write and understand complex SQL.

Responsibilities

• Support a custom CRM application and analytical repository in Oracle database.
• Conduct analysis, design, development, and support for production processes.
• Contribute to CRM analytics and campaign operations under team lead supervision.

Skills

Informatica

Oracle database

PL-SQL

Unix servers

Shell scripting

Education

Bachelor's degree in Computer Science or equivalent

Job description

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.

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