Data Modeling

Design develop and maintain Conceptual Data Models (CDM) Logical Data Models (LDM) and Physical Data Models (PDM) for enterprise data platforms.

Perform data mapping and transformation from source systems (such as Eclipse) to target Data Lake environments.

Build and optimize data ingestion preparation and transformation pipelines using Azure Databricks and Azure Data Factory (ADF).

Develop and implement data engineering transformation logic using PySpark and Azure Databricks.

Create master and subject-area Entity Relationship (ER) diagrams using ERwin Data Modeler 14.0.

Perform reverse engineering of database schemas using Databricks API connections within ERwin.

Collaborate with business stakeholders architects and development teams to understand data requirements and translate them into scalable data models.

Ensure data quality consistency governance and adherence to enterprise data standards.

Troubleshoot design develop and deploy cloud-based data integration solutions on Azure.

Support data migration integration and modernization initiatives across enterprise platforms.

Participate in design reviews documentation testing and production support activities.