*EAD GC/GC/USC and face to face *
*Location:*:: *CA-California/Torrance Duration::: 6+ months MOI::: Phone then face to face * *Job 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 *Required Skills: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 *Data transformation (ETL)::*•Knowledge of Informatica is a plus •Familiarity with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of data •Strong ETL design and development abilities •PL-SQL and Stored Procedures to upload data from different sources *Unix OS::*•Experience working with Unix servers •Experience with Shell scripting *Database/Other::*•Experience in the analysis, design, development, deployment & tuning of large scale databases •Experience in the design and development of data warehousing •Expert knowledge of SQL •Ability to write and understand complex SQL required •Query analysis and tuning experience (hints, explain plan, TKPROF) •Expert knowledge of Oracle PL/SQL best practices and development methodologies or standards •Stored Procedures, Packages, Triggers, Debugging, Tuning •Data modeling Experience a plus •Data Warehousing experience a plus •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 *Desired Skills:: *•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 *Regards, Rashmi Singh(Technical Resource Specialist)Ramy Infotech IncPhone: 408-317-9256 Ext-334 Fax : 408-273-6834Email: rashmi.si...@ramyinfotech.com <rashmi.si...@ramyinfotech.com>Note: We are working with prime vendor (One Layer between) for this position. * -- You received this message because you are subscribed to the Google Groups "Business_Intelligence" group. To unsubscribe from this group and stop receiving emails from it, send an email to business_intelligence+unsubscr...@googlegroups.com. To post to this group, send email to business_intelligence@googlegroups.com. Visit this group at https://groups.google.com/group/business_intelligence. For more options, visit https://groups.google.com/d/optout.
