A new Job, ID: 187245 <http://ejobsville.com/display-job/187245> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://ejobsville.com>
Title: Oracle PL/SQL /ETL Datastage Developers posted on 2014-06-11 13:33:51 Job Description: · Involve in load data from File to Stage and different layers like *Source, ODS, ADS and DMA* and finally to main legacy data warehouse to support different lines of business · Involved in database development by creating *Oracle PL/SQL Packages, Stored Procedures, Functions and Database Triggers* · Rewrite lot of applications code to improve the performance of the query · Extensive Knowledge and working of *Bulk Collect* for *data retrieval and data loading* · Create and maintain *Shell scripts to run Oracle Stored Procedures and Packages* · Use *TOAD *for *database design, changes, generate new queries, format and tune the SQL* · Work with Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources. · Involved in writing complex queries to generate ad-hoc reports as per client request as a part of production support · Extensively use the advanced features of *PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL* · Involve in *Tuning, Performance, Optimization of queries and standardization of the code* · Involve in designing the logical and physical model of database objects using Toad · Extensively use PL/SQL tables, cursors and exception handling · Use Ref cursors PL/SQL packages · Create database links to access data from remote databases. · Involved in conversion of data from one platform to another platform · Create high level detailed design documents. Involved in Gathered Requirements *Technical Documentation, Unit testing and Integration Testing* · Must have experience with ETL tools and should use *datastage*. His team does a lot of the ETL processes using the classic approach via PL/SQL rather than just using the tools based on the complexity and size of many of the systems. *Please feel free to contact me if you have any queries!* Salary: DOE *Click here to view full job description and apply <http://ejobsville.com/display-job/187245> (Registration not mandatory to apply for this job)* ------------------------------ Best regards, eJobsVille.com - For The Best Tech Jobs In Town -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.