PL/SQL Developer (Torrance)

Company DescriptionSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.Job DescriptionJob Description:Seeking an experienced Senior Developer who specializes in Oracle database and PL-SQL / Data warehouses / Unix servers and shell scriptingAbility to design solutions and conduct data analysis is requiredInformatica knowledge is a plusAuto industry, CRM and knowledge of marketing concepts are plusesResponsibilities:The position will be supporting a custom CRM application, specifically the analytical repositoryThe repository is an Oracle database, the OS is Unix AIX 6.xThe responsibilities for the position include the analysis, design, development and 24/7 support of the production processes and applicationsThe candidate will work under the supervision of the ECRM team leadWill be part of a team responsible for supporting CRM analytics and Campaign operationsRequired Skills:Oracle DatabaseStrong understanding of Oracle PL/SQL techniques to write stored procedures, triggers and packages that analyze several million rows across several database tablesAbility to grasp relational data models quickly and program using SQL and PL/SQLClear 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 SQLPerformance tuning methodologies and understanding of Relational database join techniques like HASH, NESTED LOOPS etc. and the use of Oracle HintsAdvanced knowledge of Oracle Indexing techniques like BIT Map indexes and Index Organized tablesOptimize and tune stored procedures, embedded SQL, taking advantage of Oracle specific featuresOracle 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 operationsBulk Collect functionality, pipelined functions and other features of Oracle PL/SQLAbility to write efficient PL-SQL proceduresDesign complete solutionsData transformation (ETL)Knowledge of Informatica is a plusFamiliarity with Extraction, Transformation and Loading (ETL tools) to facilitate loading large amounts of dataStrong ETL design and development abilitiesPL-SQL and Stored Procedures to upload data from different sourcesUnix OSExperience working with Unix serversExperience with Shell scriptingDatabase/OtherExperience in the analysis, design, development, deployment & tuning of large scale databasesExperience in the design and development of data warehousingExpert knowledge of SQLAbility to write and understand complex SQL requiredQuery analysis and tuning experience (hints, explain plan, TKPROF)Expert knowledge of Oracle PL/SQL best practices and development methodologies or standardsStored Procedures, Packages, Triggers, Debugging, TuningData modeling Experience a plusData Warehousing experience a plusBachelor's degree in Computer Science or related discipline or have equivalent experienceBusiness Experience5 plus years experience with major DBMS5 plus years experience with coding, testing, and design5 plus years experience with software development methodologiesQualificationsDesired Skills:Motivated self starterAbility to work in a fast paced environmentAbility to work in a team environment where team conducts code and design reviews prior to implementationAbility to lead minor tasks and follow up on progress specially if depending on others to do their tasksAdditional InformationNote:-This is a Full-Time & Permanent job opportunity for you.Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.No OPT-EAD, H1B & TN candidates please.Please mention your Visa Status in your email or resume.SummaryType: Full-timeFunction: Information TechnologyExperience level: AssociateIndustry: Information Technology And Services