Data Modeller GCP & Cloud Databases Hire On Contract Club

6.0 - 10.0 years

0 Lacs

chennai, tamil nadu

On-site

As a Data Modeller specializing in GCP and Cloud Databases, you will play a crucial role in designing and optimizing data models for both OLTP and OLAP systems. Your expertise in cloud-based databases, data architecture, and modeling will be essential in collaborating with engineering and analytics teams to ensure efficient operational systems and real-time reporting pipelines. You will be responsible for designing conceptual, logical, and physical data models tailored for OLTP and OLAP systems. Your focus will be on developing and refining models that support performance-optimized cloud data pipelines, implementing models in BigQuery, CloudSQL, and AlloyDB, as well as designing schemas with indexing, partitioning, and data sharding strategies. Translating business requirements into scalable data architecture and schemas will be a key aspect of your role, along with optimizing for near real-time ingestion, transformation, and query performance. You will utilize tools like DBSchema for collaborative modeling and documentation while creating and maintaining metadata and documentation around models. In terms of required skills, hands-on experience with GCP databases (BigQuery, CloudSQL, AlloyDB), a strong understanding of OLTP and OLAP systems, and proficiency in database performance tuning are essential. Additionally, familiarity with modeling tools such as DBSchema or ERWin, as well as a proficiency in SQL, schema definition, and normalization/denormalization techniques, will be beneficial. Preferred skills include functional knowledge of the Mutual Fund or BFSI domain, experience integrating with cloud-native ETL and data orchestration pipelines, and familiarity with schema version control and CI/CD in a data context. In addition to technical skills, soft skills such as strong analytical and communication abilities, attention to detail, and a collaborative approach across engineering, product, and analytics teams are highly valued. Joining this role will provide you with the opportunity to work on enterprise-scale cloud data architectures, drive performance-oriented data modeling for advanced analytics, and collaborate with high-performing cloud-native data teams.,

Posted 3 days ago

Apply

Data Modeler Virtusa

12.0 - 15.0 years

12 - 15 Lacs

Chennai, Tamil Nadu, India

On-site

Job Title: Data Modeler Key Responsibilities As a Data Modeler, you will: Data Model Design: Perform hands-on data modeling for both OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) systems, covering Conceptual, Logical, and Physical data modeling. Database Performance Optimization: Apply a strong understanding of indexing, partitioning, and data sharding, with practical experience, to optimize database performance, especially for near-real-time reporting and application interaction. Tool Utilization: Work with at least one data modeling tool, preferably DBSchema or Erwin. GCP Database Understanding: Leverage a good understanding of GCP databases like AlloyDB, CloudSQL, and BigQuery. Collaboration: (Implied) Collaborate with teams to understand requirements and translate them into data models. Mandatory Skills & Experience Technical Proficiency: Data Modeling: Hands-on experience in data modeling for OLTP and OLAP systems . Modeling Concepts: In-depth knowledge of Conceptual, Logical, and Physical data modeling . Database Performance: Strong understanding of indexing, partitioning, data sharding , with practical experience. Performance Variables: Strong understanding of variables impacting database performance for near-real-time reporting and application interaction. Modeling Tools: Working experience on at least one data modeling tool, preferably DBSchema or Erwin . GCP Databases: Good understanding of GCP databases like AlloyDB, CloudSQL, and BigQuery . Experience & Qualifications: Demonstrated experience in applying database optimization techniques (indexing, partitioning, sharding). Essential Professional Skills Domain Knowledge (Plus): Functional knowledge of the mutual fund industry will be a plus.

Posted 1 month ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.