Informatica / PL/SQL Developer

Location: Torrance, CA, us

Company 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

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.