Dear Partners,
I have one urgent opening of *Oracle Database Developer **at **New York City, NY*. If you have any consultant available with you then please let me know ASAP…** *Candidate must possess all the skills…..* *Title: Oracle Database Developer * * * *Location: New York City, NY* * * *Duration: 6+ Months* *Overall Responsibilities:* This is a band 3 database developer role in the application architecture and development job family. Main responsibilities include database and ETL development as well as production support for DART, a data warehouse that consists of an Oracle 10g RAC implementation, Unix-based batch and intraday job streams that source data from various systems, a custom middleware written in .NET C# that enables ad hoc user queries, and several Excel-based and web-based front-end applications. *Functional Responsibilities:* Feed analysis – Interact with business users and source system IT teams to define, agree, and document incoming data feed specifications. Data modeling – Interact with business users and middleware team to conform data sources into facts and dimensions of the star-schema data model. Conduct peer design reviews. ETL design – Design processes that transform and load data sources into fact and dimension tables according to best practices. Conduct peer design reviews. Development – Implement database objects and ETL programs according to design and coding standards. Conduct peer code reviews. Testing – Plan, execute, and document testing of database objects and ETL programs. User Support – Interact with end users in a support role to fulfill requests or resolve issues. Production Support – Provide off-hour and weekend support of application batch processes on a rotational, on-call basis. *Required Skills:** **Oracle 10g PL/SQL programming** UNIX** shell programming** Database**indexing and partitioning best practices ** Multi**-terabyte data warehousing** Type** 2 Slowly Changing Dimensions**SQL ** query plan analysis** * *Desired Skills:* TKPROF analysis Near Real Time ETL Active / Volatile Data Warehousing WORK EXPERIENCE/BACKGROUND: Experience/Background *5 to 8 years of application development experience, preferably in a large corporation with a demonstrated ability to navigate large, complex organizations to get work done.* EDUCATION/CERTIFICATION AND PROFESSIONAL QUALIFICATIONS: College degree in computer science or comparable quantitative field such as engineering, math, or science. *Thanks & Regards* *Amber Srivastava* *Sr. Sourcing Specialist* iBusiness Solution LLC (Certified 8(a), MBE, WBE Business in PA, MD,VA & NJ) 5000 Lenker Street Mechanicsburg, PA 15241 Phone: 717-704-0062 Fax: 412-202-8931 Email: *ambe...@ibusinesssolution.com<blocked::mailto:a...@ibusinesssolution.com> **; amber.ibusinesssolut...@gmail.com* Visit us at www.ibusinesssolution.com Yahoo! IM: a_amber2007 -- Subscription settings: http://groups.google.com/group/tek-professionals/subscribe?hl=en