Data Modeler - SQL (8-13 yrs)

Job Description :

- Hands-on experience in data modelling for both OLTP and OLAP systems.

- In-depth knowledge of Conceptual, Logical, and Physical data modelling.

- Strong understanding of indexing, partitioning, and data sharding with practical experience.

- Experience in identifying and addressing factors affecting database performance for near-real-time reporting and application interaction.

- Proficiency with at least one data modelling tool (preferably DBSchema).

- Functional knowledge of the mutual fund industry is a plus.

- Familiarity with GCP databases like AlloyDB, CloudSQL, and BigQuery.

- Willingness to work from Chennai (office presence is mandatory).

- Strong SQL / OLTP / OLAP

- Cloud SQL/GCP BQ Exp. is Must.

- Scala/ SPark /Erwin/DBschema/MS Visio/ ER Studio/Airflow

- ++ Datawarehouse - DWH data modeling with a bottom up approach