Dear Associates,
Hope you are doing great! *Please reply to **[email protected] <[email protected]> * This is Ali Ahmed from Exatech Inc. We have an immediate need for below mention requirement, if you feel that you are a perfect match to this requirement, please forward your most updated resume along with the best time and number to carry out further discussions. Looking forward to hear from you... *Role: Data Architect* *Location: Monterey Park, CA* *Duration: Long Term* *Rate: $/hr on C2C All incl.* *Interview: Telephone + Skype* *Required Skills:* The Data Modeler/architect will be responsible for the design and development of the logical and physical data model based on source systems. Architect data modeling solutions for Data Warehouse and down streams. Facilitate consistent business analysis, data acquisition and access analysis and design, database management Systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the group level. *Essential Functions:* · Extensive background in data architecture design, data management, data migration and integration with emphasis on both high end OLTP and Business Intelligence solutions. Design, build and extend the IBM data model; Logical and Physical Data Model. · Analyze Business Requirements, design logical data models and systems functions and present to stakeholders. · Coordinate and interact with technical and business groups within the department. · Define data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects. · Ensure existing data/information assets are identified, stewarded and leveraged across the enterprise. · Review, verify and approve the Conceptual and Logical data models done by the owner teams for modeling standards, naming convention and properly defining all objects and relationships. · Convert the Logical models in to Physical models, and generate the delta or forward engineer DDL script, and execute in the database. · Create complex views and materialized views and tune for performance. · Administer and manage the users and privileges on Erwin or ER/Studio Data Architect tool & Portal Repository server. · Manage the repository server and all projects to follow the best standards and to keep them in sync with Prod. · Create/modify macros in the ER/DA tool to generate more user friendly reports in aiding the creation of the business glossary document in the format requested by business. · Enable enterprise wide metadata management using the MDR and Colibra tools. · Publish data models, conduct training on DW model to developers, BAs, DAs, and QA resources. · Mentor staff, direct and document application design strategies. *Technology:* IBM Banking Data Model; Erwin; M1; Modeling and mapping tool. *Primary Skills:* Architectural/Data Modeling/Data Mapping in the banking Model; Modeling Tools; Banking. *Experience:* 12 years of experience in BDW; Data Modeling and Data Mapping. Leadership qualities Banking product knowledge on capital markets products (derivatives, options & futures, fixed income, etc.) or Core Banking products (loans, deposits, treasury – FX & Money Market, Trade Finance). *Qualifications:* · Bachelor’s degree with 12+ years of banking & financial services industry experience designing dimensional models for financial data warehouse products using industry standard tools such as Embarcadero (preferred) and Erwin. · Data warehouse concepts and strong Dimensional Data modeling experience is required. · Data Quality and Data Governance concepts and experience is required. · Exposure to Informatica ETL or Business Intelligence tools is preferred. · Excellent inter-personal and communication skills. · Excellent mentoring skills. · Must work well in a team environment. · Model maintenance via portal/website a plus. Regards *Ali Ahmed* *Exatech Inc* 4758 Forest Ridge Dr Mason OH 45040 Phone: 513-433-5531 Email: [email protected] Web: www.exatechinc.com -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
