Next Level Business Services, Inc.
Position Details
Position Title:
Data Modeler
Location:
Hartford/ Windsor, CT
Hire Type:
Full Time Only
Job Description
Needs to know dimensional and/or operational/3NF/transactional modeling.
Needs to be able to focus heavily on data dictionary and mapping document work.
with XML schema designing skills (using ACORD framework) in addition to modeling
Must be very good at profiling sources and mapping them into the target model.
Should have worked on any modeling tool like Erwin, rational etc.
Excellent communication to interact with the business customers
Property & Casualty Insurance domain experience is nice to have.
Leverage any Industry Data Models (Framework) Eg IBM Insurance Model (IIW; IAA), Retail Data Warehouse
Must know the industry standard logical naming methods, Metadata management process
Experience Experience Required: 7 years
Will be directly working with clients and offshore counter-parts
Skills and Qualifications
OLTP design knowledge
ODS/3NF Relational Modeling
Data profiling knowledge (Tools: Trillium; Oracle DQ tool)
Rate your Oracle/Erwin skills
What kind of large projects you have been handling? Roles?
Relevant Experience (number of years)
Interaction/collaboration with external (BA, Architect, Development) teams
Tell me about data modeling in ODS
Which subject areas you worked on ODS subject area
Availability for Interviews
data analysis, normalized, 3NF
transient database management, account management, part day on a daily basis
irrespective nature of data how do you handle it data loads
how did you separate old records from new records to track the timing of the transaction
how would identify the latest transaction in an ODS atomic/ OLAP dimension?
time-variant / time-invariant surrogate keys? Link latest single instance of the customer with history data in ODS?
Additional Information All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr
Data Modeler
Location:
Hartford/ Windsor, CT
Hire Type:
Full Time Only
Job Description
Needs to know dimensional and/or operational/3NF/transactional modeling.
Needs to be able to focus heavily on data dictionary and mapping document work.
with XML schema designing skills (using ACORD framework) in addition to modeling
Must be very good at profiling sources and mapping them into the target model.
Should have worked on any modeling tool like Erwin, rational etc.
Excellent communication to interact with the business customers
Property & Casualty Insurance domain experience is nice to have.
Leverage any Industry Data Models (Framework) Eg IBM Insurance Model (IIW; IAA), Retail Data Warehouse
Must know the industry standard logical naming methods, Metadata management process
Experience Experience Required: 7 years
Will be directly working with clients and offshore counter-parts
Skills and Qualifications
OLTP design knowledge
ODS/3NF Relational Modeling
Data profiling knowledge (Tools: Trillium; Oracle DQ tool)
Rate your Oracle/Erwin skills
What kind of large projects you have been handling? Roles?
Relevant Experience (number of years)
Interaction/collaboration with external (BA, Architect, Development) teams
Tell me about data modeling in ODS
Which subject areas you worked on ODS subject area
Availability for Interviews
data analysis, normalized, 3NF
transient database management, account management, part day on a daily basis
irrespective nature of data how do you handle it data loads
how did you separate old records from new records to track the timing of the transaction
how would identify the latest transaction in an ODS atomic/ OLAP dimension?
time-variant / time-invariant surrogate keys? Link latest single instance of the customer with history data in ODS?
Additional Information All your information will be kept confidential according to EEO guidelines.
#J-18808-Ljbffr