Hello,
*Please send Resume to **[email protected] <[email protected]>* I am working with a Health Care Client in Palo Alto, CA who is looking for a PL/SQL Developer. Interviews will be telephone to start. Local candidates Only!!! Job Description · Experience in Designing and Development of *OLAP and OLTP* applications and experience in building Interface/conversion/data migration in client/server *OLAP* environment · Thorough understanding of Normalization and De-normalization concepts and hands on experience in designing *Normalized *Databases and *De-normalized* Databases for transactional systems and analytical systems · Having work experience on Oracle reports, XML/BI Publisher, Forms · Good Experience on WorkFlows, Oracle Application Framework. · Proficient working in *Oracle 11g/10g/9i/8i* databases using *SQL & PL/SQL* (Stored Procedures, Functions, Packages and Triggers) · Document *data flow diagrams, Process flow, Business Impact and technical designs* for reference and maintenance · Implemented member reservations for spaces at cove in the mobile website using *parse JavaScript API*. · Implemented many emerging web technologies including *JavaScript to** allow for a data driven application* using a web interface · Partnered with the Software Development Manager in creation of an in-house *unit-testing framework* leveraging the *QUnit JavaScript Library.* · In-depth Knowledge of Schema Objects (Tables, Global Temporary Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database links) and Bulk collects/Inserts, CURSORS/ REF CURSORS, Analytical functions, Dynamic SQL, Exception Handling, Type. · Extract, Transform and Load legacy data into Data warehouse and develop analytical SQL queries to generate reports using data in Data warehouse and Data marts · Expert in *Performance Tuning* using *Oracle Hints*, *Explain plan* , *TKPROF*, *Partitioning.* · Experience in* Migrating Code* to different Environments from SQL Plus interface. · Good experience in Data Warehousing this includes *data analysis, data manipulation, and programming, testing, implementation and report generation* · Knowledge of *Job scheduling tools(Autosys,D-series,CRON)* to create, modify, troubleshoot jobs, schedule and automate daily/weekly/monthly/quarterly jobs · Hands on experience in using *UNIX* and *Shell* *commands, Shell scripts* to create jobs, automate processes, moving processes to background and monitoring processes. · Very good working knowledge in *ERWIN, TOAD, PL/SQL Developer tools.* *Best Regards* *Ankit Kumar Sagwal* *IDC Technologies Inc.* *E-Mail: [email protected] <[email protected]>* *408-457-9381 Ext:4030* *Gtalk: ankit121.rgtalent* *1851 McCarthy Boulevard, Suite 116, Milpitas, CA, USA, 95035* "Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail can not be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail with REMOVE in the subject and we will gladly REMOVE you from our mailing list." -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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 http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
