Hi, Please check and let me know. 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. -- 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.
