*Senior Database Architect in OH for 3+ Months Contract !! *
*Reply me on rachel.l...@itbtalent.com <rachel.l...@itbtalent.com>*Columbus
Ohio
3+ Months
*Interview Type: In Person Only. *
*Interview Dates scheduled for April 2 & 3, 2015.*
*Two roles.*
*Skills:*
Experience working as a data modeler in business intelligence,
analytics and Enterprise Data Warehousing environments Required 10
Years Experience
with design, development and support of normalized data structures
(commonly referred to as Inmon) Required 10 Years Experience developing
Data Warehouse databases using Oracle RDBMS platform and tools Required 7
Years Experience with Kimball (Dimensional Modeling) and Inmon methodologies
Required 5 Years Experience with the AllFusion Erwin modeling tool (7.3,
8 and 9.0.0), including Model Mart Repository advanced features (e.g. check
in/out, complete c Required 5 Years Experience analyzing data profiling,
data mining, data cleansing, data content, scrubbing data, and translating
data via rules from one database to an Required 5 Years Experience with
Data Warehouse tools and techniques (ETL tools, STAR schemas, etc.) Required
5 Years Experience with STAR Schema structures, theories, principles, and
best practices, Data Governance, Data Quality Management, Metadata
Management, and C Required 5 Years Strong Data Modeling skills to
include data quality, source systems analysis (DB2, Oracle, VSAM , etc)
business rules validation, source to target map Required 5 Years Software
development experience with Oracle RDBMS 11g Desired 3 Years Software
development experience with IBM DB2 SQL Desired 1 Years Skill in the use of
organizational tools & methods (MS Excel, MS Word, MS Outlook, PowerPoint,
Visio, Clarity) Desired 3 Years Experience performing peer reviews
Desired 1 Years Ability to effectively communicate with business and IT
staff Desired 4 Years Ability to quickly adapt to changes, enhancements,
and new technologies Desired 1 Years Ability to establish and maintain
positive collaborative relationships with team members Desired 2 Years High
energy levels and tolerance for tight deadlines and time pressures Desired 2
Years
*Description:*
BWC is implementing a new Claims, Policy and Billing system. This new
implementation is shifting our Data warehouse and Reporting infrastructure
from DB2/Hyperion to Oracle/Cognos. The nature of our data is also
changing, as data elements are changing purpose and semantics as part of
the transition.
BWC’s new system will have a transaction data store (TDS), operational data
store (ODS) and a newly designed Oracle Enterprise Data Warehouse (EDW).
With the move to an EDW, BWC will also be shifting from a relational based
data warehouse towards dimensional/star-schema models. This position will
be required to aid BWC in this shift. Additionally, this position will be
responsible for taking requirements and designing, creating, tuning and
supporting Oracle Data Warehouse databases.
• Experience working as a data modeler in business
intelligence, analytics and Enterprise Data Warehousing environments
• Experience with design, development and support of normalized
data structures (commonly referred to as Inmon)
• Experience developing Data Warehouse databases using Oracle
RDBMS platform and tools
• Experience with Kimball (Dimensional Modeling) and Inmon
methodologies
• Experience with the AllFusion Erwin modeling tool (7.3, 8 and
9.0.0), including Model Mart Repository advanced features (e.g. check
in/out, complete compare, naming standards and reverse engineering)
• Experience analyzing data profiling, data mining, data
cleansing, data content, scrubbing data, and translating data via rules
from one database to another
• Experience with Data Warehouse tools and techniques (ETL
tools, STAR schemas, etc.)
• Experience with STAR Schema structures, theories, principles,
and best practices, Data Governance, Data Quality Management, Metadata
Management, and Conceptual and Logical Data Design.
• Strong Data Modeling skills to include data quality, source
systems analysis (DB2, Oracle, VSAM , etc) business rules validation,
source to target mapping design, prepare sample data example and data
validation with ETL team (SCD 1, SCD 2 types tables and Fact tables)
• Software development experience with Oracle RDBMS 11g
• Software development experience with IBM DB2 SQL
• Skill in the use of organizational tools & methods (MS Excel,
MS Word, MS Outlook, PowerPoint, Visio, Clarity)
• Experience performing peer reviews
• Ability to effectively communicate with business and IT staff
• Ability to effectively communicate with business and IT staff
• Ability to quickly adapt to changes, enhancements, and new
technologies
• Ability to establish and maintain positive collaborative
relationships with team members
• High energy levels and tolerance for tight deadlines and time
pressures
Regards
Rachel Lian
Technical Recruiter
Desk No :201-855-4204
Princeton Forrestal Village
116 Village Blvd, Suite 200
Princeton - New Jersey 08540
rachel.l...@itbtalent.com | Gmail:rachel.lain...@gmail.com
www.itbrainiac.com
If you prefer not to receive emails from us, simply reply to this e-mail
with the word "REMOVE" in the subject line.
--
You received this message because you are subscribed to the Google Groups "SAP
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sap-or-oracle-financials+unsubscr...@googlegroups.com.
To post to this group, send email to sap-or-oracle-financials@googlegroups.com.
Visit this group at http://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.
