Hi, I hope you are doing great. Please find the below our *direct client requirement* and please send me your consultants resume to *p...@aptude.com <vku...@aptude.com>*
*Title: Sr. Oracle PL/SQL Developer with strong datawarehousing skillsLocation: San Francisco, CADuration: Long Term Contract* *Need Only Locals* Description: BI Developer Business Intelligence Developer for Advanced Analytics Overall theme. Provides development leadership and expertise. Guide and move forward an advanced BI/Data Mart system providing sophisticated and measurable business benefits. Entails driving data, ETL and system architecture and development and managing the work of supporting offshore developers. Duties: Ensure the data refresh from various sources is happening at regular intervals Support a group of multi-disciplinary data professionals and analysts. Drive development (coding using PL/SQL, Perl or any other scripting language, ad-hoc queries using SQL) Ensure that the data infrastructure can scale to meet defined performance, load, and functional objectives. Manage execution of parallel projects of varying scope and duration. Responsible for all database objects including tables, indices, triggers, views, sequences, packages, and procedures. Works with Systems and Database Administration for infrastructure needs related to support, storage, backups, monitoring, performance bottlenecks. Participate with applications development and quality assurance in the management of application releases. Advise senior management on "best practices" concerning web analytics, data warehousing, data architecture, and data development. Work with business intelligence and other source system owners to build data refresh plan for research environment. Own web click stream data collection and support GID product manager to implement best practices for data definition. Mentor and develop supervised professionals. Support project management and documentation needs of the group. Must Have: 5+ years experience with Oracle 8i, 9i and 10g including PL/SQL, SQL loader, external tables, partitioning and performance tuning. Strong knowledge of Oracle data structures, data dictionary, and RDBMS structures. 2+ years experience as data architect and/or DW/BI architecture. Experience in database design and administration, strong in performance tuning, software installation, scripting, PL/SQL coding, backup & recovery process. At least 2 medium to large scale DW/BI project implementation experience. Experience working with DW/BI environment to be able understand the concepts of STAR, data cleansing, transformation and aggregations. 4+ years, current, development experience and inclination towards development. 1+ years experience with web analytics products like web trends, NetTracker, Omniture etc. Experience in an environment that has come across customer integration issues or addressed it using MDM. Ability to express business and technical concepts clearly and concisely verbally and in writing. 5+ years overall direct personnel Management experience including coaching, performance review, conflict resolution, disciplinary actions and career development. Stay current with developments within the internet world, related web analytics & data management. Experience in a team-oriented, collaborative environment. Good to Have: Experience with various business apps like campaign management, CRM, ERP. Experience with Java scripts or other web front end scripting. Experience with column oriented database solutions such as HBase or Infobright. Experience with Hadoop. Oracle database administration experience. Experience with various data reporting tools like Business Objects, MicroStrategy, COGNOS. Experience with ETL tools like Data Stage, Informatica, Hummingbird. Experience with meta data management. Experience with SAS. 10+ years experience in Business Intelligence. Senior PL/SQL engineer to design and develop data transformation objects - objects include PL/SQL scripts, functions and procedures. As the end system that consumes these processes is a DWH, candidate needs to have solid understanding of Dimensional Modeling and Star Schema principles. Any experience with retail industry and experience with Datastage or Informatica is preferred. * Thanks & Regards Prasad Rao Aptude Inc. 630-883-4515 Ext: 402 p...@aptude.com <vku...@aptude.com> Gtalk ID: prasadparadigminfotech Yahoo ID: recruiter0...@yahoo.com <recruiter0...@yahoo.com> * -- You received this message because you are subscribed to the Google Groups "IT Auditor Resumes" group. To unsubscribe from this group and stop receiving emails from it, send an email to itresumes+unsubscr...@googlegroups.com. To post to this group, send email to itresu...@googlegroups.com. Visit this group at http://groups.google.com/group/itresumes. For more options, visit https://groups.google.com/d/optout.