Job Title:
Data modeler with Erwin and SQL
Company: LTIMindtree
Location: Vizianagaram, Andhra pradesh
Created: 2026-03-29
Job Type: Full Time
Job Description:
Skill – Strong Data modeler with Erwin and SQL experience.Experience – 5 – 10 yrsNotice Period – Immediate to 30 daysLocation is Chennai, Pune , Bangalore, Hyderabad Job Description : Delivery focused Senior Data Modeller Erwin Key Responsibilities : Design and maintain conceptual logical and physical enterprise data models using ErwinData Modelling tool Lead the reverse engineering of legacy databases to consolidate fragmented schemas intocanonical enterprise objects Define and enforce modelling standards keys and relationships to drive convergence oflegacy systems Implement temporal modelling patterns including SCD effectivedating historisation andEoD snapshots for critical reporting and analytics Ensure data models support scalable analytics AI and robust metadata management whilebalancing accuracy with performance Collaborate with stakeholders and the enterprise modelling team to align with governancestandards Required Skills Experience : Mandatory Strong handson expertise with Erwin Data Modeler and SQL includingconceptuallogicalphysical modelling and reverse engineering Mandatory Proven track record of delivering data models working closely with businessdevelopment and testing teams Mandatory Extensive experience modelling financial services domains securities tradespositions pricing accounts counterparties for largescale data platforms with a focus onperformance and storage efficiency Deep expertise in temporal modelling SCD effective dating historisation snapshot models Ability to challenge existing designs and collaborate with architects and domain experts toenhance data models Experience rationalizing and converging multiple legacy schemas into strategic canonical dataobjectsDesirable Securities lending domain experience