[İş Radarı](https://jobradar.live/) / [Jobs](https://jobradar.live/ilanlar) / Data Modeler

Active
On-site
Madison, WI, United States
Posted · 10.03.2016
SmartRecruiters (US)

# Data Modeler

Next Level Business Services, Inc.

Hi, My Name is Ajay Singh and Im a Resource Manager at Next Level Business Services, Inc. Please find the Job Description below and respond with an expected salary range?. suitable time to call and contact details?. Also, attach a copy of your updated resume. Position Title: Data Modeler Location: Hartford/ Windsor, CT Hire Type: Full Time Only Job Description:- 1) Needs to know dimensional and/or operational/3NF/transactional modeling. 2) Needs to be able to focus heavily on data dictionary and mapping document work. 3) with XML schema designing skills (using ACORD framework) in addition to modeling 4) Must be very good at profiling sources and mapping them into the target model. 5) Should have worked on any modeling tool like Erwin, rational etc. 6) Excellent communication to interact with the business customers 7) Property & Casualty Insurance domain experience is nice to have. 8) Leverage any Industry Data Models (Framework) Eg IBM Insurance Model (IIW; IAA), Retail Data Warehouse 9) Must know the industry standard logical naming methods, Metadata management process Experience Required 7 years Roles & Responsibilities Will be directly working with clients and offshore counter-parts Generic Managerial Skills Need good verbal/written communication/Analytical skills. Pl provides us some Prescreening Questionnaires to input into Taleo? OLTP Design knowledge ODS/3NF Relational Modeling Email ID Leverage any Industry Data Models (Framework) Eg : IIW, IBM Retail Data Warehouse Rate your Oracle/Erwin skills Data design Artifact creation/support process (Mapping document) Data profiling knowledge (Any tools : Trillium; Oracle DQ tool) What kind of large projects you have been handling? Roles? Relevant Experience (number of years) Interaction/collaboration process 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 record with new records to track the timing of the transaction. how would identify the latest transaction in a ODS atomic/ OLAP dimension ? time-variant / time-invariant surrogate keys ? Link latest Single instance of the customer with history data in ODS? ü Have you handled multiple source integration ? Thanks, Ajay Singh All your information will be kept confidential according to EEO guidelines.

This job was verified from SmartRecruiters (US). Applications are completed on the original source.

[Apply on the original listing ↗](https://jobradar.live/ilan/da24fec1-c75e-4336-9a95-6232a994b860/git)

## Stop searching one by one for roles like this.

Upload your resume or enter your target roles to see your first 3 matches for free.

[Find jobs for me →](https://jobradar.live/uye/kayit)
Your resume is never shared with employers; it is processed only for matching.

Something wrong with this job?