Role description
Primary Skills Database Lead Data Modelling database Oracle TD Cassandra PG
Database Design Develop conceptual logical and physical data models eg using relational dimensional or NoSQL databases
Requirement Analysis Collaborate with stakeholders to translate business needs into technical specifications and data structures
Data Optimization Optimize data query performance and ensure database scalability
Data Governance Maintain data integrity security and adherence to data management standards
Documentation Create and maintain comprehensive documentation including data dictionaries and ER diagrams
Collaboration Work with ETL developers data architects and analysts to integrate new data sources
Required Skills and Qualifications
Technical Proficiency Strong SQL skills along with experience in data modeling tools eg Erwin ERStudio and database systems eg Oracle SQL Server PostgreSQL MongoDB
Modeling Techniques Expertise in ER modeling Dimensional modeling StarSnowflake schemas and Data Vault techniques
Education Bachelors degree in Computer Science Data Analytics Information Systems or a related field
Experience Typically requires 37 years of experience in data design and management
Preferred Qualifications
Experience with ETL tools and data warehouse solutions
Familiarity with cloud data platforms eg Snowflake AWS Redshift Azure Synapse
Knowledge of Python or R for data manipulation
Skills
Mandatory Skills : Dimensional Data Modeling
About LTM
LTM is an AI-centric global technology services company and the Business Creativity partner to the world’s largest and most disruptive enterprises. We bring human insights and intelligent systems together to help clients create greater value at the intersection of technology and domain expertise. Our capabilities span integrated operations, transformation, and business AI — enabling new ways of working, new productivity paradigms, and new roads to value. Together with over 87,000 employees across 40 countries and our global network of partners, LTM — a Larsen & Toubro company — owns business outcomes for our clients, helping them not just outperform the market, but to Outcreate it. Please also note that neither LTM nor any of its authorized recruitment agencies/partners charge any candidate registration fee or any other fees from talent (candidates) towards appearing for an interview or securing employment/internship. Candidates shall be solely responsible for verifying the credentials of any agency/consultant that claims to be working with LTM for recruitment. Please note that anyone who relies on the representations made by fraudulent employment agencies does so at their own risk, and LTM disclaims any liability in case of loss or damage suffered as a consequence of the same. Recruitment Fraud Alert - https://www.ltimindtree.com/recruitment-fraud-alert/