Cloud Data Warehouse Modeler - 10+ Years
- Willware Technologies
- 10 - 17 years
- Hyderabad
- 4 months ago
- Email to a friend
- Report this job
Job Description
Role: Cloud Data Warehouse Modeler
Company Name: WillWare Technologies
Location: Bangalore / Hyderabad / Noida / Gurgaon / Pune / Mumbai / Chennai / Kochi
Work Mode: Onsite / Full-time
Experience: 10+Years
Job Description:
- Extensive experience modelling designing, optimizing, and maintaining structured and semi-structured data models in any cloud data warehouse (e.g. in either BigQuery, Amazon Redshift, Microsoft Azure Synapse Analytics etc.) for analytical and operational use cases.
- Knowledge of cloud storage and processing optimizations (in either BigQuery, Amazon Redshift, Microsoft Azure Synapse etc.) , ensuring efficient data structuring for cost-effective querying and scaling.
- Strong understanding of normalized and denormalized data modelling techniques, including Star and Snowflake schemas, to support efficient querying and reporting.
- Proficiency in writing efficient SQL queries, using techniques like partitioning, clustering, and materialized views to enhance performance and cost-effectiveness.
- Ability to determine the right balance between normalization and denormalization to optimize query performance while maintaining data integrity.
- Expertise in defining and evolving schemas over time to accommodate business needs while minimizing disruptions and ensuring backward compatibility.
- Experience implementing data validation, consistency checks, and schema enforcement to maintain data accuracy, completeness, and reliability.
- Strong emphasis on data documentation, including entity-relationship diagrams (ERDs), data dictionaries, and lineage tracking to improve data discoverability and usability.
- Knowledge of BigQuerys storage and processing optimizations, ensuring efficient data structuring for cost-effective querying and scaling.
- Ability to work closely with data engineers,analysts, and business teams to align data models with business needs, ensuring best practices in data architecture
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: IT & Information SecurityRole Category: IT Infrastructure ServicesRole: IT Infrastructure Services - OtherEmployement Type: Full timeContact Details:
Company: Willware TechnologiesLocation(s): Hyderabad+ View Contact
Keyskills: BigQuery Amazon Redshift Data Modeling Data Warehousing Data Architecture SQL queries Data Architecture Principles cloud data warehouse Microsoft Azure Data Governance Microsoft Azure Synapse
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in