Hi,
My Name is Ajay Singh and I'm 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
Additional InformationAll your information will be kept confidential according to EEO guidelines.
Top Skills
What We Do
Created in the early 1990s, the iliad Group is the inventor of the world’s first triple-play box and has grown into a major European telecoms player, standing out for its innovative, straightforward and attractive offerings.
The Group is the parent of Free in France, iliad in Italy and Play in Poland, has over 16,500 employees serving 45.3 million subscribers, and generated €7.6 billion in pro forma revenues in 2021.
In France, the Group is an integrated Fixed and Mobile Ultra-Fast Broadband operator and had over 21.2 million retail subscribers at September 30, 2022. On March 23, 2021, the iliad Group launched its BtoB business in France under the Free Pro brand.
In Italy – where the Group made its entry in 2018 under the iliad brand, becoming the country’s fourth mobile operator – it had over 9.4 million subscribers at end-September 2022.
With the acquisition of Polish mobile operator Play in November 2020, which currently has 14 million subscribers, the iliad Group became Europe’s sixth-largest mobile operator by number of subscribers.
