Required Skills: Building Data Models in OLTP systems, design and optimize database structures, Data Migration, data integration

Job Description

• Develop, maintain, and enhance conceptual, logical, and physical data models for various business domains and applications.
• Experience in building Data models in OLTP Systems from the scratch.
• Experience in building generic DATA models for File Processing, Document Processing, Hierarchy models, Data Auditing, Notifications.
• Translate business requirements into data models ensuring structural integrity and compliance with organizational standards.
• Design and optimize database structures to support data storage, retrieval, and analysis.
• Collaborate with database administrators and developers to implement data models in database systems (SQL Server, Oracle).
• Ensure data integrity, security, and performance through proper database design and optimization techniques.
• Perform data profiling, analysis, and validation to identify inconsistencies and anomalies.
• Collaborate with stakeholders to elicit, analyse, and document data requirements.
• Create clear and comprehensive documentation of data models, including entity-relationship diagrams, data dictionaries, and metadata.
• Support data integration projects by mapping data sources to target data models and designing data transformation processes.
• Facilitate data migration efforts, ensuring seamless transition of data from legacy systems to new platforms or environments.
• Work closely with business analysts, developers, and project managers to align data modelling efforts with project timelines and objectives.
• Conduct quality assurance reviews of data models to ensure accuracy, completeness, and usability.
• Identify and resolve data model-related issues, such as performance bottlenecks, data anomalies, and schema conflicts.
• Contribute to the overall success of the team by actively participating in meetings, sharing insights, and contributing innovative ideas.