Description

You will design and implement data architectures across various business domains, ensuring integrity, compliance, and performance.

This role is on-site.

Responsibilities

• Develop and enhance conceptual, logical, and physical data models for OLTP systems.
• Design generic models for file processing, document processing, hierarchies, auditing, and notifications.
• Translate business requirements into structural data models that ensure data integrity and compliance.
• Optimize database structures for storage, retrieval, and analysis while maintaining security and performance standards.
• 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 and Oracle database environments.
• 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