Title: Data Warehouse Data Modeler
Location: San Diego, CA
Duration: 3+ Months
Required Skills:
Data Warehouse Data Modeler
Duties Include:
• Produce and document logical and physical data models, and maintain the Enterprise Data Modeling repository using Erwin data modeling tool.
• Create and execute DDL scripts for Oracle tables, views, partitions, indexes, constraints, relationships, sequences, triggers, and procedures in development and QA instances.
• Create and execute DML scripts for Oracle data maintenance in development and QA instances.
• Maintain respository of scripts, ensure version control, and migrate scripts from development to QA. Prepare script packages with instructions for production implementation.
• Assist data architects and DBA with Oracle database tuning, security management, instance performance monitoring, tablespace utilization, schema object management, database capacity planning.
• Assist developers with application design and performance tuning.
• Coordinate testing with other development groups and operations.
• Provide support for development and production systems.
Required Skills and Experience:
• Minimum 5 years of experience in designing conceptual, logical and physical data models, data dictionary maintenance, and metadata management.
• Exceptional ERWin 7.2 or later modeling skills are mandatory. Oracle is mandatory.
• Minimum 3 years of experience in dimensional data modeling (Kimball methodology required) and business intelligence tools.
• Excellent SQL skills for complex data analysis and data quality assurance. Strong analytical and problem solving capabilities.
• Hand-on experience with Oracle tablespaces, indexes, partitions, query performance tuning and production support.
• Must be self-motivated and have the ability to work as part of a group, or, at times, independently.
• Excellent English including oral and written communication skills.
Preferred Skills and Experience:
• Familiarity with business processes including sales, marketing, manufacturing, procurement, and supply chain management.
• Previous experience or strong skills as an Oracle DBA.
• Knowledge of SAP and Oracle Enterprise-One.
• Hands-on experience with Cognos, Business Objects, or Microstrategy.
• Knowledge of ETL architecture and Informatica or similar ETL tool.
Thanks,
Sree | Ph: 732-413-0551 | Fax: 732-562-8778 | sjonna@allegiantinfo.com | 15 Corporate Place South | Suite 352 | Piscataway, NJ 08854
_______________________________________________________________________________________________________________________________________________________________________________
-- CONFIDENTIALITY NOTICE --
This e-mail and the documents accompanying this transmission are confidential and may be a communication privileged or protected by law. It is meant for only the intended recipient. If you received this e-mail in error, any review, use, dissemination, distribution or copying of the e-mail is strictly prohibited. Please notify the sender immediately of the error by return e-mail and please delete the message from your system. Thank you in advance for your cooperation.
--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To post to this group, send email to sureshotjobs@googlegroups.com.
To unsubscribe from this group, send email to sureshotjobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sureshotjobs?hl=en.
No comments:
Post a Comment