From: Wendy Joe <
wendy.joe@princetoninformation.com>
Subject: Data Architec/Modeler contract opportunity
To:
jcsspike@yahoo.com Date: Wednesday, October 17, 2012, 10:10 AM
10/17/12 10:03 AM
Hello,
My name is Wendy and I'm an IT recruiter at Princeton Information. Our records show that you are an experienced Data Architec/Modeler. This experience is relevant to at least one of my current openings.
This is a LONG TERM CONTRACT ROLE in Jersey City
All candidates must currently have the lawful right to reside and remain in the United States and must be authorized without sponsorship to work in the U.S.
Client is seeking W2 candidates or INDEPENDENT corps only for this role:
Princeton Information is seeking a Data Architect/Data Modeling resource for the following -
• Design and build database structure and objects that best support operational and analytics application
o Assess and analyze data requirements for applications and/or problems
o Translate data requirements into database structures for optimal performance and availability
o Implement, test and debug physical database objects for performance and troubleshooting
• Design and implement optimal star and snowflake schema in the database
• Communicate and collaborate with team members and management on the designed database structures and schemas
o Write and present eloquently with the appropriate audience perspective in mind
• Support troubleshooting of production issues of existing application as warranted
• Participate in collaborative discussions with team members to monitor progress against enhancement queue and bug resolution.
• Stay proactive in identifying potential risks/issues due to the overall application design and make recommendations for improvements
• Design and implement highly available and scalable architecture for database environment and its required SLAs
• Develop and implement strategies for data partitioning to support applications' scalability and availability needs
• Develop and implement strategies for data federation, replication and virtualization
• Develop and implement strategies for data archival and recovery (for both primary and remote sites)
• Ensure alignment of objects design with the enterprise defined data governance and architecture principles
• Support the specification and construction of the designed objects to completed solution
• Research and select appropriate database technology and tools for effective management and troubleshooting
• Define and develop reusable database strategies to be leveraged across enterprise database management systems
• Continue to expand the knowledge and specialization in the evolving database technology and architecture
• Drive design of data structures within an ODS/EDW environment (all layers)
• Create Conceptual/Logical/
Physical models for EDW staging, data integration, and reporting.
• Conduct Model reviews with project team members;
• Publish and communicate models to various IT and business-based teams, explaining how the model meets Use Cases.
• Drive metadata capture through data modeling application (Erwin) and maintain the repository and exchange of metadata through the various tools
• Promote and follow Enterprise Architecture standards, guidelines, and best practices around EDW data modeling efforts
• Develop data movement requirements/technical specifications into and across EDW layers
• Collaborate with Solution Architect and BI team to create data structures that facilitate data integration and meet/exceed reporting and analytical requirements.
• Perform SQL optimization and tuning
Position Requirements:
Core Competency:
• Excellent oral & written communication skills; Proficient with SDLC
• Self motivated, goal oriented, and organized; team player; works independently with self prioritization of activities to support organization objectives
• Demonstrated analytical and strong innovative ability with wide implementation skills; Good technical and problem solving skills
• Project management responsibilities include identifying the scope of assigned projects, generating solutions to technical issues, and providing deliverables in a timely and efficient manner.
Technology :
• Oracle 11g/10g RAC; Oracle Partitioning, Oracle OLAP, Star Schema configuration, Materialized views,
• Working knowledge of warehouse Oracle functions (e.g. Rollup etc.), Star Schema design using Bitmap indexes is a must
• Operating Systems- AIX, Solaris, RedHat Linux
• Data Virtualization/Federation technology – preferably MetaMatrix
• 10+ years experience as a Data Architect/Data Designer in a Global Enterprise – preferably in financial industry and 3+ years experience in a team lead role
• Good understanding of design principles of master data management, operational stores, data marts, datawarehouse system
If you are qualified, available, interested, planning to make a change, or know of a friend who might have the required qualifications and interest, please E-MAIL ME A COPY OF YOUR RESUME AND PLEASE include a daytime phone number so I can reach you. In considering candidates, time is of the essence, so please respond ASAP.
Referrals are greatly appreciated! Princeton pays a referral fee for anyone we place within six months of the referral who is not currently in our database of $1,000 for engagements where the bill rate is over $40 per hour or $500 for engagements where the bill rate is at $40 per hour or lessafter 90 days on billing.
Sincerely yours,
Wendy Joe
.........................
Note: Please allow me to reiterate that I chose to contact you either because your resume had been posted to one of the internet job sites to which we subscribe, or you had previously submitted your resume to Princeton Information. I assumed that you are either looking for a new employment opportunity, or you are interested in investigating the current job market.
If you are not currently seeking employment, or if you would prefer I contact you at some later date, please indicate your date of availability so that I may honor your request. In any event, I respectfully recommend you continue to avail yourself to the employment options and job market information we provide with our e-mail notices.
Thanks again.
Wendy Joe
............................
Princeton Information
100 Harborside Financial Center, 11th Floor
Jersey City, NJ 07311
201-604-9900
MIS Ntwk Assoc Mtg Date
Oct 9th - Tues Reg Mtg - 6 pm - Berman Larson Kane Offices, Paramus - DO NOT use GPS for directions. Get dir from BLK site - Bring 15 copies of your resume 
