Description

You will design and implement data architectures across various business domains.

Responsibilities

• Develop, maintain, and enhance conceptual, logical, and physical data models.
• Build OLTP data models from scratch and design generic models for file processing, document processing, hierarchies, auditing, and notifications.
• Translate business requirements into structural data models that ensure integrity and compliance.
• Optimize database structures for storage, retrieval, and analysis while ensuring security and performance.
• Create technical documentation including entity-relationship diagrams, data dictionaries, and metadata.

Required Skills

• Proven experience building data models in OLTP systems from the ground up.
• Expertise in SQL Server.
• Expertise in Oracle.
• Experience designing models for file and document processing.
• Ability to design hierarchy, auditing, and notification models.
• Skill in mapping data sources to target models for integration projects.
• Experience conducting data profiling and anomaly detection.
• Ability to resolve schema conflicts and performance bottlenecks.

Preferred Skills

• Collaborate with DBAs and developers to implement models in SQL Server and Oracle environments.
• Perform data profiling, validation, and mapping to support integration and migration from legacy systems.

Key Skills

Education

Any graduate