Data Modelling

Conceptual, Logical, Physical Modelling

Expert

Erwin, ERStudio, PowerDesigner, SAP PowerDesigner, Lucidchart

ER & Dimensional Modelling

Data Vault

SQL & Querying

Advanced SQL, Optimisation, Performance Tuning

Expert

SQL Workbench, Toad, DBeaver

Database Design

Normalisation/Denormalization

Expert

Oracle, SQL Server, PostgreSQL, MySQL

Cardinalities & Constraints, Partition strategy

Data Warehousing

ETL/ELT Processes

Expert

Informatica, Talend, Azure Data Factory, Snowflake, Databricks

Data Integration, SCD, Different type of Schema

Business data analysis

Data profiling, Business data analysis, Data products,

Advanced

Business domain/knowledge

Cloud & Big Data

Cloud Data Platforms

Advanced

AWS Redshift, Azure Synapse, GCP BigQuery, Hadoop, Spark





Distributed Data Modelling

Data Governance

Metadata Management

Advanced

Collibra, Alation, Informatica Data Quality

Data Quality & Compliance, Data lineage

Programming

Python for Data Wrangling

Intermediate

Python (Pandas, NumPy), Shell Scripts

Scripting for Automation

BI & Visualisation

Reporting & Dashboards

Intermediate

Power BI, Tableau

Version Control

Model Versioning & Deployment

Intermediate

Git, GitHub, CI/CD Pipelines

Emerging Trends

Data Mesh, Data Fabric, AI-driven Modelling

Awareness

Databricks, AI Modelling Tools

📌 Data Modeler (India)
🏢 TalentOla
📍 India