Description

Key Skills: OLAP, Data modeling, GCP

Roles and Responsibilities:

  • Hands-on data modelling for OLTP and OLAP systems.
  • In-depth knowledge of Conceptual, Logical, and Physical data modelling.
  • Strong understanding of Indexing, Partitioning, Data Sharding, with practical experience of having done the same.
  • Strong understanding of variables impacting database performance for near-real-time reporting and application interaction.
  • Should have working experience on at least one data modelling tool, preferably DBSchema or Erwin.
  • Good understanding of GCP databases like AlloyDB, CloudSQL, and BigQuery.
  • People with functional knowledge of the mutual fund industry will be a plus.
  • Should be willing to work from Chennai, office presence is mandatory.

Skills Required:

  • Data Modelling (OLTP and OLAP)
  • Indexing, Partitioning, Sharding
  • Performance Tuning for Real-Time Reporting
  • Data Modelling Tools (DBSchema, Erwin)
  • GCP: AlloyDB, CloudSQL, BigQuery

Education: Relevant Bachelor's or Master's degree in Computer Science, Information Technology, or a related field

Education

Any Graduate