Send Resumes to *[email protected] <[email protected]>*
*PL/SQL - DATA VAULT* *Philadelphia, PA 12 months * FROM THE MANAGER I want stronger PL/SQL skills and would REALLY like to have someone who has done more ETL work in a Data Vault environment. These two were familiar with Data Vault, but more from a design perspective. I want someone who has written DV ETL. I realize that may be hard to find, but I’m going to try for a bit. If I have to come off that, I’ll still want *very* strong PL/SQL skills. Someone who knows what they are doing and can figure out what they don’t know. I need an Oracle PL/SQL developer who can figure out how existing processes work, change them to meet new requirements and document them. They may need to develop new processes as well. Would like to get someone with DataStage experience as we may start using that product in the next 6 months. Plus Data Vault and Agile. *Job Description & Responsibilities:* · Oracle data warehouse developer responsible for the technical design, development, and testing of extract, transform, and load (ETL) programs. · Responsible for working with data architect and business analysts to design/build data loading and conversion programs. · Responsible for unit and performance testing. · Member of a 5 person team, mostly located in Exton PA. · Most work will be new development; this is not a production support position. · Not a supervisor/manager role. Skills Required: · Practical Experience with Data Vault Modeling • Must be able to work well in a team environment. • Strong understanding of data warehouse concepts and architecture. Understanding of star/snowflake schema design; dimension and fact tables, etc. • Strong understanding of Oracle database architecture. • Strong understanding of PL/SQL and SQL. • Ability to deconstruct, modify, and document existing PL/SQL processes. • Understanding of data modeling and design including partitioning, indexing, constraints, materialized views and optimizer statistics. • Understanding of oracle database utilities such as data pump, sql*loader, and external tables. • Understanding of ETL design and development concepts, such as direct-path loading and parallel SQL. • Experience with IBM InfoSphere DataStage or other ETL tool Skills - nice to have • DataStage *Warm Regards,* *Achuth* *Vortalsoft Inc* 220 Davidson Ave Suite 3A Somerset, NJ 08873 Phone: 732-982-2942 *[email protected] <[email protected]>* URL:www.vortalsoft.com <www.vortalsoft.com> -- You received this message because you are subscribed to the Google Groups "IT provider" 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/it-provider. For more options, visit https://groups.google.com/d/optout.
