Title: Sr. Engineer -Data Modeler - Google BQ
Job Description
Role Purpose
The purpose of this role is to design, test and maintain software programs for operating systems or applications which needs to be deployed at a client end and ensure its meet 100% quality assurance parameters
͏
Must have
- Data Engineer Profie
- Strong SQL / OLTP / OLAP
- Cloud SQL/GCP BQ Exp. is Must.
- Scala/ SPark /
- Erwin/DBschema/MS Visio/ ER Studio/
- Airflow
JD:
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).