> > Hi, > > Hope doing great…!!! > > I have an urgent requirement below, please go through it and share your > updated profile ASAP at *a > <[email protected]>[email protected] > <[email protected]>* >
Location: Wilmington, DE Length: 1 year with the option to extend (people are here for years ) Interview process: Phone and if not local will do Skype Position: ETL/ PL SQL Developers Numbers of openings : 3 Notes: Read the job description. Here is what is needed. Advanced PL/SQL Skill s in a ETL Environment. NO TOOLS experience. They do have Datastage but they are a unique environment as they use PL/SQL as their ETL Tool. So people with Datastage don’t have the advanced PL/SQL Skills. Good Unix scripting experience. Large environment prefers exposure to 1 million records or more *This manager wants to do phone interviews tomorrow and Friday !!!!!!!!!!!* § 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 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 > > *Amith Singh* > *Sr. Recruitment Manager* > > *Zenith tech Solutions* > > *Desk: **518-621-004* <518-621-0048>*6* > *Fax: **518-244-4977* <518-244-4977> > *3 park Hill* > > *Albany, NY 12204* > *[email protected] <[email protected]>* > -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" 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/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.
