Please respond to [email protected]
Data Warehouse Architect With Oracle & DB2 Kansas City, MO Duration: 6 Months Summary: This position is responsible for defining and driving information and data warehousing strategies. The architect will also work closely with enterprise architects to align data warehousing strategies with enterprise strategies including conceptual and logical data models. Position will champion data, information, and data warehousing within the organization including education and open communication with business partners and data stakeholders within the enterprise. Major Responsibilities: * Develop and define the future state using visualization maps and tools that facilitate an understanding of the processes, applications, data and physical layers * Create and drive actionable strategies for achieving the future state * Align strategies with business direction and initiatives * Align strategies with enterprise/infrastructure architecture * Act as an advocate for ensuring that the data warehouse database design aligns with the overall enterprise architecture goals. * Set strategic direction for information and data warehousing tools and best practices that support Information Architecture, data profiling, data quality management and metadata management. * Work across project teams to ensure the future state is well understood and that the project teams are aligned * Identify and define critical elements, including how they should be implemented, shared, and used, as well as how to optimize data quality. * Analyze and interpret requirements to design and model appropriate dimensions * Assisting in the ongoing support of the data warehouse development and environment o Optimizing design/refactoring o Analysis and tuning of data warehouse databases and queries * Supplying data warehousing conceptual and logical design consultation attribute specification, and data mapping services. * Providing logical data warehouse database design and coordination with database analysts during the conversion to physical implementation. * Writing SQL queries to understand existing tables and their contents. * Assist developers to write and optimize SQL for use in applications. Qualifications: * Solid leadership experience in large cross-functional teams and the flexibility to influence people at a variety of levels * Strong written and verbal communications * Demonstrated competencies critical to success: Conceptualization, foresight, enterprise perspective, consensus building, leadership, and communication * Minimum of 7 years of large system design and implementation * Experience with robust, operationally sound production environments is a must. * Experience with data design, performance tuning and administration for relational and multi-dimensional data base is a must. * Solid experience with dimensional modeling * Knowledge of software project lifecycle is a must * Experience with change management procedures is a must. * Knowledge of architectures, such as SOA, MDA, EDA and OOP * Demonstrated ability to investigate and learn new technologies and products is a must * Strong understanding of distributed environments * Data warehousing experience with Oracle environment required * DBA experience with Oracle environment required * Experience with DB2 in z/OS environment preferred. Additional experience in a Unix UDB environment is a plus!! * Experience using ER/Studio, or similar data modeling tool. * Experience using Relational Integrity constraints. * Experience reverse-engineering existing tables into a data model. * Experience with physical aspects of data modeling, such as making denormalization decisions and adding performance indexes. * Basic understanding of security mechanisms used in DB2 for z/OS * Ability to prioritize multiple assignments for multiple projects Education Experience: * Minimum of 7-10 years related experience * Bachelor of Science or equivalent work experience Regards, John || Office: 916 646 2080 Ext: 212 || Fax: 916 646 2081 || Email: [email protected] || Website: <http://www.key-soft.com> www.key-soft.com || Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list. -- Introduce business in 3800 cities. How? ===================================================== Thanks for using group. Moderator 1) This group is managed by www.BRCIndex.blogspot.com 2) Post your message with your linkedin Profile (Visit linkedin.com) to confirm your identity and refer business. 3) Visit www.BRCIndex.blogspot.com (3800 Business Referral Club) 4) Reply to two message before posting new one. 5) Donot post same message in all 3800 business Referral Club. You received this message because you are subscribed to the Google Groups "Outsource" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Outsource
<<image001.jpg>>
