Hi, Please check and let me know.
* Position: Oracle (PL-SQL) Developer Location: Torrance, California Interview: Phone & Face to face* *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. -- Best Regards Mohit Arora [email protected] *201-620-9700* ** 152 * -- You received this message because you are subscribed to the Google Groups "Vendors" 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/vendors. For more options, visit https://groups.google.com/d/optout.
