Dear Partner,
We have client requirements. Please send the resume to [email protected] *Position: Data Architect* *Location: Harrisburg, PA* *Duration:09/03/2013 till 06/30/2014* *Client: Commonwealth Of PA* Position Description: This position will be responsible for leading the logical and physical data modeling efforts to support transactional (OLTP) and analytical (OLAP) solutions on large enterprise projects from IT portfolio. Responsibilities will include logical and physical data modeling, design and creation of database objects (e.g., tables, views, stored procedures) and working closely with the business users, developers, and DBA’s. Specific Duties: 1. Serve as the lead in developing large, complex logical and physical data models for transactional and analytical solutions. 2. Attend periodic project meetings with business and technical team members to gather requirements and to report on the status of data modeling efforts. 3. Work closely with the business and application development team in building the logical and physical data models. 4. Build these data models using AllFusion Erwin data modeling tool. 5. Resolve any issues and answer any questions the development teams or DBA’s have regarding the physical data models. 6. Create DDL for submission to DBAs for creation of databases in pre-production and production environments. 7. Design and develop indexes, views, check constraints, triggers, and stored procedures for submission to DBA’s for creation in the databases in pre-production and production environments. 8. Manage all change to the physical data model and facilitate a model-driven database development effort. 9. Assist developers and DBA’s with query development and optimization and make any required changes to the physical data model to improve query performance and efficiency. Skills and Experience: 1. Required: 5+ years of OLTP data modeling (logical and physical) 2. Required: 2+ years as a lead data architect with sole responsibility for large OLTP data models 3. Required: 10+ years overall IT experience 4. Required: Experience using Erwin or similar data modeling tool(s) 5. Required: Strong Structured Query Language (SQL) skills 6. Required: 3+ years of database development in a DB/2, Oracle or SQL Server 7. Required: Highly developed oral and written communication skills 8. Desired: Experience working with Mainframe DB2 9. Desired: Experience working with Oracle 11g 10. Desired: Experience with analytical (OLAP) data models in a data warehouse environment 11. Desired: Experience using Erwin data modeling tool 12. Desired: Experience working as an application developer in Java or .NET Skill Required / Desired Amount of Experience Overall IT experience Required 10 Years OLTP data modeling (logical and physical) experience. Required 5 Years Lead Data Architect experience with the sole responsibility for large OLTP data models. Required 2 Years Experience using Erwin or similar data modeling tool(s) Required Strong Structured Query Language (SQL) skills Required Database development experience in DB/2, Oracle or SQL Server Required 3 Years Highly developed oral and written communication skills Required Experience working with Mainframe DB2 Desired Experience working with Oracle 11g Desired Experience with analytical (OLAP) data models in a data warehouse environment Desired Experience using Erwin data modeling tool Desired Experience working as an application developer in Java or .NET Desired Thanks & Regards, *Sadhan kumar |* *Infolob Solutions Inc.|* | Office: 972-535-5559 Ext 107 | Fax: 888-228-4125 |Email: [email protected] |www.infolob.com | *A MBE COMPANY | ORACLE PLATINUM PARTNER COMPANY* --------------------------------------------------------------------------------------------------- Note: We respect your Online Privacy. This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] <[email protected]> and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" 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-vendor. For more options, visit https://groups.google.com/groups/opt_out.
