04 Aug
|
Coforge
|
Telangana
Job Title: Data Modeller
Skills: Data Modelling
Experience: 5 - 13 years
Location: Greater Noida, Hyderabad, Pune
We at Coforge are hiring Data Modeler with the following skillset
We are seeking an experienced Data Modeler with robust expertise in Dimensional Modelling, Data Warehousing, Data Vault Modelling, Data Profiling, Enterprise Data Modelling, Data Governance, and Data Lineage. The ideal candidate will be responsible for designing scalable, high-performance data models that support enterprise reporting, analytics, and business intelligence
Mandatory Skills
- Dimensional Modeling (Star Schema, Snowflake Schema)
- Data Warehouse Concepts & Architecture Data Vault Modeling (Hub, Link, Satellite)Fact and Dimension Table Design SQL
- Data ProfilingCanonical / Enterprise Data Modeling
- Performance Optimization & Data Governance
- Data Lineage and Metadata Management
Key Responsibilities
- Design, develop, and maintain conceptual, logical, and physical datamodels.Create and optimize Fact Tables and Dimension Tables for enterprise reporting and analytics.
- Develop and implement Data Vault models to support scalable and auditable data warehouse solutions.
- Perform SQL-based data profiling to analyze data quality, completeness, consistency, and business rule adherences
- Design and maintain Canonical/Enterprise Data Models across multiple business domains.
- Define and document data lineage from source systems to reporting and analytics layers.Collaborate with business stakeholders, data architects, ETL developers, and BI teams to understand data requirements.
- Implement data governance standards, data quality controls, and metadata management processes.
- Optimize data models and queries for performance, scalability, and maintain ability.
- Create and maintain data dictionaries, business glossaries, and model documentation.
Required Qualifications
5+ years of experience in Data ModelLing and Data Warehouse projects.
- Strong expertise in SQL and relational database concepts. Hands-on experience with Data Vault 2.0 methodology.
- Experience designing Enterprise Data Models and Dimensional Models.
- Strong understanding of fact tables, dimension tables, surrogate keys, and slowly changing dimensions (SCDs).Experience in data profiling, data quality assessment, and lineage tracking.
- Excellent analytical and problem-solving skills.
Preferred Skills
- Experience with cloud data platforms such as AWS, Azure, or GCP
- Exposure to data governance tools such as Collibra, Informatica EDC, Alation, or Purview.
- Knowledge of ETL/ELT tools and modern data platforms.
- Familiarity with Agile/Scrum methodologies.
📌 Data Modeller (Telangana)
🏢 Coforge
📍 Telangana