*Hello,* *GREETINGS !!*
*This is Neha from Apetan consulting,* *Please find the below job description and send me your update resume matching to it along with Contact details, Current location, Visa and Availability ASAP.* *POSITION: Oracle (PL-SQL) Developer* * INTERVIEW: Phone than F2F Interview* *LOCATION: Torrance, California* *DURATION:3 MONTHS+* *START :ASAP* *Job Overview:* · 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. Thanks, *Neha Kumari |* *Technical Recruiter* | *Apetan Consulting LLC* Tel:201-620-9700* 106 | Fax: 201-526-6869 |Email:[email protected] *Mail *: 72 van reipen ave pmb#255, Jersey City, NJ 07306 | *Corp. Office:* 15 Union Avenue, office # 6, Rutherford, New Jersey 07070 | -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/android-developers. To view this discussion on the web visit https://groups.google.com/d/msgid/android-developers/CAOMeN-su_v1uKJxb1qhO3zZD_GKNBwk1asu34VHsyXHtpTBJ7g%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.

