Design and maintain conceptual, logical, and physical data models for enterprise and analytical data platforms.
Analyse existing data sources and schemas to identify relationships, redundancies, and optimization opportunities.
Ensure data model alignment across bronze, silver, and gold layers in the Data Lakehouse environment.
Work with ETL/ELT developers (Informatica, Datastage, or equivalent) to validate data flow and model integration.
Collaborate with data governance and architecture teams to maintain data lineage, metadata, and standards.
Support performance tuning, normalization/denormalization, and indexing strategies.
Document data definitions, business keys, and transformation rules clearly and accurately.
Participate in model reviews and sign-off sessions with stakeholders and architects.
Required Skills and Qualifications
5-10 years of experience in data modeling and database design.* Proficiency with data modeling tools(ERwin, PowerDesigner, or equivalent).
Strong SQL skills and understanding of data warehouse / data lake / data lakehouse concepts.
Understanding of Teradata FSLDM & FSAS models. (Good to have)
Hands-on experience with Teradata, Cloudera, Informatica, or Denodo preferred. (Good to have)
Solid understanding of ETL/ELT processes, data governance,and metadata management.
Excellent communication and analytical skills; ability to work across business and technical teams.
About Mechispike :
+ Mechispike Solutions Pvt Ltd ( https://mechispike.com/ ) is a fast-growing Niche PLM company. We are registered in India, Germany & USA.
+ We are trusted by 15+ large global MNCs across India, USA and Germany. For Clientele, https://mechispike.com/
+ PLM Knowledge & Subscribe PLM ROI page. https://www.linkedin.com/newsletters/plm-roi-7112683161041473536/
+ We leave no stone unturned to accommodate the interests of our employees; for our Employee Benefits & Employee reviews & Openings https://mechispike.com/careers/
+ Register your profile with us: https://mechispike.com/quickapplication/
+ We have attractive packages for immediate to 30-day joiners & Skilled PLM developers.
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.