Hi
*Title: *Data Warehouse Architect *Location: *Richmond ,VA *Duration: 4 *Months + *Start Date*: Immediate *Positions:* 1 Send me Resumes to *rak...@sageitinc.com* *Job description:-* Designs, implements and supports data warehousing. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse. · Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning. · Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models. · Development experience in implementation of data warehousing utilizing RDBMS. · Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies. · Expertise in SQL and proficiency in database tuning techniques. Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments. Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment. · Responsible for proper selection of appropriate hardware, software, tools and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools. · Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality. Setting or enforcing standards and overall architecture for data warehouse systems. Monitoring the data warehousing industry and assisting in establishing the organization's data warehousing strategy and section of strategic warehousing tools and techniques. Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals. Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture. · Very strong written and oral communication skills, including some presentation skills. *Skill Required / Desired Amount of Experience* Design (OLAP cubes, Star/Snowflake Schemas, Fact tables, RDBMS etc)Required4 Years Strong SQL, PL/SQL and Tuning Required 5 Years ETL (PL/SQL, DTS Packages, SSIS Packages) Required 5 Years Oracle 10g, SQL SERVER 2000 and above Required 4 Years Cognos Required 4 Years ODBC, File structures Required 4 Years Change Control procedures Required 4 Years Knowledge in Unix, Windows OS Highly desired 2 Years LogiXML Highly desired 2 Years Metadata concepts, tools and different data warehouse methodologies Required 5 Years Thanks & Regards, Rakesh.Puvvada *Sage IT, Inc. *Ph: 972-996-0650 X 326 Direct: 248-823-8747 Fax: 214-619-2034, URL*: *rak...@sageitinc.com | www.sageitinc.com Alt ID :recruiterra...@gmail.com| Follow our jobs on twitter! *[image: Twitter-Iconxsm]*<http://www.twitter.com/sageit> *Note:* If you have received this mail in error or prefer not to receive such emails in the future, please reply with *"REMOVE"* in the subject line and the email id(s) to be removed. All removal requests will be honoured ASAP. We sincerely apologize for any inconvenience caused -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To post to this group, send email to sap-workflow@googlegroups.com. To unsubscribe from this group, send email to sap-workflow+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sap-workflow?hl=en.