Search by job, company or skills

8-10 Years
Not Disclosed
  • Posted 9 hours ago
  • Be among the first 10 applicants

Job Description

Required Technical Skills & Qualifications

• 8+ years of experience as a Database Architect, Data Modeler, or Principal Engineer focused on relational database design.

• Expert-Level Data Modeling: Deep expertise in conceptual, logical, and physical data modeling. Advanced mastery of time-interval logic and state-machine modeling is mandatory.

• Proven Bi-Temporal Modeling Experience: Practical experience implementing bitemporal architectures (tracking both valid/effective time and transaction/assertion time).

• Complex Graph & Hierarchy Modeling: Proven ability to model shifting, real-world relationships, recursive hierarchies (conglomerates), and many-to-many associations that change over time.

• API Architecture Fluency: Strong background advising backend teams on data access layers. You must understand how to abstract database complexity into clean application APIs.

• RDBMS Proficiency: Deep familiarity with modern relational databases (PostgreSQL or similar) and how they implement range types, advanced indexing, and integrity constraints.

More Info

Job Type:
Industry:
Employment Type:

Key Skills

Time-Interval Logic

State-Machine Modeling

Graph Hierarchy Modeling

Range Types

Integrity Constraints

API Architecture

Bi-Temporal Modeling

Advanced Indexing

Similar Jobs

10-12 yrs
Chennai, India
Skills:
data engineering , snowflake , Erwin, Data Modeling, SQL Server, Data Warehousing, Sql, Performance Tuning, Normalization, Data Modeling Tools, Denormalization
10-12 yrs
Chennai, India
Skills:
Data Modeling, Power Bi, Dimensional Modeling, Sql, Data Warehousing, Star and Snowflake schemas, Primary and foreign keys, Sigma, Conceptual Data Modeling, Physical Data Modeling, Normalization and denormalization, Semantic Layer, North Star Data Modeling, Ontology Layer, Hierarchies and relationships, Fact and Dimension modeling, Context Layer, logical data modeling, Business rules and data definitions
7-9 yrs
Bengaluru, India
Skills:
Solution Design, Redshift, Physical Data Modeling, Data flow design, Conceptual data modeling, logical data modeling, Matillion, Data Modeling Techniques and Methodologies
5-10 yrs
Bengaluru, India
Skills:
data vault , Data Lineage, Metadata Management, Data Modeling, Dimensional Modeling, Sql, ELT, Data Quality, Erwin, Data Lake, Data Warehousing, Etl, Er Studio, ER Modeling, powerdesigner, Physical Data Modeling, Source-to-Target Mapping, logical data modeling, Lakehouse
3-10 yrs
Hyderabad, India
Skills:
Data Modeling, LLMs, Data Vault methodologies, RAG techniques, Data Lakehouse, workflow orchestration, snowflake schemas, AI agents, 3NF, Modernization Architecture