*Send resume and Hot lists to abhishek.khur...@pyramidci.com <abhishek.khur...@pyramidci.com> *
*Title: ETL / Data Warehouse Architect* *Location: Sunnyvale, CA* *Duration: 6+ Months* *Job Description:* - Bachelor’s Degree in Computer Science, Management Information Systems or related field or equivalent knowledge. - Seven (7) plus years of experience in data warehousing, data management, ETL processes and data modeling tools , required with experience in pentaho preferred. - Seven (7) plus years of experience in database and interface design, data integration, conversion processes and optimization, preferred. - Hands-on experience with all aspects of designing, developing, testing and implementing ETL solutions. - Experience in extracting data from Oracle EBS/ERP is mandatory. - Ability to learn and implement new and/or different techniques. - Strong technologist with excellent ability to analyze various reporting platforms & identify the right platform for the Data Integration *Responsibilities:* - Create conceptual, logical and physical data models and determines the most appropriate method to represent the data for business consumption. This includes all forms of physical representation of data, such as relational, dimensional, object, key-value (such as column families) - Design & Develop basic and advanced transformation activities such as normalization, cleansing, aggregation, summarization, and integration; designs automation processes to control data access, transformation and movement; ensures source system data availability and update accessibility, data integrity, restorability and appropriately handles errors, in a time sensitive manner. - Develop testing strategies, including test script formulation and execution, used to validate the accuracy and results of ETL solutions; participation and contribution in quality assurance walk-throughs of ETL components. - Understanding supported business processes, and engage business areas using advanced/expert understanding of business requirements for translation into feasible process. - Develop and document the systems, processes and logic required to expose the existing data sets in the warehouse to end users for reporting and analysis purposes. - Manage multiple broader efforts that span multiple projects/initiatives. Prioritize and monitor project/task status and risk management/mitigation, by working with appropriate manager on level of effort/estimates, resource assignments, etc. - Adhere to standard SDLC procedures and ensure the creation of appropriate documentation. - Ensure adherence to Change Control and release management procedures, including generation of appropriate packages, documentation, and coordination with other technical areas *Abhishek Khurana* *Pyramid Consulting, Inc.* ------------------------------ *Desk Phone: **650-276-7743* *Email: * *abhishek.khur...@pyramidci.com* <abhishek.khur...@pyramidci.com> *Web: **http://www.pyramidci.com/staffing-home* <http://www.pyramidci.com/staffing-home> *WE FIND HIDDEN TALENT * -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at https://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
