| Oracle Database Architect (12 plus years) at Oracle, Arizona, USA |
| Email: [email protected] |
| From: Abhijith, Sligosoft [email protected] Reply to: [email protected] Greetings from Sligo Software Solutions, Inc. !! SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government. We have an urgent requirement for Oracle Database Architect position with our client. Role: Oracle Database Architect Location: Menands, New York Duration: 30 Months Job ID: SLG - 19 - 9296 Client: NY State Description This Database Architect position is required to support the continued development and approval processes of business solutions in response to critical agency requirements for the development efforts for the NYWIC data mart. NYWIC will be NYS's new Electronic Benefits Transfer (EBT) system for WIC participants to receive benefits. The Data Mart will be used for reporting purposes. Duties The Database Architect will participate in a team approach to Work with SMEs, Business Analysts and Technology teams to understand the data requirements and the full attribute set for entities and dimensions. Convert business processes, domain specific knowledge, and information needs into a conceptual model. Convert conceptual models into logical models with detailed descriptions of entities and dimensions. Develop and maintain fully defined conceptual, logical, and physical dimensional data models to ensure the information models are capable of meeting end user and developer needs. Develop data models and data migration strategies utilizing sound concepts of data modelling including star schema, snowflake schema, etc. Model aggregation layers and specific star schemas as subject areas within a logical and physical model. Understand and meet referential data integrity requirements. Document decisions made in meetings and alternative solutions discussed. Schedule, facilitate, and record report development meetings as needed. Mandatory Requirements Experience (12+ Years) Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems. Requirements This is an 100% Onsite 84 Months Experience with developing and maintaining logical and physical dimensional data models, building data migration strategies utilizing sound concepts of data modelling including star schema, snowflake schema, etc. in a data warehouse/business intelligence environment. 84 Months Experience in a data modelling tool (e.g., Erwin). Experience with reviewing the data modelling of others for compliance and accepted standards of development. 84 Months Experience in relational data management disciplines and design and development experience using Oracle technologies. 84 Months Experience utilizing SQL programming for data analysis purposes in a data warehouse/business intelligence environment. 72 Months Experience with business intelligence tools (e.g., OBIEE 11G) involving data analytics. 72 Months Experience with designing, developing, and creating applications in health care business intelligence reporting solutions. 48 Months Attended and participated in information and requirements gathering sessions, including translating business requirements into data requirements. Bachelors degree in business intelligence, information science, computer science, or mathematics. Resume Please submit copy of certificate, degree. Keywords: information technology Idaho New York |
| [email protected] View all |
| Thu Mar 14 20:39:00 UTC 2024 |