Job Seekers, Please send resumes to resumes@hireitpeople.com

Sr Data Architect,Modeler,Erwin,ER Studio,Oracle,SQL

Minimum Requirements:

Top 5-10 technical skills required for the job:
• Conceptual, logical, and physical data modeling skills
• Relational and dimensional data model design skills
• ER/Studio 8/9 data modeling tool skills
• Oracle 10g/11g SQL/PLSQL skills
• Application DBA skills

• 8+ years of experience in data modeling, relational and dimensional
• 8+ years of experience with Erwin or ER/Studio tools. 2+ years in ER/Studio
• 8+ years of experience with Oracle PL-SQL, stored procedure, triggers, partitions
• 8+ years of experience with OLTP and OLAP database design
• 5+ years of experience in performance tuning of Oracle queries
• 3+ years of experience as an Oracle application DBA 
• 2+ years of experience in Oracle archiving strategy
• Experience with high volume of transaction and EIM data
• Working experience in data architecture and modeling using industry best practices
• Understanding of data integration architecture, ETL, and strategy
• Strong verbal, presentation, and written communication skills
• Strong initiative, ability to self manage, and also work in a team environment

Critical Skills:

• Conceptual, logical, and physical data modeling skills
• Relational and dimensional data model design skills
• ER/Studio data modeling tool 8/9 skills
• Oracle 10g/11g SQL/PLSQL skills

Preferred Skills: • Experience in IBM Mainframe such as IMS and DB2
• Experience in ER/Studio portal
• Experience in Informatica PowerCenter
• Experience in Unix (AIX) shell scripting
• Experience in Financial projects
• Experience in Data migration projects

Bachelors in Computer Science or equivalent.

Description:

Job Description
• Perform data analysis on the legacy and the future state systems
• Design conceptual, logical, and physical data models based on business requirements and use cases
• Generate, maintain, and deploy DDL to implement databases for development and testing environments
• Manage deployment release versions 
• Develop scripts for data population, validation, archiving, partitioning, etc.
• Provide end-to-end data solutions for a mainframe to distributed migration project
• Conform design to client Data modeling guidelines and naming standards
• Provide design artifacts and documentations
• Communicate with data architects/developers, SMEs, Infrastructure DBA,