A new Job, ID: 184660 <http://ejobsville.com/display-job/184660> was added at eJobsVille.com - For the Best Tech Jobs in Town <http://ejobsville.com/>
Title: Oracle PL/SQL /ETL Developers posted on 2014-06-06 15:18:22 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* · ETL tools are a plus, but not a must.(They 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. · Must have Large Batch File Processing experience (prefers exposure to 1 million records or more). This is what they call DW Processing. He said the person needs to be able to develop a batch process from scratch as well as maintain the batch process in production – not a production support developer only. (ex. Questions: Have you done batch processing? How would you process a 1 mill record file Salary: DOE *Click here to view full job description and apply <http://ejobsville.com/display-job/184660> (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 "SAP ABAP" 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/sap-abap. For more options, visit https://groups.google.com/d/optout.
