Next Level Business Services, Inc.
Data Modeler
Next Level Business Services, Inc., Madison, Wisconsin, us, 53774
Position Title: Data ModelerLocation: Hartford/ Windsor, CTHire Type: Full Time OnlyJob 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.Experience 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 skills to interact with business customers.Property & Casualty Insurance domain experience is nice to have.Leverage any Industry Data Models (Framework) e.g., IBM Insurance Model (IIW; IAA), Retail Data Warehouse.Must know the industry standard logical naming methods, Metadata management process.Experience Required:
7 yearsWill be directly working with clients and offshore counterparts.Generic Managerial Skills:
Need good verbal/written communication and analytical skills.Prescreening Questions:
OLTP Design knowledgeODS/3NF Relational ModelingEmail IDLeverage any Industry Data Models (Framework) e.g., IIW, IBM Retail Data WarehouseRate your Oracle/Erwin skillsData profiling knowledge (Any tools: Trillium; Oracle DQ tool)What kind of large projects have you 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 have you worked on ODS subject area?Availability for InterviewsData analysis, normalized, 3NFTransient database management account management, part day on a daily basisIrrespective nature of data, how do you handle data loads?How did you separate old records from new records to track the timing of the transaction?How would you identify the latest transaction in an ODS atomic/OLAP dimension?Time-variant / time-invariant surrogate keys? Link the 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
Needs to know dimensional and/or operational/3NF/transactional modeling.Needs to be able to focus heavily on data dictionary and mapping document work.Experience 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 skills to interact with business customers.Property & Casualty Insurance domain experience is nice to have.Leverage any Industry Data Models (Framework) e.g., IBM Insurance Model (IIW; IAA), Retail Data Warehouse.Must know the industry standard logical naming methods, Metadata management process.Experience Required:
7 yearsWill be directly working with clients and offshore counterparts.Generic Managerial Skills:
Need good verbal/written communication and analytical skills.Prescreening Questions:
OLTP Design knowledgeODS/3NF Relational ModelingEmail IDLeverage any Industry Data Models (Framework) e.g., IIW, IBM Retail Data WarehouseRate your Oracle/Erwin skillsData profiling knowledge (Any tools: Trillium; Oracle DQ tool)What kind of large projects have you 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 have you worked on ODS subject area?Availability for InterviewsData analysis, normalized, 3NFTransient database management account management, part day on a daily basisIrrespective nature of data, how do you handle data loads?How did you separate old records from new records to track the timing of the transaction?How would you identify the latest transaction in an ODS atomic/OLAP dimension?Time-variant / time-invariant surrogate keys? Link the 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