Hi, I have an urgent requirement with one of my clients, details given below. If you find your self suitable for the position, please send me your latest updated resume along with contact details. Please include your employer details as well.
*Job Title* Enterprise Data Warehouse Architect/Engineer *Project Location* Austin, TX *Duration* 6 months /Contract *Skills Required and Job Description:* *MOI:-TELE+SKYPE* * Description:* All work products resulting from the project shall be considered “works made for hire” and are the property of UTAUSTIN. UTAUSTIN may include pre-selection requirements that potential vendors (and their Workers) submit to and satisfy criminal background checks as authorized by Texas law. UTAUSTIN will pay no fees for interviews or discussions, which occur during the process of selecting a Worker. This solicitation is for an *Enterprise Data Warehouse Architect *for Information Quest (*“IQ”*), the enterprise data warehouse team for UTAUSTIN. The Worker shall work with IQ's ETL (*“Extract, Transform, Load”*), Business Intelligence (*“BI”*) and infrastructure teams and UTAUSTIN’s Institutional Reporting unit’s technical staff. The Worker will liaise closely with business stakeholders to develop a target architecture, bridging strategy, developing dimensional models and reporting structures to support current and projected reporting and data requirements. The Worker will work collaboratively with the IQ and Institutional Reporting teams to create, manage, and modify logical and physical, online analytical processing (*“OLAP”*) data models using Kimball and related data modeling philosophies and techniques. The Worker will mentor other members of the team in Kimball OLAP techniques and best practices. The Worker will also work closely with database administrator(s) to establish and maintain highly resilient, scalable and high performance architecture when the data model is implemented physically on the target databases. The Worker will identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity. The Worker will take an organization-wide view of the business and its data, (e.g. maintain re-usable or enterprise data models) while providing detailed project-specific modeling and analysis support. Perform performance monitoring and query tuning as needed. Thoroughly document developed solutions and communicate knowledge to team to ensure continuity and maintainability. Organizationally, the Worker will be part of the IQ team. *Terms and Conditions: *Worker must pass a background check. *FORM C – WORKER REQUIREMENTS GRID SHEET* *Consultant must have the exact or more years of experience as required on form below: * *Minimum Requirements:* *Minimum Requirements: *Candidates that do not meet or exceed the *minimum* stated requirements (skills/experience) will not be considered for this opportunity. *Years *(*Required*, *leave no blanks*) *Years* Skills/Experience *Vendor Comments *(as applicable) 5 Experience architecting large scale enterprise data warehouse systems with increasing scope and responsibility using the Ralph Kimball data warehouse development methodology. 8 Experience designing, building and implementing dimensional OLAP data models and data marts from an enterprise perspective. 3 Experience mentoring other data modelers in the application of Ralph Kimball data warehousing OLAP techniques and methodologies. 5 Experience developing enterprise data warehouses using Agile iterative and incremental development methods. 8 Experience with online transactional processing (*“OLTP”*) data modeling (conceptual, logical and physical data model design) and metadata management. Experience designing tables and views for efficiency, flexibility, maintainability and performance. 8 Experience with ERwin, Embarcadero, or comparable data modeling tools. 8 Experience working with relational databases (*“RDBMS”*) such as Oracle, SQL Server, etc. 8 Professional experience working with Business Analysts and business users to model data requirements based on complex business needs across multiple information domains. 5 Experience with reporting/analysis tools such as IBM Cognos, Business Objects, Microstrategy, Tableau, etc. Strong Verbal and written communication skills. Strong Analytical and problem solving skills with ability to clearly articulate solution alternatives. Strong Attention to detail, seasoned judgment and experience to anticipate business needs. Strong Ability to embrace change, adapt to the unexpected, and focus energies, people, and solutions on practical and positive results. Degree Equivalent combination of relevant education and experience may be substituted as appropriate. *Preferences:* *Years *(Optional) *Years* Skill/Experience *Vendor Comments* (as applicable) 8 Experience architecting large scale enterprise data warehouse systems with increasing scope and responsibility using the Ralph Kimball data warehouse development methodology. 5 Experience validating enterprise architectures using recognized frameworks such as Zachman or TOGAF. 3 Experience building Master Data Management (*“MDM”*) solutions. 5 Experience with data modeling in an Oracle environment. 5 Experience with resolving data anomalies and conducting data integration analysis. 5 Experience creating dimensional data models and data marts with human resource, payroll and financial data. 3 Experience with data profiling techniques and tools. 3 Experience working in higher education. 3 Experience with ETL tools; especially IBM InfoSphere Information Server version 8.7 and higher. 3 Experience in writing and maintaining complex SQL and PL/SQL scripts. 1 Experience working with Workday ERP software. Thanks & Regards, *SOURABH KUMAR * Technical Resource Specialist *RG Talent Inc.* 39120 Argonaut way Suite # 157, Fremont CA 94538 Email : sour...@rgtalent.com <deepak.ku...@rgtalent.com> Hangout : sourabh.rgtal...@gmail.com <deepakkumar.rgtal...@gmail.com> -- You received this message because you are subscribed to the Google Groups "Oracle Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to oradev+unsubscr...@googlegroups.com. To post to this group, send email to oradev@googlegroups.com. Visit this group at https://groups.google.com/group/oradev. For more options, visit https://groups.google.com/d/optout.
