Hello Partners, **
Hope you are doing great.**** I have a requirement as below and I would like you to check with you on this requirement.**** I can be reached via email: [email protected] or phone: 217-321-1964** ** ** *337854--Data Architect* *Harrisburg, PA* *10 Months* *Either Web Cam or In Person interview* ** ** 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* *Your Experience* *Last Used* 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 * ** ** ** ** ** ** -- **** Regards, Patrick Smith (PAT)**** [email protected]* *Lead IT Corp. - Springfield, IL**** 1999 Wabash Avenue,**** Suite 210,**** Springfield, IL 62704**** Desk: 217-321-1964**** Board: 217-909-2384 X 101**** Fax: 801.705.2524**** http://www.leaditgroup.com | **** Check us out: [image: http://leaditgroup.com/Content/images/facebook.png]<http://www.facebook.com/pages/Lead-I-T-Corporation/121013161326563> [image: http://leaditgroup.com/Content/images/twitter.png]<https://twitter.com/LeadITCorp> **** *Microsoft and Oracle Partner | A Certified MBE Company | E Verified Employer***** *Best staffing firms to work for - under the category large over 200 employees Best staffing firms to work for - under the category Temp/Contract. **** * ** ** -- You received this message because you are subscribed to the Google Groups "CorptoCorp" 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/corptocorp. For more options, visit https://groups.google.com/groups/opt_out.
<<image002.png>>
<<image001.png>>
