Sonsoft Inc
Informatica / PL/SQL Developer
Sonsoft Inc, Torrance, California, United States, 90504
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 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
.
#J-18808-Ljbffr
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 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
or
resume
.
#J-18808-Ljbffr