*Dear Candidate,*
*We have an urgent opening for and I have sent you a job description please
go through it and let me know if you are comfortable with it and also send
me your consultant's updated. *
* Position: Oracle (PL-SQL) Developer Location: Torrance, California
Interview: Phone & Face to face*
*Duration : 3 month +*
* Description:*
· *Seeking an experienced Senior Developer who specializes in
Oracle database and PL-SQL / Data warehouses / Unix servers and shell
scripting.*
· *Ability to design solutions and conduct data analysis is
required.*
· *Informatica knowledge is a plus.*
· *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.*
*Requirements: *
*Oracle Database *
· *Strong 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 such as RANK, DENSE RANK etc. *
· *Strong understanding of Oracle dynamic SQL and ability to
write complex procedures using dynamic SQL. *
· *Performance tuning methodologies and understanding of Relational
database join techniques like HASH, NESTED LOOPS etc. and the use of Oracle
Hints. *
· *Advanced knowledge of Oracle Indexing techniques like BIT
Map indexes and Index Organized tables. *
· *Optimize and tune stored procedures, embedded SQL, taking
advantage of Oracle specific features *
· *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. *
· *Bulk Collect functionality, pipelined functions and other
features of Oracle PL/SQL. *
· *Ability to write efficient
PL-SQL procedures. *
· *Design complete solutions. *
· *Knowledge of Informatica is a plus. *
· *Familiarity with Extraction, Transformation and Loading (ETL
tools) facilitate loading large amounts of data.
*
· *Bachelor's degree in Computer Science or related discipline or
have equivalent experience*
*Business Experience*
- *5 plus years’ experience with major DBMS*
- *5 plus years’ experience with coding, testing, and design*
- *5 plus years’ experience with software development methodologies*
*Wants*
- *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.*
[image: logo]
*Rohit Bhasin |* lead Recruiter | Apetan Consulting LLC
Tel: 201-620-9700* |121| Fax:2015266869 | *Mail *: 72 van reipen ave
pmb#255, Jersey City, NJ 07306|
*Corp. Office:* 15 Union Avenue, office # 6, Rutherford, New Jersey
07070|
ro...@apetan.com| www.apetan.com |
*“Forget all the reasons why it won’t work and believe the one reason it
will work**"*
[image: https://s3.amazonaws.com/images.wisestamp.com/icons/facebook.png]
<http://www.facebook.com/Apetanconsulting> [image:
https://s3.amazonaws.com/images.wisestamp.com/icons/linkedin.png]
<http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home>
[image:
https://s3.amazonaws.com/images.wisestamp.com/icons/twitter.png]
<http://twitter.com/ApetanLLC> [image: e verify]
*Disclaimer:* We respect your Online Privacy. This e-mail message,
including any attachments, is for the sole use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message. If you are not interested in receiving
our e-mails then please reply with a "REMOVE" in the subject line at
rem...@apetan.com and mention all the e-mail addresses to be removed with
any e-mail addresses, which might be diverting the e mails to you. We are
sorry for the inconvenience.
--
You received this message because you are subscribed to the Google Groups "SAP
ABAP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sap-abap+unsubscr...@googlegroups.com.
To post to this group, send email to sap-abap@googlegroups.com.
Visit this group at https://groups.google.com/group/sap-abap.
For more options, visit https://groups.google.com/d/optout.
