Hi
This is Vignesh from AurionPro Solutions Leading Global IT Consulting Services.
We've Urgent requirement with one of our client for Data Modeler – Job opening Location Vacaville, CA
Position Title: Data Modeler
Work Location : Vacaville, CA
Duration : 6 months
Job Description:
The Data Modeler is responsible for designing and enhancing conceptual, logical and physical, dimensional and semantic data models for DB2 and Oracle operational, decision support and data warehouse databases. The architect works closely with business users on resolving all data related business rules, open database design, data integration and related technical issues. The day to day tasks and responsibilities for Data Modeler Consultant include, but are not limited to the following:
•Review current state activities to include the review of the goals and objectives of the Information Management group within State Fund, the oversight responsibilities, and strategic involvement recommendations.
•Assist in the creation of an enterprise operational data store and analytical data warehouse
•Review of existing reporting and analytics tools for potential reduction in technology footprint
•Provide expert enterprise data models to facilitate the construction of various data management systems such as MDM, ODS, Data Warehouse and Data Marts.
•Create an extensible conceptual, logical and physical data models with a full lifecycle management of capturing, versioning and migrating various metadata across environments using ERwin and/or ER/Studio Platforms.
•Create normalized, dimensional and data vault models for DB2 and Oracle Database Platforms by establishing standards, guidelines and best practices.
•As needed, reverse engineer the existing systems and analyzing the data to extract hidden business semantics and structures.
•Create advanced SQL and stored procedures and design solutions for optimal transactional as well as analytical performance in DB2 and/or Oracle Database Platforms.
•Work with various application development teams to provide data integration architecture services and data modeling services
•Support mainframe and Oracle development teams to organize different phases of project testing and participate in the test result verification to insure data related business rules compliance
•Perform metadata analysis and normalized logical data model as the result of merging user perspectives, or integrating a user perspective into an existing data model
•Develop physical data model as the result of translating the scoped part of the logical model in a structure of DBMS objects for a transactional or data warehouse database.
•Develop dimensional data model as the result of denormalizing and dimensioning for a data mart.
•Insure the approved DRWs (Data Request Worksheet) are implemented correctly.
•Data architecture support for the data structure and data contents of the Universal database
•Support all new projects with designing new data schemas and proposing enhancements of existing data schemas
•Assist in the development of methodologies, conventions, and best practices for data architecture as required.
•Assist in the development of an enterprise data model.
•Create and maintain Data architecture standards and procedures including DRW procedures, UDR procedures and naming standards.
•Act as primary or back-up for data architecture support of any of the databases that State Fund can enhance internally, as required
•Provide peer review for data model and database design changes done by other data architects.
•Support for modeling tools including Model Manager Administration, ERwin or ERStudio use, install, upgrade and technical support.
•Support automated reference table population from validation rules, and automated audit trigger generation using Macro scripts
•Design and support complex DB2 and Oracle data models.
•Share knowledge and mentor other team members/staff.
Resource Skills, Knowledge & Abilities:
Consultant shall ensure that all resources assigned to the project have the education, training and experience necessary to render the services in a competent and efficient manner. Experience, Knowledge Level, and Technical Skills The expert data modeler will have a proven record of accomplishment in designing and developing data models in DB2 and Oracle environments. The Consultant Resource should possess a strong analytical and technical background with strong background with data warehouse concepts and experience supporting development teams. The Consultant resource shall possess most of the following technical knowledge and experience:
•Extensive hands-on experience in modeling enterprise data models to facilitate the construction of various data management systems such as MDM, ODS, Data Warehouse and Data Marts.
•Strong experience in creating an extensible conceptual, logical and physical data models with a full lifecycle management of capturing, versioning and migrating various metadata across environments using ERWin and/or ER/Studio Platforms.
•Strong experience in creating normalized, dimensional and data vault models for DB2 and Oracle Database Platforms by establishing standards, guidelines and best practices.
•Extensive experience in reverse engineering the existing systems and analyzing the data to extract hidden business semantics and structures.
•Combined experience of advanced SQL and stored procedures with hands-on experience in designing solutions for optimal transactional as well as analytical performance in DB2 and/or Oracle Database Platforms.
•Work experience in Oracle Designer 6i is desirable.
•7+ years of hands-on Data Modeling experience.
•5+ years of experience in Data Architecture Methodology.
•7+ years of experience in Data Architecture Standards and Procedure development.
•5+ years of experience with mainframe DB2 environment.
•5+ years of experience in designing and developing Oracle Data Models.
•2+ years of experience using Microsoft Access for prototyping
•7+ years of hands-on experience with CA Technologies ERwin tool, including maintaining and developing macro scripts
•7+ years of experience in designing databases.
•3+ years of experience with TSO (SPUFI/QMF) and DB2 Connect.
•2+ years of experience with SQL PLUS / TOAD/ SQL Designer.
•Working knowledge of life cycle of software design and development.
•Excellent research, design, programming, testing, troubleshooting, and problem-solving skills.
•Ability to develop a product according to business requirements under tight timelines and rapidly changing priorities.
•Capable of performing reverse engineering for previously developed Oracle and DB2 data models.
•Experience in Workers' Compensation Insurance industry, especially in policy, premium billing and claims is a plus.
•Good communication skills and ability to interact with project teams and leads.
•Strong Project management knowledge and experience.
Thanks
Vignesh
Sr. Talent Acquisition
e mail: vignesh.renikuntla@aurionpro.com
Linkedin: http://www.linkedin.com/in/viggy1
Phone: 408-754-6161
Fax: 732 909 2221
IM Yahoo: eAcquisition
Google IM: eAcquisition1
AurionPro Solutions, Inc.
379 Thornall Street
2nd Floor Edison NJ 08837
--All Job Openings : http://groups.google.com/group/jobjunction/topics?hl=en
You received this message because you are subscribed to the Google
Groups "Job Junction" group.
Send us your resume to jobjunction.global@gmail.com, we will post you updated openings.
To post to this group, send email to jobjunction.global@gmail.com
To unsubscribe from this group, send email to jobjunction+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jobjunction?hl=en
No comments:
Post a Comment